SQL Server Dynamic Management Views & Functions
Submitted by Andrey Gamarnik on Wed, 06/13/2012 - 17:28
Recently we were asked to develop a tools set for monitoring SQL queries performance in one of the ASP.NET plus MS SQL project we're working on. In particular, we were required to make some pages with reports containing information about the heaviest stored procedures and any other relevant information.
Customer suggested using Dynamic Management Views and Functions himself. Honestly, I've heard about DMV's first time myself, therefore asked for help from our SQL gurus.

