patternsqlMinor
SQL Server performing slow
Viewed 0 times
sqlperformingslowserver
Problem
I have a Microsoft SQL Server running on an IBM server with 10 cores and 64 GB RAM.
I have from 100 to 300 users working concurrently on the server.
Users complain about slowness of the application. I've checked the server and found CPU usage is 6%, RAM usage is 4GB, and network usage is up to 1Mbps. I have a 4Mbps dedicated line.
I've tried to collect other information on the server such as
The Average resource wait time is 40 sec.
I am unable to interpret the cause. Can anyone suggest a way to resolve this?
If any further information is required, I can provide that.
EDIT:
As suggested, I've added the following items:
Page Life Expectancy 3
IO stats Snapshot
Wait Statistics
Server information
Memory status
Query Execution List
I have from 100 to 300 users working concurrently on the server.
Users complain about slowness of the application. I've checked the server and found CPU usage is 6%, RAM usage is 4GB, and network usage is up to 1Mbps. I have a 4Mbps dedicated line.
I've tried to collect other information on the server such as
Blocking and Wait Statistics:The Average resource wait time is 40 sec.
I am unable to interpret the cause. Can anyone suggest a way to resolve this?
If any further information is required, I can provide that.
EDIT:
As suggested, I've added the following items:
Page Life Expectancy 3
IO stats Snapshot
Wait Statistics
Server information
Memory status
Query Execution List
Solution
Following discussions in chat, we've established:
Suggested fixes are:
- 32bit Enterprise SQL Server.
- 3.5GB of memory in use (no AWE/PAE).
- 2.1GB database with 1.3GB buffer pool.
- Page life expectancy of 3 seconds.
Suggested fixes are:
- AWE/PAE as a quick fix so the database fits in memory.
- Investigate the frequently called, highest IO queries identified.
- Consider rebuild to 64bit.
Context
StackExchange Database Administrators Q#23580, answer score: 7
Revisions (0)
No revisions yet.