Know CPU TIME - 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

Transact-SQL (2005)

Know CPU TIME

Author

Topic

on7june
Starting Member

41 Posts

Posted - 2007-10-22 : 08:38:54

I want to know the time taken by the CPU to run a query and also the resource it utilizes.

Thanks in Advance

Sarvan

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-22 : 08:39:41

Run SQL Profiler.

E 12°55'05.25"
N 56°04'39.16"

Kristen
Test

22859 Posts

Posted - 2007-10-22 : 10:52:49

SET STATISTICS TIME ON / OFF

perhaps?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-22 : 21:53:24

And 'set statistics io'.

on7june
Starting Member

41 Posts

Posted - 2007-10-23 : 01:23:24

Thanks to all who replied for my query.

Sarvan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources