February 4, 2010 at 4:11 am
hi,
I have a database of 250GB.
Everything works fine when there are less than 60 users connected.
But it becomes very slow when there are more users (100)
What could be the problem.? Can anyone suggest me solution.
Now am analysing the trace file in tuning advisor.
Thanks in afvance.
February 4, 2010 at 4:22 am
Have you checked CPU Utilization, Memory Avg Disk que Lenght, Reads, Writes, etc and made a comparison between when the system was performing well and compared that benchmark to when the system starts performing slow?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 4, 2010 at 6:49 am
Tuning Advisor, assuming it works correctly, and that's a huge assumption, will only suggest indexes for you. Indexes are not necessarily the problem. You need to gather performance metrics to understand what's happening on the server. This means using perfmon to put together performance counters. Here's a basic article on monitoring from Microsoft. I would also strongly recommend you analyze wait states. Here's an excellent article from Microsoft on how to do that. It will point out to you what the server is waiting on. From there you can begin to address the cause.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 4, 2010 at 8:55 am
Thanks alot to all for the guidance.
Will try and revert back.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply