Search
InstantDoc ID
GO

Browse By: Author | Issue

March 28, 2008 04:28 PM

Further Explorations in Plan-Cache Metadata

Drill deeper into query plan details by using 3 dynamic management views
Rating: (0)
Kalen Delaney
SQL Server Magazine
InstantDoc ID #97975

Executive Summary:
Microsoft SQL Server 2005 provides several dynamic management views that you can use to obtain detailed information about cached query plans. You can use the sys.dm_exec_text_query_plan function to view details about specific statements in a query. Two additional views, sys.dm_exec_requests and sys.dm_exec_query_stats, give you information such as the sql_handle and plan_handle for the current statement, resource-usage statistics, and performance statistics for cached query plans.


SQL Se...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Hi Kalen,

It's nice to see your article again about SQL Server internal. :) It is valuable for my skill to do query tuning. Just keep writing for every issues (In March issue I miss your article).

I am your regular reader and have read your books : Storage Engine, Query tuning and optimization. Those are great books.

Best Regards,

Kasim Wirama

Kevin4/17/2008 8:58:36 PM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.