SQLServerPedia

Your community knowledge base Powered by Quest Software
  • SQL Server Wiki
    • Architecture & Configuration
    • Business Intelligence (SSAS, SSIS)
    • Database Administration
    • Monitoring SQL Servers
    • Performance Tuning
    • SQL Server Links
    • SQL Server Tutorials
    • Transact SQL Coding Techniques
    • Transact SQL Coding and Naming Standards
    • Transact SQL Code Library
    • How to Write and Edit Articles
  • Buzz New!
  • Blog
  • Podcasts
  • Editors
  • Contribute
  • Log in

Index Related DMV Queries

  • Page
  • Discussion
  • View source
  • History

From SQLServerPedia

Jump to: navigation, search

See Also: Main_Page - Transact SQL Code Library

The following Index Performance Tuning queries are included in the T-SQL Code Library:

  • Find Indexes Not In Use
  • Find Missing Indexes
  • Find Tables Without Primary Keys - also known as heaps.
  • Find Queries in the Plan Cache That Are Missing an Index

Have Problems with These Queries?

You can add questions by clicking on the "Discussion" tab at the top of this article. The authors will see your comments and respond.

Retrieved from "http://sqlserverpedia.com/wiki/Index_Related_DMV_Queries"

Featured Editor

 
Brent Ozar
Editor In Chief

Editor-in-chief basically means that Brent keeps the pipes unclogged and makes sure the rest of the editors have the tools they need in…

Read More »

Subscribe

  • RSS

Top Searches

  • SQL Server Date
  • SQL Server Download
  • SQL Server Functions
  • SQL Server Management
  • SQL Server Service
  • SQL Server Tutorial
  • Database Hosting
  • Database Transaction

Powered by MediaWiki  |  © 2010 Quest Software, All Rights Reserved.  |  Privacy Policy  |  Terms of Use  |  Contact Us