need book on perfmon counters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » need book on perfmon counters

need book on perfmon counters

Rate Topic

Display Mode

Topic Options

Author

Message

rajkiran.panchagiri

Posted Tuesday, January 22, 2013 2:23 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 26, 2013 4:15 PM
Points: 39, Visits: 402

Hi Team,

I need a material for sql perfmon counters. It should contain threshold values for those counters and definiton of those counters.

Thanks in advance.

Post #1409871

anthony.green

Posted Tuesday, January 22, 2013 2:37 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

http://www.quest.com/backstage/images/promotions/SQLServer-Perfmonance-Poster.pdf

Not a book but a good poster with some of the main perfmon counters of interest.

Other things
http://www.brentozar.com/sql/sql-server-performance-tuning/
http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ - Chapter 1, page 30 - 38.
http://www.simple-talk.com/books/sql-books/mastering-sql-server-profiler/

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1409878

Bhuvnesh

Posted Tuesday, January 22, 2013 2:53 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

rajkiran.panchagiri (1/22/2013)

I need a material for sql perfmon counters. It should contain threshold values for those counters and definiton of those counters.

Also There are tons of articles on this. you can start playing on your local or dev environment by setting the perfmon and see in article how they are judging based on given standards

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1409883

rajkiran.panchagiri

Posted Tuesday, January 22, 2013 3:22 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 26, 2013 4:15 PM
Points: 39, Visits: 402

Am ready to purchase a material on perfmon counters. Please suggest a best materail on this.

Post #1409889

Bhuvnesh

Posted Tuesday, January 22, 2013 3:29 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

rajkiran.panchagiri (1/22/2013)

Am ready to purchase a material on perfmon counters. Please suggest a best materail on this.

see the links provided by anthony above

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1409894

« Prev Topic | Next Topic »

Permissions