Activity overview
Latest activity by Corobori
Hi Grant,
I ran on my SQL Server the following statement WITH CPU_Per_Db
AS
(SELECT
dmpa.DatabaseID
, DB_Name(dmpa.DatabaseID) AS [Database]
, SUM(dmqs.total_worker_time) AS CPUTimeAsMS
FROM sys.dm_exec_query_stats dmqs
CROSS APPLY
(SELECT
CONVERT(INT, value) AS [DatabaseID]
FROM sys.dm_exec_plan_attributes(dmqs.plan_handle)
WHERE attribute = N'dbid') dmpa
GROUP BY dmpa.DatabaseID)
SELECT
[Database]
,[CPUTimeAsMS]
,CAST([CPUTimeAsMS] * 1.0 / SUM([CPUTimeAsMS]) OVER() * 100.0 AS DECIMAL(5, 2)) AS [CPUTimeAs%]
FROM CPU_Per_Db
ORDER BY [CPUTimeAs%] DESC;
And it gave me the results shown below. I am not expert but it looked as some sort of ranking. So my actual issue is nailing down what's up with the database appearing at #1 here. Or is the information shown here irrelevant ? [image] / comments
Hi Grant,
I ran on my SQL Server the following statementWITH CPU_Per_Db
AS
(SELECT
dmpa.DatabaseID
, DB_Name(dmpa.DatabaseID) AS [Database]
, SUM(dmqs.total_worker_time) AS ...
How to monitor a server and a particular database
Hi, I have just installed SQL Monitor 7 on my server and I am trying to find my way around. Searching the online documentation didn't return the answers I am looking for. Basically 2 questions: the...