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.