Despite all the DMVs, the sysprocesses table still offers a significant amount of information for identifying top CPU or I/O consumers. A great advantage is that it is SQL Server version neutral (so far anyway) and convenient to get to. So inevitably,
Read More...