Sql-server – SQL Server performing slow

performancesql serversql-server-2008

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 Blocking and Wait Statistics:

enter image description here

enter image description here

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

enter image description here

IO stats Snapshot

enter image description here

Wait Statistics

enter image description here

Server information

enter image description here

Memory status

enter image description here

Query Execution List

enter image description here

Best Answer

Following discussions in chat, we've established:

  • 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.
Related Question