SQL Agent Insights:Documentation

SQL Agent Insight is a monitoring and alerting utility for Microsoft’s SQL Server® Agent service.

With over 60 unique metrics, your team will be notified of any changes to your SQL Server® Agent infrastructure either visually and/or via email.

Here you will find documentation pages to aid in the use of SQL Agent Insight. For anything not yet documented, please reach out to me via the Contact page for any assistance required.

This wiki and subsequent pages are a work-in-progress. Thank you.

Getting Started

• Download and Installation
• A Tour of the Main User Interface (UI)
• Connecting to a SQL Server® Instance
• Preferences

Working with an Insight

• Overview
• Metrics
• Configuration
• Maintenance Mode
• Log
• Polling Frequency & Recent Timeframe
• Setting Metric Thresholds

Job Monitor

• Overview
• Context Menu Options
• Job History
• Suspending a Job
• Creating a new job
• Editing an existing job

Job Conflicts

• Overview

Log Viewer

• Overview

Frequently Asked Questions

1. Q: Why do I not have the ability to save/remember the credentials for each instance for quicker connections in the future?
   • A:

Archived Videos

Below are some older videos produced back for version 0.22 of SQL Agent Insight. While they turned out pretty good, the time to create them, (i.e., learning the software), took an extreme amount of time and resources to perfect the final outcome. They are included here for completeness. Enjoy.

SQL Agent Insight 101 Series - A Tour of the Main User Interface (UI)

SQL Agent Insight 101 Series - Connecting to a SQL Server Instance

---

Microsoft®, Windows® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Some icons courtesy of Icons8