Current Position:Home > Seeking help on SQL Server Monitoring

Seeking help on SQL Server Monitoring

Update:11-30Source: network consolidation
Advertisement
Hi Experts,
This question is related to monitoring of sql server.
1. I want to send an email alert with all open transactions on SQL Server in HTML report whenever there is sustained 50-60% CPU usage for more than 3 minutes. How to achieve this using TSQL or stored procedure so that I can schedule as a job and keep polling
on regular basis.
2. Similar as above, I wanted to get notified whenever there is sustained 70-80% memory usage on the server for more than 3 minutes.
   The reason for this, even though I have set the max server memory setting for sql server, there could some component eating up memory which can cause external memory pressure.
   In such situations, DBA team should get an email alert notification even before users calls in and open a ticket.
I have anyone can provide sample code that will be great help. Based on that I can extend the functionality of monitoring like collecting trace etc...
Thanks in advance.

The Best Answer

Advertisement
I have been using SQL Monitor from www.red-gate.com  for many years to get such alerts.
Best Regards,Uri Dimant SQL Server MVP,
http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting:
Large scale of database and data cleansing
Remote DBA Services:
Improves MS SQL Database Performance
SQL Server Integration Services:
Business Intelligence
  • Seeking help on SQL Server Monitoring Update:11-30

    Hi Experts, This question is related to monitoring of sql server. 1. I want to send an email alert with all open transactions on SQL Server in HTML report whenever there is sustained 50-60% CPU usage for more than 3 minutes. How to achieve this using

  • Standalone SQL Server monitoring with Solution Manager Update:10-11

    Hi, We have a Solman 3.1 instance monitoring all of our SAP and non-SAP Infrastructure.  We have several SQL Server systems we would like to monitor. Currently we have installed saposcol and sapccms agents on the servers and are getting the OS alerts

  • SQL Server monitoring error event log 4001 Update:10-11

    hello Experts , We have SCOM 2012 R2 environment ,I have installed SQL SERVER MPs 6.5.0.1 and installed SCOM agent on some of SQL Server. Some of the SQL Server are monitoring working properly not all SQL Server but getting error  for some of SQL Ser

  • Cannot find a report for SQL Server monitoring Update:11-30

    We installed a SCOM 2012 environment recently and imported the SQL Server Management packs successfully. SQL Servers are being monitored.  However, in the reporting section, i cannot find a group for SQL Server Reporting. All other show up ( Active D

  • SQL Server monitoring with 12c Grid control Update:11-30

    Dear Gurus I want to add my sql server databases in 12c Grid control. for this i have deployed the sql server plugin in 12c grid control but i am unable to add the sql server databases/ servers in 12c grid control. Could you please help me in deployi

  • SQL Server 2012 AlwaysON Monitoring using SCOM Update:10-11

    Team, We have SCOM deployed and is serving as a monitoring solution for our SQL Estate. However I want some pointers to monitor the health of DBs within Avaialibility Group like DB Sync, log queue etc. Please direct me with the AlwaysOn health parame

  • Some of the SQL Server 2012 are not getting monitored in SCOM 2012 SP1.( basics monitoring is happening, expect SQL role) Update:10-11

    Found that all the SQL servers are getting monitored, expect few servers which are having SQL server 2012 role. proxy is enabled for these servers, when I checked discovered inventory for SQL 2012 database unable to find these servers in that list. a

  • SQL Server Agent Job Duration monitor alerts incorrectly Update:10-11

    As per SQL Server MP guide, changes in Dec 2007 update : Fixed a script that was resulting in invalid alerts being generated from the agent job's Job Duration monitor. In my SCOM 2012 environment on few SQL servers I'm getting an alert from Job Dura

  • Query used by SQL Server Management Pack for monitoring database backups Update:11-30

    I use SCOM 2012 R2 and the SQL Server Management Pack to monitor SQL Server database backups. I believe I am getting false positives. SCOM reports database are not backuped, while in fact they are. So I need to troubleshoot this. I suspect SCOM is qu

  • SQL Server Plugin - Remote Connections to Monitor Targets Update:11-30

    Hi, We have OEM 10.2.0.4.0 on MS Windows Server 2003 Service Pack 1. Trying to configure SQL Server Plugin Release 6 (microsoft_sqlserver_database version 3.2.3.1.0). No issues monitoring SQL Server 2005 SP2 installed on same box the Grid. Next test