May 13, 2013 at 6:38 am
Can you please any body give me all Performace Counters script, which generate report including all performance counters in SQL Server 2005.
Performace COUnters Ex:CPU,Physio IO,Disk Reads and Writes,Buffer Cache Hit Ratio,Blockings,Dead Locks..etc.
May 14, 2013 at 4:11 am
You want someone to give you their entire hand-built monitoring system?
For the SQL Server related counters you can just look at sys.dm_os_performance_counters. That will let you run queries to bring back that information. But to put together a full monitoring package, you should step outside of what you can get from T-SQL only and set up Perfmon.exe counters as well as possibly using extended events to capture query execution.
"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
May 14, 2013 at 3:48 pm
I'm with Grant here. Time for you to put in some effort so 1. you yourself know and understand is actually running in your production environment, 2. you can explain to at least one other person, i.e. document it, and 3. you can interpret the information you are looking at when all this valuable information is collected.
This post helped me a ton back in the day. It might be a good start for you: SQL Server Perfmon (Performance Monitor) Best Practices by Brent Ozar December 30, 2006[/url]
Just keep in mind the date of the article. A lot has happened since then. In SQL 2008 new DMV information is available as is the Extended Event subsystem Grant mentioned.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply