Bert & Pinal Troubleshoot a Slow Performing SQL Server
Everyone has their own techniques for troubleshooting a slow performing SQL Server. In this video I chat with performance tuning expert Pinal Dave about his SQL Server tuning process.
Our previous collaboration: • Pinal Dave's Real World Performance S...
Resources:
-- Replacement for DBCC INPUTBUFFER, sys.dm_exec_input_buffer: https://blog.sqlauthority.com/2016/12...
-- Finding the longest running queries: https://blog.sqlauthority.com/2016/11...
-- Introduction to wait stats: https://blog.sqlauthority.com/2011/02...
Pinal's blog: https://blog.sqlauthority.com/
Pinal on Twitter: / pinaldave
Bert's blog: https://bertwagner.com/
Bert on Twitter: / bertwagner
