Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 492 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

Query Execution Statistics

Available for Members and Guests. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.

 Article Abstract:

(Greg Larsen) In my last article I talked about tracking performance of TSQL statements (http://www.sql-server-performance.com/articles/per/tsql_statement_performance_p1.aspx). In that article I discussed a number of different ways to obtain performance information for your query statement or set of statements. One of my methods I mentioned to obtain query statistics was to use the “sys.dm_exec_query_statistics” dynamic management view (DMV). In this article I’m going expand on the usage of the “sys.dm_exec_query_stats” DMV. I will also be exploring other DMVs and related dynamic management functions (DMFs) that can be used to gather additional performance information that SQL Server 2005 maintains.

 Read this article...


Note: by becoming a registered guest (free), you'll have access to this article.


Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004