April 24, 2009 at 5:25 am
Could anyone please tell me about accumulating performance counters in SQL server 2005, particularly those that relate to cpu, memory, locks etc... ? which are the performance counters that can be logged daily to improve the performance ?
April 24, 2009 at 6:13 am
Hi
This entirely depends upon what your requirement is, can you please let us know what you are trying to do 🙂
April 24, 2009 at 6:29 am
Hi. I am new to DB administration. Its a general task. my task is to check the performance counters (DMV) and wait statistics that will give an accumulated results (not counters that give per second results) for cpu-time, memory, locks, page faults etc.. so that those can be logged on daily basis for improving the performance of the sql server. Could you tell me what are the useful counters and waits that gives useful information for performance tuning?
April 24, 2009 at 8:39 am
Personally, I'd suggest you'd be better off collecting this information from Performance Counters in the Performance Monitor utility rather than using the DMV. It doesn't capture OS level information, and that's a lot of what you need. I wrote this basic article[/url] a while back. It might be helpful.
"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
April 24, 2009 at 8:50 am
Thankyou very much for the reply. 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply