Performance Counters

Question

Post reply

Performance Counters

VastSQL

SSC-Dedicated

Points: 36097
More actions
December 6, 2015 at 5:40 am

#399431

Hi Experts,
We have a SQL Server failover cluster environment and like to run performance counters to get a baseline.
Experts: Can you help me on this?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 1

Check out the following link https://technet.microsoft.com/en-us/library/cc781394(v=ws.10).aspx

Robert vd Berg SSC Eights! Points: 872 More actions · Answer 2

Though that list is a great starting point, I'd suggest you only add counters you actually understand. Imho, there is no use collecting data if you don't know what value means you need to act, and what actions you might need to change.

Robert van den Berg

Freelance DBA
Author of:

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

Take a look at the book "Troubleshooting for the Accidental DBA" That will give you plenty of knowledge to do this. Plus, it's free to download.

"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

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 4

johnwalker10 (12/6/2015)
Check out the following link https://technet.microsoft.com/en-us/library/cc781394(v=ws.10).aspx

Thanks John

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 5

Grant Fritchey (12/7/2015)
Take a look at the book "Troubleshooting for the Accidental DBA" That will give you plenty of knowledge to do this. Plus, it's free to download.

Thanks Grant.

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 6

Robert vd Berg (12/7/2015)
Though that list is a great starting point, I'd suggest you only add counters you actually understand. Imho, there is no use collecting data if you don't know what value means you need to act, and what actions you might need to change.

Thanks Robert

david.alcock SSCertifiable Points: 6021 More actions · Answer 7

Grant Fritchey (12/7/2015)
Take a look at the book "Troubleshooting for the Accidental DBA" That will give you plenty of knowledge to do this. Plus, it's free to download.

Huge thumbs up for this book. Massive amount of information and teaches the troubleshooting technique perfectly...and such an easy read too. Obviously I am a massive fan, but credit where credit is due. I even wrote a brief post on it.

http://sqlclarity.blogspot.co.uk/2015/12/troubleshooting-sql-server-guide-for.html

'Only he who wanders finds new paths'