Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NA
Starting Member
1 Post |
 Posted - 2008-09-16 : 09:56:55
|
| Hello,Based on the following stats (every 3 minutes) what would the contributing factors for extreme slowness on the server?Buffer Distribution Buffers ---------------------- -----------Free 18GBMemory Grants Pending Memory Grants Outstanding22 2619 19418 23918 23837 6728 23333 227User Connections317350418466357392361423Buffer Manager\Page life Expectancy63896565674867646933710172687446762578047960Same time frame have .......2904 processes with lastwaittype 'RESOURCE_SEMAPHORE'11 processes with lastwaittype 'I/O COMPLETION'Thank you. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-16 : 13:22:16
|
| What about Memery pages/sec,Available Bytes and Buffer Cache Hit ratio? |
 |
|
|
|
|
|
Memory Issue