SQL Agent Insights:Documentation: Difference between revisions

From SQL Agent Insights Wiki
No edit summary
 
(22 intermediate revisions by the same user not shown)
Line 1: Line 1:
'''SQL Agent Insight''' is a monitoring and alerting utility for Microsoft’s SQL Server® Agent service.
'''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 Insight.
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 Insight:Documentation:Download and Installation|Download and Installation]]
* [[SQL Agent Insights:Documentation:Download and Installation|Download and Installation]]
* [[SQL Agent Insight:Documentation:Main_User_Interface|A Tour of the Main User Interface (UI)]]
* [[SQL Agent Insights:Documentation:Main_User_Interface|A Tour of the Main User Interface (UI)]]
* [[SQL Agent Insight:Documentation:Connecting_to_an_Instance_of_SQL_Server®|Connecting to a SQL Server® Instance]]
* [[SQL Agent Insights:Documentation:Connecting_to_an_Instance|Connecting to a SQL Server® Instance]]
* [[SQL Agent Insight:Documentation:Preferences|Preferences]]
* [[SQL Agent Insights:Documentation:Preferences|Preferences]]


= Working with an Insight =
= Working with an Insight =


* [[SQL Agent Insight:Documentation:Insight Overview|Overview]]
* [[SQL Agent Insights:Documentation:Insight Overview|Overview]]
* [[SQL Agent Insight:Documentation:Insight Metrics|Metrics]]
* [[SQL Agent Insights:Documentation:Insight Metrics|Metrics]]
* [[SQL Agent Insight:Documentation:Insight Configuration|Configuration]]
* [[SQL Agent Insights:Documentation:Insight Configuration|Configuration]]
* [[SQL Agent Insight:Documentation:Insight Maintenance Mode|Maintenance Mode]]
* [[SQL Agent Insights:Documentation:Insight Maintenance Mode|Maintenance Mode]]
* [[SQL Agent Insight:Documentation:Insight Log|Log]]
* [[SQL Agent Insights:Documentation:Insight Log|Log]]
* [[SQL Agent Insight:Documentation:Insight Polling Freq Recent Timeframe|Polling Frequency & Recent Timeframe]]
* [[SQL Agent Insights:Documentation:Insight Polling Frequency Recent Timeframe|Polling Frequency & Recent Timeframe]]
* [[SQL Agent Insight:Documentation:Insight Thresholds|Setting Metric Thresholds]]
* [[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 History
* [[SQL Agent Insights:Documentation:Job Monitor Suspend Job|Suspending a Job]]
* Suspending a Job
* Create a new job - ''Coming Soon''
* Creating a new job
* Editing an existing job - ''Coming Soon''
* Editing an existing job
* Job Properties - ''Coming Soon''


= Job Conflicts =
= Job Conflict Outlook =
* Overview
* [[SQL Agent Insights:Documentation:Job Conflict Outlook Overview|Overview]]
 
= Job History =
* [[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]]
 
= Frequently Asked Questions =
 
# 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 =
= Archived Videos =
Line 50: Line 49:


[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}}
{{MicrosoftFooter}}
[[Category:Documentation]]

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

Working with an Insight

Job Monitor

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