bird's eye view over SQL Server Performance
There is good statement that you can see what is going on Database DBCC SQLPERF('waitstats') it collects wait status group by Wait Type.
Fellowship of Technology... http://www.bbtechnologies.co.uk https://www.linkedin.com/in/muhammetatalay https://bbtechnologies.co.uk https://github.com/TheMaty https://muhammetatalay.blogspot.com