SQL MONITOR CASUES SERVER CPU100%
nyealovey
Posts: 1
can anybody help me？
after i add a new server on sql monitor，the server become slowly。
i found one of the top queries as follow
Use [tempdb];
SELECT database_name = DB_NAME(DB_ID([database_name])) ,
type = [type] ,
backup_start_date = MAX([backup_start_date]) ,
backup_finish_date = MAX([backup_finish_date])
FROM msdb..backupset
WHERE DB_ID([database_name]) IS NOT NULL
GROUP BY DB_NAME(DB_ID([database_name])) ,[type]
after i add a new server on sql monitor，the server become slowly。
i found one of the top queries as follow
Use [tempdb];
SELECT database_name = DB_NAME(DB_ID([database_name])) ,
type = [type] ,
backup_start_date = MAX([backup_start_date]) ,
backup_finish_date = MAX([backup_finish_date])
FROM msdb..backupset
WHERE DB_ID([database_name]) IS NOT NULL
GROUP BY DB_NAME(DB_ID([database_name])) ,[type]
Tagged:
Comments
Just to clarify, do you mean the server hosting SQL Monitor spikes to 100% CPU or the machine you add to be monitored spikes to 100% CPU?
That query does look like one of ours - if you run it manually on the server you have recently added to SQL Monitor how many results does it return? What OS is the machine you are adding to SQL Monitor and what OS is the machine you have SQL Monitor installed upon?
Kind regards,
Alex
Have you visited our Help Center?