March 11, 2015 at 11:04 pm
Comments posted to this topic are about the item Performance Counters
March 12, 2015 at 3:12 am
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2015 at 4:52 am
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
March 12, 2015 at 4:52 am
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
March 12, 2015 at 5:55 am
I didn't know about the startup option either. Learning something new is always a good start to the day. Thanks.
March 12, 2015 at 10:54 am
Very simple and straightforward - thanks, John!
March 12, 2015 at 12:55 pm
What would be the purpose?
Be still, and know that I am God - Psalm 46:10
March 15, 2015 at 6:33 am
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
March 16, 2015 at 7:00 am
Thanks for the question.
March 16, 2015 at 10:20 am
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.
March 17, 2015 at 4:25 am
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.
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy