Troubleshooting SQL Server performance issues is a huge subject, but I often start by analysing the wait (sys.dm_os_wait_stats) and virtual file statistics (sys.dm_io_virtual_file_stats) in parallel. If the performance issues are not blocking, then it is always a good idea to clear the wait statistics and then let server run for a set period (Hour, Day, Week) giving you a good set of data to work with. Wait stats are cleared by running: DBCC SQLPERF(‘sys.dm_os_wait_stats’, CLEAR) However …