digg

Join DiggAbout

Discover the best of the web!
Learn more about Digg by taking the tour.

SQL Server: Uncover Hidden Data to Optimize Application Perf

msdn2.microsoft.com — A rather useful bunch of queries that make use of the new performance data that SQL2005 automatically collects behind the scenes in Dynamic Management Views. They identify: Causes of Server Waits & Blocking, Missing/Unused/Costly/Fragmented Indexes, Lowest Plan Reuse and Costliest Queries.

Bury
show profanity settings
expand all
  •  

    Login or register to add a comment

    Create a new account or login to join in the conversation on Digg. You'll also be able to Digg stories to help promote things you like.


© Digg Inc. 2008 — Content posted by Digg users is dedicated to the public domain.
DIGG, DIGG IT, DUGG, DIGG THIS, Digg graphics, logos, designs, page headers, button icons, scripts, and other service names are the trademarks of Digg Inc.