Tag Archives: Databasewise CPU

SQL – Find CPU,Memory,Connections, VLF’s,I/O of all the Databases

Find CPU, Memory, No Of Connections/databases and VLF’s and I/O details in one single script.  You just need to run the below T-SQL in SSMS Download the code here Metrics ***************************************************************************** USE MASTER GO DECLARE @DML1 nvarchar(MAX), @DML2 nvarchar(MAX), @DML3 nvarchar(MAX), … Continue reading

Posted in SQL | Tagged , , , , | 4 Comments