set stats on - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

set stats on

Author

Topic

tripatam
Starting Member

2 Posts

Posted - 2012-04-09 : 04:42:35

can any one explain how to identify issue by using this statement when your cpu utilisation goes high unexpectedly

set statistics io on
set statistics profile on
exec "Stored Procedure"
set statistics io off
set statistics profile off

waiting for your response

AK tripathi

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-04-09 : 09:25:15

set statistics io on - will display display information re: disk activity.
set statistics profile on - dispalys profile information
If you use SET STATISTICS TIME ON | OFF - this will give you relevant information for parsing,compiling,execution of each statement

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources