June 24, 2009 at 10:34 am
One of our machine is started giving timeout error and IO related error. We have increased the memory size to * GB but sitll getting the same issue. In order to checkt the memory bottleneck, Ihave captured following counters.
Machine is VM and has 8 GB RAM.
Can somebody tell me if these counter looks ok
Cache Data Map Hits 100
Memory Available bytes 1497823382
Memory Cache Bytes 111059244
Memory comimtted Bytes 6573048407
Memory Page Faults/sec 478
Memory pages /sec 34
Memory pool Nonpaged bytes 52465264
Paging file % usage 2
As far as I know that all the counters looks good except Memory pages/sec which is 34. I think it should be less then 20 pages per sec. ?
Any help appreciated.
June 24, 2009 at 10:46 am
Please check any blockings,CPU and memeory usage in SQL server and find which process is taking high CPU utilization in SQL server
June 24, 2009 at 12:44 pm
You need to look at the queues and wait states counters. That will tell you what is slowing down. From there you can determine what's causing it.
"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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply