Getting performance statistics for cached stored procedures
Getting performance statistics for cached stored procedures It is always extremely important to maintain your SQL server to the utmost efficiency. DBAs review the database structure and whether certain pieces such as stored procedures, triggers, etc. can be tuned even further. One of the areas that will be discussed are the stored procedure which can be used during any time as well as day. Dynamic Management Views and Function (DMVs and DMFs) to identify resources used by stored procedures DMVs and DMFs were introduced in SQL Server 2005 and are able to obtain figures only for those stored procedures that have execution plans in the procedure cache. The SQL Server engine starts gathering information about the performance of a stored procedure the first time that the plan is placed in the…