Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Tracing Tools
- Thread starter kennethho
- Start date
mikewoodhouse
Programmer
You might want to have a look at CAST (
For those of use who aren't familiar with MSSQL's Tools/Profiler, what kind of information are you hoping to get?
A fair amount of information is available via a combination of these SET commands:
SET SHOWPLAN ON
SET STATISTICS IO ON
SET STATISTICS TIME ON
There are also some trace flags documented in the Performance and Tuning guide--and, there are any number of 3rd-party performance analysis tools.
BOL,
JMC
J M Craig
Alpha-G Consulting, LLC
nsjmcraig@netscape.net
A fair amount of information is available via a combination of these SET commands:
SET SHOWPLAN ON
SET STATISTICS IO ON
SET STATISTICS TIME ON
There are also some trace flags documented in the Performance and Tuning guide--and, there are any number of 3rd-party performance analysis tools.
BOL,
JMC
J M Craig
Alpha-G Consulting, LLC
nsjmcraig@netscape.net
- Status
Similar threads