Difference between revisions of "SQL Agent Insight:Roadmap"

From Brentec Wiki
Jump to navigation Jump to search
 
(55 intermediate revisions by the same user not shown)
Line 3: Line 3:
== In Development / Researching ==
== In Development / Researching ==
=== New ===
=== New ===
* {{RoadmapSpanNewColor}}'''N210330-1'''</span> : Azure SQL managed instance support
* Azure SQL managed instance support
* {{RoadmapSpanNewColor}}'''N210821-1'''</span> : Insight : new job metric showing successful jobs that have failed steps in the history.
* '''UI''' : implement column chooser for all data grids and ability to save layout.
* {{RoadmapSpanNewColor}}'''N210913-1'''</span> : 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 ===
=== Enhancement / Improvement ===
* {{RoadmapSpanEnhanceColor}}'''E210228-3'''</span> : convert entire SQL Agent Insight project to .NET 6
* Convert entire SQL Agent Insight project to .NET 6
* {{RoadmapSpanEnhanceColor}}'''E210725-1'''</span> : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
* '''Preferences''' : omit asking to create suspend/resume jobs when opening Job Monitor.
* {{RoadmapSpanEnhanceColor}}'''E211021-1'''</span> : Job Conflict Outlook : rename to Job Conflicts.
* '''UI''' : update legacy taskbar notification icons.
* {{RoadmapSpanEnhanceColor}}'''E211016-1'''</span> : UI : update legacy taskbar notification icons.


== Future Considerations ==
== Future Considerations ==
=== New ===
=== <span style="color:#1FB141">New</span> ===
* {{RoadmapSpanNewColor}}'''N210818-1'''</span> : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
{| class="wikitable sortable mw-collapsible mw-expanded"
* {{RoadmapSpanNewColor}}'''N210111-1'''</span> : Preferences : email authentication via OAuth2.
! &nbsp;
* {{RoadmapSpanNewColor}}'''N201014-1'''</span> : 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.
| '''Job Monitor''' : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
* {{RoadmapSpanNewColor}}'''N181004-1'''</span> : Database Mail : purging of database mail items and mail log history.
|-
* {{RoadmapSpanNewColor}}'''N171010-2'''</span> : Job Monitor : copy a job(s) between monitored instances.
| '''Preferences''' : email authentication via OAuth2.
* {{RoadmapSpanNewColor}}'''N190802-1'''</span> : Job Monitor : multi-row selection of jobs to perform actions against selected jobs.
|-
* {{RoadmapSpanNewColor}}'''N200827-2'''</span> : Preferences/Insight Config : notification quiet hours/days.
| '''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.
** implement globally with configuration option to override per Insight.
|-
* {{RoadmapSpanNewColor}}'''N200822-1'''</span> : Insight : open the Job Monitor upon opening the Insight.
| '''Database Mail''' : purging of database mail items and mail log history.
* {{RoadmapSpanNewColor}}'''N210510-1'''</span> : Job Monitor : change owner of a job or multiple jobs.
|-
* {{RoadmapSpanNewColor}}'''N210610-1'''</span> : Job Conflicts : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
| '''Job Monitor''' : copy a job(s) between monitored instances.
* {{RoadmapSpanNewColor}}'''N210706-2'''</span> : Job Monitor : additional column, ''Number of Alerts''.
|-
* {{RoadmapSpanNewColor}}'''N210706-1'''</span> : Schedules : new context menu with options, ''Job properties'', ''Job history'', ''Purge job history''.
| '''Job Monitor''' : multi-row selection of jobs to perform actions against selected jobs.
* {{RoadmapSpanNewColor}}'''N211020-1'''</span> : Insight : logging of heartbeat messages toolbar indicator; blue/green heart icon.
|-
* {{RoadmapSpanNewColor}}'''N211001-1'''</span> : 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.
| '''Preferences/Insight Config''' : notification quiet hours/days. Implement globally with configuration option to override per Insight.
* {{RoadmapSpanNewColor}}'''N211018-1'''</span> : ability to open the Job Monitor without opening an Insight for monitoring from Connection dialog.
|-
 
| '''Insight''' : open the Job Monitor upon opening the Insight.
=== Enhancement / Improvement ===
|-
* {{RoadmapSpanEnhanceColor}}'''E200602-2'''</span> : 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''.
| '''Job Monitor''' : change owner of a job or multiple jobs.
** ''number of deleted jobs since last poll'' would additionally log the names of jobs missing.
|-
* {{RoadmapSpanEnhanceColor}}'''E210112-1'''</span> : Insight Log : row header icons for long running jobs.
| '''Job Conflicts''' : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
* {{RoadmapSpanEnhanceColor}}'''E170517-1'''</span> : Job Conflicts : additional context menu items, ''job history''.
|-
* {{RoadmapSpanEnhanceColor}}'''E200612-3'''</span> : Job History : access job properties.
| '''Job Monitor''' : additional column, ''Number of Alerts''.
* {{RoadmapSpanEnhanceColor}}'''E210103-1'''</span> : Insight Log : buttons similar to Log Viewer to filter entries based on severity.
|-
* {{RoadmapSpanEnhanceColor}}'''E211020-2'''</span> : UI : filter pane checkbox consistency (style/colors) to match filter popup dialogs.
| '''Schedules''' : new context menu with options, ''Job properties'', ''Job history'', ''Purge job history''.
* {{RoadmapSpanEnhanceColor}}'''E211011-2'''</span> : Job History : remove CR and LF characters from message text for better appearance.
|-
* {{RoadmapSpanEnhanceColor}}'''E211011-3'''</span> : Suspended / Paused Jobs : ability to resume job(s) from this dialog. (checkbox column ??)
| '''Insight''' : logging of heartbeat messages toolbar indicator; blue/green heart icon.
* {{RoadmapSpanEnhanceColor}}'''E211014-1'''</span> : Job Properties : display the Job GUID.
|-
* {{RoadmapSpanEnhanceColor}}'''E211018-1'''</span> : Dashboard : ability to pick filter based on predefined time frames, e.g., ''past 24 hours'', ''past 8 hours'', etc. using a filter pane.
| 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.
|}


== Ready for Next Release ==
=== <span style="color:#0072c6">Enhancement / Improvement</span> ===
=== Version 0.24 ===
{| class="wikitable sortable mw-collapsible mw-expanded"
! &nbsp;
|-
| <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.
  • number of deleted jobs since last poll would additionally log the names of jobs missing.
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.