Performance Counters

Question

Performance Counters

John Hanrahan

Hall of Fame

Points: 3825
More actions
March 11, 2015 at 11:04 pm

#295941

Comments posted to this topic are about the item Performance Counters

Viewing 11 posts - 1 through 11 (of 11 total)

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

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 1

Interesting question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 2

I knew it's possible but didn't know that it could be with the -x option in the startup options.

Thanks

Igor Micev,My blog: www.igormicev.com

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 3

I knew it's possible but didn't know that it could be with the -x option in the startup options.

Thanks

Igor Micev,My blog: www.igormicev.com

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

I didn't know about the startup option either. Learning something new is always a good start to the day. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Revenant

SSC-Forever

Points: 42467

March 12, 2015 at 10:54 am

#1783651

Very simple and straightforward - thanks, John!

david.gugg SSCertifiable Points: 6143 More actions · Answer 6

What would be the purpose?

Be still, and know that I am God - Psalm 46:10

Hany Helmy SSChampion Points: 13921 More actions · Answer 7

Igor Micev (3/12/2015)
I knew it's possible but didn't know that it could be with the -x option in the startup options.
Thanks

+ 1 same here

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 8

akljfhnlaflkj

SSC Guru

Points: 76202

March 16, 2015 at 7:00 am

#1784237

Thanks for the question.

John Hanrahan Hall of Fame Points: 3825 More actions · Answer 9

The purpose is to glean every last possible amount of performance from your system. I was reviewing white papers on virtualization and noticed it. Check the second link, somewhere in there the -x is mentioned. Microsoft says it has no effect (according to the blog) and I did not test it.

Jeff_C Old Hand Points: 344 More actions · Answer 10

I believe that you can also set a reg key to do this. http://blogs.technet.com/b/pfelatam/archive/2011/08/08/sql-performance-counters-are-missing.aspx

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Disable Performance Counters

Regards.

Performance Counters

Cookies on SQLServerCentral