• What is the current issue with the stored procedures that you are trying to resolve? Duration? Reads? Writes? Is there a specific wait type that is an issue that you are trying to resolve i.e. CXPACKET. We will need more information on what you are trying to resolve before we can simply give you all of the metrics to look into. I would suggest that you get Grant Fritchey's book "SQL Server 2012 Query Performance Tuning". In there he walks you through how to identity problem queries (using different metrics) and steps to fix those issues.



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]