• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

-x SQL Startup Option

Good Afternoon,

I see SQL has a startup option '-x' that apparently boosts performance.

"-x: Disables the keeping of CPU time and cache-hit ratio statistics. Allows maximum performance."

What are the ramifications of implementing this switch? and what is the syntax...i'm not finding an example at:

http://msdn2.microsoft.com/en-us/library/ms190737.aspx

(My guess is it replaces the -d on a normal startup entry.)

adam.
0
adamkerrigan
Asked:
adamkerrigan
  • 2
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if you have any monitoring software that would check for these performance values, they will not get them.
0
 
adamkerriganAuthor Commented:
i don't performance monitor my server...so i guess that wouldn't matter.

are there any noteable performance gains?

adam.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This option goes to the category "fine-tuning". if everything else is working fine, this can even give you some more needed performance on highly loaded servers (usually in big server farms). for "normal" database servers you will probably not be able to measuer the difference.
0
 
adamkerriganAuthor Commented:
Would you turn it on in a 'normal' DB environment?

adam.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Some Windows NT configurations ...
1) Boost SQL Server Priority on Windows NT
2) Changing the system properites so that the Performance Boost for the Foreground Application is set to None
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now