Difference between revisions of "SQL Agent Insight:Roadmap"
Jump to navigation
Jump to search
(→New) |
|||
(69 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 Insight? Read more below. | ||
== In Development / Researching == | == In Development / Researching == | ||
* | === New === | ||
* | * Azure SQL managed instance support | ||
* | * '''UI''' : implement column chooser for all data grids and ability to save layout. | ||
* | * '''Insight''' : Show / log jobs that have a successful outcome but have failed steps within them. | ||
* | |||
=== Enhancement / Improvement === | |||
* Convert entire SQL Agent Insight project to .NET 6 | |||
* '''Preferences''' : omit asking to create suspend/resume jobs when opening Job Monitor. | |||
* '''UI''' : update legacy taskbar notification icons. | |||
== Future Considerations == | == Future Considerations == | ||
=== <span style="color:#1FB141">New</span> === | |||
{| class="wikitable sortable mw-collapsible mw-expanded" | |||
! | |||
|- | |||
| '''Job Monitor''' : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances. | |||
|- | |||
| '''Preferences''' : email authentication via OAuth2. | |||
|- | |||
| '''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-expanded" | |||
! | |||
|- | |||
| <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. | |||
|} |
Latest revision as of 23:34, 19 May 2022
Interested in knowing what I'm working on or thinking of implementing for the next version of SQL Agent Insight? Read more below.
In Development / Researching
New
- Azure SQL managed instance support
- UI : implement column chooser for all data grids and ability to save layout.
- Insight : Show / log jobs that have a successful outcome but have failed steps within them.
Enhancement / Improvement
- Convert entire SQL Agent Insight project to .NET 6
- Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
- UI : update legacy taskbar notification icons.
Future Considerations
New
Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances. |
Preferences : email authentication via OAuth2. |
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. |
Enhancement / Improvement
Job Monitor : 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.
|
Insight Log : row header icons for long running jobs. |
Job Conflicts : additional context menu items, job history. |
Job History : access job properties. |
Insight Log : buttons similar to Log Viewer to filter entries based on severity. |
UI : filter pane checkbox consistency (style/colors) to match filter popup dialogs. |
Job History : remove CR and LF characters from message text for better appearance. |
Suspended / Paused Jobs : ability to resume job(s) from this dialog. (checkbox column ??) |
Job Properties : display the Job GUID. |
Dashboard : ability to pick filter for alarms based on predefined time frames, e.g., past 24 hours, past 8 hours, etc. using a filter pane. |
Dashboard : change Date column type from text to DateTime for better filtering options. |
Log Viewer : change Log Date/Time column type from text to DateTime for better filtering options. |