|
|
| (19 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| Interested in knowing what I'm working on or thinking of implementing for the next version of SQL Agent Insight? Read more below. | | Interested in knowing what I'm working on or thinking of implementing for the next version of SQL Agent Insights? Read more below. |
|
| |
|
| == In Development / Researching == | | == In Development / Researching == |
| === New === | | <br/> |
| * Azure SQL managed instance support
| | <span style="color:red"><b>UPDATE:</b></span> Please see this [https://brentec.ca/blog/2024/09/the-future-of-sql-agent-insights/ blog post] regarding the future of SQL Agent Insights. Thank you. |
| * '''UI''' : implement column chooser for all data grids with a significant number of columns with ability to save layout.
| |
| * '''Insight''' : Show / log jobs that have a successful outcome but have failed steps within them.
| |
|
| |
|
| === Enhancement / Improvement ===
| | * Azure® SQL managed instance support. |
| * Convert entire SQL Agent Insight project to .NET 6 | | * Convert entire SQL Agent Insights project to .NET 6 or greater. |
| * '''Preferences''' : omit asking to create suspend/resume jobs when opening Job Monitor. | | * Different licensing models. |
| * '''UI''' : update legacy taskbar notification icons. | | * Copy agent jobs between monitored instances. |
| | | * Job conflicts per individual job. |
| == Future Considerations ==
| | * Dynamic metric thresholds. |
| === <span style="color:#1FB141">New</span> ===
| | * Proxy creation, deletion and modification. |
| {| class="wikitable sortable mw-collapsible mw-expanded"
| | * Ability to sync settings between Insights. |
| !
| | * Calendar control to supplement Job Outlook. |
| |-
| | * Ability to overlay multiple instances within Job Outlook. |
| | '''Job Monitor''' : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
| | <br/> |
| |-
| | {{BrentecFooter}} |
| | '''Preferences''' : email authentication via OAuth2.
| | {{MicrosoftFooter}} |
| |-
| |
| | '''Job History''' : Gantt chart similar to Job Conflicts but for Job History. User selectable jobs; Gantt chart timeframe based on earliest job history log entry.
| |
| |-
| |
| | '''Database Mail''' : purging of database mail items and mail log history.
| |
| |-
| |
| | '''Job Monitor''' : copy a job(s) between monitored instances.
| |
| |-
| |
| | '''Job Monitor''' : multi-row selection of jobs to perform actions against selected jobs.
| |
| |-
| |
| | '''Preferences/Insight Config''' : notification quiet hours/days. Implement globally with configuration option to override per Insight.
| |
| |-
| |
| | '''Insight''' : open the Job Monitor upon opening the Insight.
| |
| |-
| |
| | '''Job Monitor''' : change owner of a job or multiple jobs.
| |
| |-
| |
| | '''Job Conflicts''' : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
| |
| |-
| |
| | '''Job Monitor''' : additional column, ''Number of Alerts''.
| |
| |-
| |
| | '''Schedules''' : new context menu with options, ''Job properties'', ''Job history'', ''Purge job history''.
| |
| |-
| |
| | '''Insight''' : logging of heartbeat messages toolbar indicator; blue/green heart icon.
| |
| |-
| |
| | Track the last successful monitored date/time of an instance (i.e., when Insight first opens); store within PREVIOUSINSTANCES.XML. Use this information in the Previously Monitored Instances pane.
| |
| |-
| |
| | '''Job Monitor''' : Ability to dock/open the Job Monitor without opening an Insight.
| |
| |}
| |
| | |
| === <span style="color:#0072c6">Enhancement / Improvement</span> ===
| |
| {| class="wikitable sortable mw-collapsible mw-collapsed"
| |
| !
| |
| |-
| |
| | <strong>Job Monitor</strong> : new metrics including, ''has steps'', ''no history'', ''success rate < 100%'', ''successful job runs with failed job steps'', ''has alerts'', ''has targets'', ''ms-db backup size'', ''ms-db compressed backup size'', ''number of deleted jobs since last poll''.
| |
| * ''number of deleted jobs since last poll'' would additionally log the names of jobs missing. | |
| |-
| |
| | <strong>Insight Log</strong> : row header icons for long running jobs.
| |
| |-
| |
| | <strong>Job Conflicts</strong> : additional context menu items, ''job history''.
| |
| |-
| |
| | <strong>Job History</strong> : access job properties.
| |
| |-
| |
| | <strong>Insight Log</strong> : buttons similar to Log Viewer to filter entries based on severity.
| |
| |-
| |
| | <strong>UI</strong> : filter pane checkbox consistency (style/colors) to match filter popup dialogs.
| |
| |-
| |
| | <strong>Job History</strong> : remove CR and LF characters from message text for better appearance.
| |
| |-
| |
| | <strong>Suspended / Paused Jobs</strong> : ability to resume job(s) from this dialog. (checkbox column ??)
| |
| |-
| |
| | <strong>Job Properties</strong> : display the Job GUID.
| |
| |-
| |
| | <strong>Dashboard</strong> : ability to pick filter for alarms based on predefined time frames, e.g., ''past 24 hours'', ''past 8 hours'', etc. using a filter pane.
| |
| |-
| |
| | <strong>Dashboard</strong> : change ''Date'' column type from text to DateTime for better filtering options.
| |
| |-
| |
| | <strong>Log Viewer</strong> : change ''Log Date/Time'' column type from text to DateTime for better filtering options.
| |
| |}
| |