Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Statistics Prof... » SQL Server 2005   (RSS)
Friday, June 01, 2007 9:51 AM

Store Statistics XML in database tables using SQL Traces for further analysis.

Since SQL Server 2005, query plan as well as statistics of query execution can be captured in XML format. Also, SQL Server 2005 has XQuery support to directly query XML document. By combining these two new features, users can analyze the query plans using
Posted by queryproc | 2 Comments
Friday, October 20, 2006 1:57 PM

Statistics Profile Output Formatting

Statistics profile output is an important tool when it comes to troubleshooting query plan issues. When enabled, it returns a textual representation of the query plan with a lot of detail about cost and cardinality estimates as well as actual counts.
Posted by queryproc | 0 Comments
Attachment(s): statspro.pl
Friday, September 29, 2006 3:16 PM

Introduction to Showplan

Showplan is a feature in SQL Server to display and read query plans. While some of you may already be very familiar with Showplan, it is one of the most important diagnostic tools that we use in the query processing team to locate and identify problems,
Posted by queryproc | 0 Comments
Attachment(s): showplan_blog.bmp
 
Page view tracker