SQL Server Performance Forum – Threads Archive

Where should I change startup parameters?

Should I change them in the Startup Parameter in SQL Server Properties (General Tab)
or Start parameters in the Services? I find this paragraph in BOL:
When specifying a trace flag with the /T option, use an uppercase "T" to pass the trace flag number. A lowercase "t" is accepted by SQL Server, but this sets other internal trace flags that are required only by SQL Server support engineers. (Parameters specified in the Control Panel startup window are not read.) Does this mean that setting /T in the Start parameters in the Services will have no effect?

In order to take affect of the trace flag parameter you need to specify under SQL Server properties General —> Startup parameters, nothing will take affect if specified under Services of control panel. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Satya, What other parameters will have no effect if specified under Services of control panel? I think the -c parameter may not be applicable.
Thanks.

For any startup parameters that must be specified under SQL SErver properties, not under Services of control panel. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Satya, So I should never put anything in the Start parameters in the SQL Server Services of the control panel.
Thanks.

I can’t speak intelligently about any other parameters, but… A while back I was going through the excersize of moving system databases on my test server. I messed up, and SQL wouldn’t start. It couldn’t find the master database because I had entered the path incorrectly. So, I went to Control Panel, Services, and changed the parameter for the location of the master database file there. Got SQL running again. Steve

PcSQL We had troubles in adding -g parameter under services — control panel and MS support suggested to apply this setting on SQL server properties rather than on the operating system level. (this may contradict Steve’s response, but within my exp. I wouldn’t suggest that)/ Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>