SQL Agent Insights:Documentation: Difference between revisions
No edit summary |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
'''SQL Agent | '''SQL Agent Insights''' 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. | 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 | Here you will find documentation pages to aid in the use of SQL Agent Insights. | ||
For anything not yet documented, please reach out to me via the [https://brentec.ca/contact-us Contact] page for any assistance required. | For anything not yet documented, please reach out to me via the [https://brentec.ca/contact-us Contact] page for any assistance required. | ||
| Line 9: | Line 9: | ||
= Getting Started = | = Getting Started = | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Download and Installation|Download and Installation]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Main_User_Interface|A Tour of the Main User Interface (UI)]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Connecting_to_an_Instance|Connecting to a SQL Server® Instance]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Preferences|Preferences]] | ||
= Working with an Insight = | = Working with an Insight = | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Insight Overview|Overview]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Insight Metrics|Metrics]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Insight Configuration|Configuration]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Insight Maintenance Mode|Maintenance Mode]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Insight Log|Log]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Insight Polling Frequency Recent Timeframe|Polling Frequency & Recent Timeframe]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Insight Thresholds|Setting Metric Thresholds]] | ||
= Job Monitor = | = Job Monitor = | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Job Monitor Overview|Overview]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Job Monitor Context Menu|Context Menu Options]] | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Job Monitor Suspend Job|Suspending a Job]] | ||
* | * Create a new job - ''Coming Soon'' | ||
* Editing an existing job - ''Coming Soon'' | * Editing an existing job - ''Coming Soon'' | ||
* Job Properties - ''Coming Soon'' | * Job Properties - ''Coming Soon'' | ||
= Job Conflict Outlook = | = Job Conflict Outlook = | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Job Conflict Outlook Overview|Overview]] | ||
= Job History = | = Job History = | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Job History Overview|Overview]] | ||
* Purge Job History - ''Coming Soon'' | |||
= Log Viewer = | = Log Viewer = | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Log Viewer Overview|Overview]] | ||
= Archived Videos = | = Archived Videos = | ||
Latest revision as of 03:26, 16 October 2023
SQL Agent Insights 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 Insights. 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 and will evolve over time. 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
- Suspending a Job
- Create a new job - Coming Soon
- Editing an existing job - Coming Soon
- Job Properties - Coming Soon
Job Conflict Outlook
Job History
- Overview
- Purge Job History - Coming Soon
Log Viewer
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