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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply