|
Misc.
Information
Configuration
Options
You will rarely benefit from turning on LIGHTWEIGHT
POOLING or PRIORITY BOOST or from increasing MAX WORKER THREADS. In 99.9% of cases this will actually slow performance and in some cases cause your computer to hang. Please make sure that you have followed the steps in this article to verify that your system actually benefits from
changing these setting to non-default values.
Q166967 INF: Proper SQL Server Configuration Settings
Back
to Top
SQLDiag
Ever wanted to run SQLDiag without going to your server
room or connecting through a remote control tool? Well, you can
run it from Query Analyzer as long as you are a sysadmin in SQL Server.
For SQL Server 7.0:
exec master..xp_cmdshell 'sqldiag -E -Oc:\SQLDiag.TXT'
For SQL Server 2000:
-- assumes default locations for your SQL install, update if necessary
declare @cmd varchar(255), @InstanceName varchar(255)
select @InstanceName = CONVERT(varchar(255), serverproperty('instancename'))
if @InstanceName IS NULL
select @cmd = '"c:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqldiag.exe" -Oc:\sqldiag.txt -E'
else
select @cmd = '"c:\Program Files\Microsoft SQL Server\MSSQL$' + @InstanceName + '\Binn\sqldiag.exe" -I' + @InstanceName + ' -Oc:\sqldiag.txt -E'
exec master..xp_cmdshell @cmd
Back
to Top
Settings
To find out some of the settings for your current connection, run
these commands.
DBCC TraceOn (3604) -- send results to the screen
DBCC TRACESTATUS(-1) -- are any trace flags set
DBCC UserOptions -- non-default settings for current connection
DBCC TraceOff (3604)
Back
to Top
SQL
Server Directory
How to Troubleshoot a
Performance Problem
Troubleshooting Blocking
How to Move a Database
Get the Latest Service Pack
Misc. Tips and Tools
SQL Server Knowledge Base Articles
Common
SQL Server Answers
SQL
Server and Related Links
Back to Top
Main SQL Server Page
|
