IT:AD:SQL Server:HowTo:Performance

I'm going to assume you're not a DBA – in which case you need tools. In which case I'm going to suggest the following:

• Who Is Active script:
  • http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx
  • http://sqlblog.com/files/default.aspx
  • http://www.codeproject.com/Articles/799053/Web-based-real-time-SQL-Server-Performance-Dashboa
• Things I would suggest using the above for:
  • Finding the slowest executing stored procs (yes, it does a great job at)

* http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx * http://www.codeproject.com/Articles/799053/Web-based-real-time-SQL-Server-Performance-Dashboa