How to Take Actions Based on Spotlight on SQL Server Enterprise Alarms
Download
1 / 6

How to Take Actions Based on Spotlight on SQL Server Enterpr - PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on

Download Spotlight on SQL Server (http://software.dell.com/sqlserveralarms) to set up custom alerts for crisis level or unusual activity. Managing SQL Server requires performing many tasks, including maintenance and monitoring. Maintenance can be scheduled and performed via jobs, but monitoring takes some human touch to: ensure real issues are addressed and ignore non-critical items until all crises items are solved. Monitoring SQL Server can be taxing, unless you set up a system for doing so. In order to have a proper monitoring system you need to identify what needs to be monitored, how you are alerted and what items are critical. Spotlight on SQL Server allows you to set up custom alerts for crisis level or unusual activity. An example might be when a CPU runs at 90% for more than five minutes during business hours. You can dictate what you what to be alerted about, whether you are alerted or what alternative actions to take, and when the item is deemed critical.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'How to Take Actions Based on Spotlight on SQL Server Enterpr' - SQLDBApros


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Why should you care
Why should you care? Enterprise Alarms

  • Managing SQL Server requires performing many tasks, including maintenance and monitoring.

    • Maintenance can be scheduled and performed via jobs, but monitoring takes some human touch to:

      • Ensure real issues are addressed

      • Ignore non-critical items until all crises items are solved

  • Monitoring SQL Server can be taxing, unless you set up a system for doing so.

  • In order to have a proper monitoring system you need to identify what needs to be monitored, how you are alerted and what items are critical. 


Monitoring sql server
Monitoring SQL Server Enterprise Alarms

  • In order to have a proper monitoring system you need to identify:

    • what needs to be monitored

    • how you are alerted

    • what items are critical

  • Spotlight on SQL Server allows you to set up custom alerts for crisis level or unusual activity.

    • An example might be when a CPU runs at 90% for more than five minutes during business hours.

  • You can dictate what you what to be alerted about, whether you are alerted or what alternative actions to take, and when the item is deemed critical.


The following video
The following video Enterprise Alarms

  • The following video teaches you how to take actions based on pre-defined alarms in Spotlight on SQL Server, version 10.0.

  • How to create alarm actions

    • Name the action

    • Define conditions

    • Select actions to perform

  • Alarm actions can be

    • Day based

    • Time based

    • Duration based

    • Severity based


Click to watch the video now
Click to watch the video now Enterprise Alarms


Learn more download spotlight on sql server view tutorial on youtube

Learn More Enterprise AlarmsDownload Spotlight on SQL ServerView Tutorial on YouTube


ad