‫مونیتور کردن میزان مصرف CPU در اس کیوال سرور

DECLARE @CPU_BUSY int, @IDLE int
SELECT @CPU_BUSY = @@CPU_BUSY, @IDLE = @@IDLE WAITFOR DELAY '000:00:01'
SELECT (@@CPU_BUSY - @CPU_BUSY)/((@@IDLE - @IDLE + @@CPU_BUSY - @CPU_BUSY) *1.00) *100 AS 'CPU Utilization by sqlsrvr.exe'

USE [master]
GO
sp_configure 'show advanced options',1
GO
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'Database Mail XPs',1
GO
--RECONFIGURE
GO
-- Create a New Mail Profile for Notifications
EXECUTE msdb.dbo.sysmail_add_profile_sp
     @profile_name = 'DBA_Notifications',
     @description = 'Profile for sending Automated DBA Notifications'
GO
-- Set the New Profile as the Default
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
  @profile_name = 'DBA_Notifications',
  @principal_name = 'public',
  @is_default = 1 ;
GO
-- Create an Account for the Notifications
EXECUTE msdb.dbo.sysmail_add_account_sp
  @account_name = 'SQLMonitor',
  @description = 'Account for Automated DBA Notifications',
  @email_address = 'nasiri@site.net',  -- Change This
  @display_name = 'SQL Monitor',
  @mailserver_name = 'mail.site.net'  -- Change This
GO
-- Add the Account to the Profile
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
  @profile_name = 'DBA_Notifications',
  @account_name = 'SQLMonitor',
  @sequence_number = 1

GO

--test
EXECUTE msdb.dbo.sp_send_dbmail
 @recipients = 'nasiri@site.net',  -- Change This
 @Subject = 'Test Message generated from SQL Server DatabaseMail',
 @Body = 'This is a test message from SQL Server DatabaseMail'

DECLARE @CPUUsage INT
DECLARE @CPU_BUSY INT,
      @IDLE INT

SELECT @CPU_BUSY = @@CPU_BUSY,
     @IDLE = @@IDLE

WAITFOR DELAY '000:00:01'
SELECT @CPUUsage = (@@CPU_BUSY - @CPU_BUSY) / ((@@IDLE - @IDLE + @@CPU_BUSY - @CPU_BUSY) * 1.00)
     * 100 -- CPU Utilization by sqlsrvr.exe
 

IF @CPUUsage > 50
BEGIN
  DECLARE @msg NVARCHAR(1000)
  SET @msg = 'Please check SQL server, CPU usage is ' + CAST(@CPUUsage AS NVARCHAR(50))
      + '%.'

  EXECUTE msdb.dbo.sp_send_dbmail
  @recipients = 'nasiri@site.net', -- Change This
  @copy_recipients = 'nasiri@site.net', -- Change This
  @Subject = 'CPU overload',
  @Body = @msg
  ,@importance = 'High'
END