StartUp parameters description in SQL Service Properties
In the sql server configuration Manager once we find the services. Right click on the service and go to properties and Advanced tab. Check the start up parameters. Below are the description for the parameters.
-d switch specifies
the database file
-l switch specifies
the log file
-T which
enables you to start given trace flags for all the connections for sql server
instance.
To monitor
trace flags –T1204 and to turn on trace flag to monitor deadlocks in the
instance.
-f switch
places sql server in minimal mode and only allow single connection. –f option
correct the memory setting.
-g switch is
used to reserve the additional memory outside SQL Server main memory pool for
use by extended stored procedures. If the –g switch is not used the default of
256MB of memory is allocated to this area.
-m the “-m”
switch puts sql server in single-user mode (sometimes called master recovery
model) and suspends the CHECKPOINT process which writes data from disk to
database device.
-k switch
new to sql server 2008,is used influence the Checkpoint frequency.
Comments