January 22, 2013 at 2:23 am
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.
January 22, 2013 at 2:37 am
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/
January 22, 2013 at 2:53 am
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----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 3:22 am
Am ready to purchase a material on perfmon counters. Please suggest a best materail on this.
January 22, 2013 at 3:29 am
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----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply