Solved

-x SQL Startup Option

Posted on 2006-07-06
5
186 Views
Last Modified: 2008-02-01
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
Comment
Question by:adamkerrigan
  • 2
  • 2
5 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17054393
if you have any monitoring software that would check for these performance values, they will not get them.
0
 

Author Comment

by:adamkerrigan
ID: 17054665
i don't performance monitor my server...so i guess that wouldn't matter.

are there any noteable performance gains?

adam.
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 17054721
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
 

Author Comment

by:adamkerrigan
ID: 17054738
Would you turn it on in a 'normal' DB environment?

adam.
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17055954
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

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now