IT:AD:SQL Server:HowTo:Performance
- See also:
Summary
There's IT:AD:SQL Server:HowTo:SQL:Performance (Indexes, clause precision, etc.) and SQL Server performance.
This is about the SQL Server side of things.
Notes
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:
- Things I would suggest using the above for:
- Finding the slowest executing stored procs (yes, it does a great job at)