Total Query Wiat 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

SQL Server Administration (2005)

Total Query Wiat time

Author

Topic

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2011-09-08 : 18:55:57

Testing the Overall Query time executed on the server I got this formula.

Signal Wait Time + Resource Wait Time + CPU Time = Total Query Response Time

When I tried to get the information through the DMV sys.dmoswaitstats couldn't surface the DMV either in 2005 or in 2008.

Could anyone please let me know how to analyse the query time and what should use the DMV pertaining to that information.

Thanks All

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-08 : 19:38:36

I think you mean sys.dm_os_wait_stats

Also, see this article

Andy Kelly has written a bunch of articles on the topic in SQL Server Magazine as well.

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2011-09-13 : 20:52:58

Thanks Russel.

I understood it as sys.dmoswaitstats , however on using this formula is it ok to capture the Total Wait time?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources