SQL Agent Insights:Documentation: Difference between revisions
No edit summary |
|||
| (43 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. | ||
This wiki and subsequent pages are a work-in-progress. Thank you. | This wiki and subsequent pages are a work-in-progress and will evolve over time. Thank you. | ||
= Getting Started = | = Getting Started = | ||
* [[SQL Agent | * [[SQL Agent Insights:Documentation:Download and Installation|Download and Installation]] | ||
* A Tour of the Main User Interface (UI) | * [[SQL Agent Insights:Documentation:Main_User_Interface|A Tour of the Main User Interface (UI)]] | ||
* Connecting to SQL Server® Instance | * [[SQL Agent Insights:Documentation:Connecting_to_an_Instance|Connecting to a SQL Server® Instance]] | ||
* Preferences | * [[SQL Agent Insights:Documentation:Preferences|Preferences]] | ||
= Working with an Insight = | = Working with an Insight = | ||
* Overview | |||
* Metrics | * [[SQL Agent Insights:Documentation:Insight Overview|Overview]] | ||
* Configuration | * [[SQL Agent Insights:Documentation:Insight Metrics|Metrics]] | ||
* Maintenance Mode | * [[SQL Agent Insights:Documentation:Insight Configuration|Configuration]] | ||
* Log | * [[SQL Agent Insights:Documentation:Insight Maintenance Mode|Maintenance Mode]] | ||
* Polling Frequency & Recent Timeframe | * [[SQL Agent Insights:Documentation:Insight Log|Log]] | ||
* Setting Metric Thresholds | * [[SQL Agent Insights:Documentation:Insight Polling Frequency Recent Timeframe|Polling Frequency & Recent Timeframe]] | ||
* [[SQL Agent Insights:Documentation:Insight Thresholds|Setting Metric Thresholds]] | |||
= Job Monitor = | = Job Monitor = | ||
* Overview | * [[SQL Agent Insights:Documentation:Job Monitor Overview|Overview]] | ||
* Context Menu Options | * [[SQL Agent Insights:Documentation:Job Monitor Context Menu|Context Menu Options]] | ||
* Job | * [[SQL Agent Insights:Documentation:Job Monitor Suspend Job|Suspending a Job]] | ||
* | * Create a new job - ''Coming Soon'' | ||
* Editing an existing job - ''Coming Soon'' | |||
* Job Properties - ''Coming Soon'' | |||
= Job Conflict Outlook = | |||
* [[SQL Agent Insights:Documentation:Job Conflict Outlook Overview|Overview]] | |||
= Job | = Job History = | ||
* Overview | * [[SQL Agent Insights:Documentation:Job History Overview|Overview]] | ||
* Purge Job History - ''Coming Soon'' | |||
= Log Viewer = | = Log Viewer = | ||
* Overview | * [[SQL Agent Insights:Documentation:Log Viewer Overview|Overview]] | ||
= Archived Videos = | = 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. | |||
[https://www.youtube.com/watch?v=QzJ3QtIZzDA SQL Agent Insight 101 Series - A Tour of the Main User Interface (UI)] | [https://www.youtube.com/watch?v=QzJ3QtIZzDA SQL Agent Insight 101 Series - A Tour of the Main User Interface (UI)] | ||
| Line 46: | Line 50: | ||
[https://youtube.com/watch?v=8-yqFa5KJ-A SQL Agent Insight 101 Series - Connecting to a SQL Server Instance] | [https://youtube.com/watch?v=8-yqFa5KJ-A SQL Agent Insight 101 Series - Connecting to a SQL Server Instance] | ||
{{MicrosoftFooter}} | |||
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