Is the SATA setup as disk storage pools? Is it filesystem or raw logical volumes?
What is the OS? vmstat or top/topas may give some ideas. What is the network transport? Fast ethernet? [RC] On Jul 27, 2007, at 2:49 AM, Craig Ross wrote:
10 days ago I Recently added 15TB of SATA storage and a new Fabric with 4 new LTO drives to our 3584 library, The DB is approx 90GB TSM Few days ago I noticed processing had ground to halt, after digging around I have found as soon as server gets busy maybe 4 processes 8 or so sessions the recovery log begins "sh logpinned" to pin and the Database gets locks. Shown by running "sh locks" And as result the server suffers! Now today I have stopped using the new Tech LTO 3 and SATA and things are coping better but still worse than previous as soon as load is increased Log pins and processing slows drastically. Are there any steps I can take which will help my scenario. Would a DB UNLOAD RELOAD help that much? Reference: Recovery log has heaps of room DB has heaps of room 90Gb DB with 100GB of room. Any advice is much appreciated.