Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, March 22, 2014 1:06 AM
Points: 59, Visits: 157
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:30 PM
Points: 14,802, Visits: 27,275
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1452867
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse