Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Performance Counters Scripts Expand / Collapse
Posted Monday, May 13, 2013 6:38 AM


Group: General Forum Members
Last Login: Wednesday, March 9, 2016 3:48 AM
Points: 112, Visits: 297
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.
Post #1452074
Posted Tuesday, May 14, 2013 4:11 AM



Group: General Forum Members
Last Login: Yesterday @ 12:29 PM
Points: 17,173, Visits: 32,140
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
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1452482
Posted Tuesday, May 14, 2013 3:48 PM



Group: General Forum Members
Last Login: Yesterday @ 2:36 AM
Points: 7,933, Visits: 14,357
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

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
Post #1452867
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse