SQL Server will have some tools to help you find those bottlenecks. 2005 is supposed to have a lot of new features, but I haven't used it. You can also use Performance Monitor and look at disk activity. I believe the counters come with an explanation of each metric and what acceptable values are. If not, you can Google them.
We had ours on a RAID 5 on a SAN and we moved it to a larger RAID 10 set on a different SAN and it made a world of difference. We were seeing long waits in API and SQL calls, low CPU usage, and no network saturation. It wouldn't take long for a chain of blocked database processes to block all of our AR Server threads, resulting in slow response. Examination of the blocking processes showed they were all waiting on some process that held a lock on a table or index or whatever that all the other processes needed to access. Examination of our SAN showed it was being overworked. Switching to RAID 10 alleviated all those problems. Chad Hall (501) 342-2650 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Craig Carter Sent: Tuesday, January 15, 2008 12:27 PM To: arslist@ARSLIST.ORG Subject: Re: Server Configuration Recommendations Hi Phil, I believe it is RAID 5 and there is a lot of disk I/O but it doesn't seem to be excessive. What tools do you recommend to evaluate that other than Task Manager? It's a progressive thing-the more that log in, the worse it gets so I'm more inclined to believe we have some excessive database activity. I'm getting tired of getting beat up by the users so I'm looking for any recommendations of things to look for. Good to hear from you, Craig Carter ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Phil Murnane Sent: Tuesday, January 15, 2008 11:08 AM To: arslist@ARSLIST.ORG Subject: Re: Server Configuration Recommendations Craig: What does the server resource utilization look like when you go from 80 to 100 users? Is there lots of paging or some heavy disk I/O? I'm sure you've looked in this direction, but perhaps we can offer a fresh pair of eyes. One thing I've seen kill database performance is if the DB is stored on a RAID 5 volume and there's lots of write activity. If the database starts looking like the bottleneck, this might be something to pursue. FWIW, __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ************************************************************************* The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. ************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"