InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 03:02:45 GMT20http://www.sqlservercentral.com/Forums/Topic953163-149-1.aspx[url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]Fri, 16 Jul 2010 02:33:56 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic953163-149-1.aspxSee this article it might give you some directionshttp://www.codeproject.com/KB/database/Dynamic_Management_Views.aspxFri, 16 Jul 2010 00:33:21 GMTShanalisehttp://www.sqlservercentral.com/Forums/Topic953163-149-1.aspxHi,I have a requirement like i need to track the stored procedures which are taking more than 30-45 secs and inform to the concerned team to optimize. Please let me know whether we have any option to get the worst performing list from dmv.Thanks in Advance!Thu, 15 Jul 2010 08:19:47 GMThaichells