Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Deployment Guide

Welcome to Spotlight on SQL Server The size and shape of your deployment Install / Upgrade Spotlight data collection and storage View data and configure Spotlight Monitored connections in the deployment Deployment over the Windows network Monitored SQL Servers Monitored Windows Servers and hosts of database connections

Spotlight Integration Guide: How to Integrate with PagerDuty

Spotlight on SQL Server Integration Guide

Friday, January 13, 2017

Topics:


Welcome

Spotlight on SQL Server monitors the activity of SQL Server instances in your enterprise. When a Spotlight alarm is raised an incident report can be sent to a single PagerDuty service. Spotlight updates the PagerDuty incident when the alarm severity level changes in Spotlight or the alarm is snoozed or acknowledged in Spotlight. When the alarm is acknowledged or resolved in Spotlight the incident is resolved in PagerDuty. The reverse is not true, so if the incident is acknowledged or resolved in PagerDuty then Spotlight will not receive that information. Use this guide to integrate Spotlight with PagerDuty.

Integration requires Spotlight on SQL Server 11.5 or above.


In PagerDuty:

  1. Log in to your PagerDuty account. Configure an API access key to create an authentication for Spotlight to use to send alarm notifications to your PagerDuty account. Select Configuration | API Access.

  2. On the PagerDuty API Access Keys page, provide a Description for the API Access Key and click Create Key.

  3. On the PagerDuty API Access Keys page, take note of the API Key for later use (in Spotlight).

  1. Create a PagerDuty service for Spotlight to send alarm notifications to. Select Configuration | Services.

  2. From the Services page, click Add New Service.

  3. Create a name for the service. Assign an escalation policy. Select Use our API directly. Click Add Service.

  4. On the PagerDuty service page (for Spotlight on SQL Server Enterprise), take note of the Service API Key for later use (in Spotlight).

 


In Spotlight on SQL Server:

Configure PagerDuty

In the Spotlight Client:

  1. Click Configure | Diagnostic Server.

  2. Select Configure PagerDuty.
  3. Specify your PagerDuty account details: API Access Key and Service API key.
  4. Click Trigger Test Incident to verify Spotlight can successfully send an alarm notification to PagerDuty.

 

Configure Alarm Actions

Define the conditions requiring Spotlight to send an incident report to PagerDuty.

In the Spotlight Client:

  1. Click Configure | Alarm Actions.

  2. Click New to create a new rule or select a rule and click Modify.

  3. In the alarm action editor, give the rule a meaningful name. Apply conditions such as the name of the alarm, the severity of the alarm, the alarm type, the connection type, the date of the week and the time of day. In the actions to perform, select Send PagerDuty Incident. A PagerDuty incident is sent to the PagerDuty dashboard when all conditions for this rule are met.

  4. Return to the Alarm Action Editor. Create as many rules as are appropriate to your organization. All the actions in the rule are executed when all the conditions in the rule are met. Rules are executed in the order they are listed in the Alarm Action Editor. Move rules up and down to re-organize them.

In PagerDuty:

Congratulations! You have integrated Spotlight on SQL Server with your PagerDuty account. PagerDuty incident reports contain valuable information to facilitate quick resolutions of your alarms. The PagerDuty incident is updated automatically when the alarm severity changes in Spotlight or the alarm is snoozed or acknowledged in Spotlight. When the alarm is acknowledged or resolved in Spotlight the incident is resolved in PagerDuty. Note that the reverse is not true: acknowledge and resolve actions on the PagerDuty web site do not update the Spotlight application.


About Us

We are more than just a name

We are on a quest to make your information technology work harder for you. That is why we build community-driven software solutions that help you spend less time on IT administration and more time on business innovation. We help you modernize your data center, get you to the cloud quicker and provide the expertise, security and accessibility you need to grow your data-driven business. Combined with Quest’s invitation to the global community to be a part of its innovation, and our firm commitment to ensuring customer satisfaction, we continue to deliver solutions that have a real impact on our customers today and leave a legacy we are proud of. We are challenging the status quo by transforming into a new software company. And as your partner, we work tirelessly to make sure your information technology is designed for you and by you. This is our mission, and we are in this together. Welcome to a new Quest. You are invited to Join the Innovation.

Our brand, our vision. Together.

Our logo reflects our story: innovation, community and support. An important part of this story begins with the letter Q. It is a perfect circle, representing our commitment to technological precision and strength. The space in the Q itself symbolizes our need to add the missing piece — you — to the community, to the new Quest.

Contacting Quest

For sales or other inquiries, visit www.quest.com/company/contact-us.aspx or call +1 949 754-8000.

Technical support resources

Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:

  • Submit and manage a Service Request
  • View Knowledge Base articles
  • Sign up for product notifications
  • Download software and technical documentation
  • View how-to-videos
  • Engage in community discussions
  • Chat with support engineers online
  • View services to assist you with your product


Copyright 2016 Quest Software Inc. ALL RIGHTS RESERVED.

This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software Inc.

The information in this document is provided in connection with Quest Software products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest Software products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST SOFTWARE ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST SOFTWARE BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest Software makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest Software does not make any commitment to update the information contained in this document.

If you have any questions regarding your potential use of this material, contact:

Quest Software Inc.

Attn: LEGAL Dept

4 Polaris Way

Aliso Viejo, CA 92656

Refer to our Web site (www.quest.com) for regional and international office information.

Patents

Quest Software is proud of our advanced technology. Patents and pending patents may apply to this product. For the most current information about applicable patents for this product, please visit our website at www.quest.com/legal.

Trademarks

Quest, Toad, Toad World, Spotlight and the Quest logo are trademarks and registered trademarks of Quest Software Inc. For a complete list of Quest marks, visit www.quest.com/legal. All other trademarks and registered trademarks are property of their respective owners.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating