http://www.sqlservercentral.com/blogs/basits-sql-server-tips/2013/05/22/sql-server-index-related-dynamic-management-views-and-functions-part-3/

Printed 2014/09/21 04:38PM

SQL Server index related dynamic management views and functions (Part 3)

By Basit Aalishan Masood-Al-Farooq, 2013/05/22

With the release of SQL Server 2005 and later releases, Microsoft introduced set of new dynamic management view and function that helps database administrators (DBA) and developers to identify potential index candidates based on query history.

Checkout the part-3 of my three part article series on index-related dynamic management views and function here, in which I discussed these index-related dynamic management views (DMVs), which are useful to identify potential indexes for your queries based representative server activity.

This article is published on SSWUG.org.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.