What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL Server of course!
This week is all about the video, so if you can’t view it above, head on over to my YouTube channel to watch it there.
After watching, be sure to check out Pinal’s free performance diagnostic scripts over at SQLAuthority.com:
- Replacement for DBCC INPUTBUFFER: sys.dm_exec_input_buffer
- Finding the longest running queries.
- Introduction to wait statistics
Thanks for reading. You might also enjoy following me on Twitter.
Adam Machanic’s sp_whoisactive is the best tool to use for identifying performance issues. There’s even a parameter available to append the output to a history table. So set up a SQL Agent job to write the output to such a table and then a simple case of mining the data to identify the connection using the most CPU, the longest duration, the most transaction log writes, the top header blocker etc. It even has an option to capture the query plans for the active connections. An absolute must have tool if you are serious about performance management.
Agreed, it’s a great script!
Author describe this blog elaborately. It is a nice and descriptive comment as my point of view. Please publish this type of blog
and update follower like me.