Difference between revisions of "SQL Agent Insight:Roadmap"

From Brentec Wiki
Jump to navigation Jump to search
(27 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> : {{RoadmapInProgress}}Insight : new job metric showing the number of successful job outcomes that have failed steps from their most recent execution.
* '''UI''' : implement column chooser for all data grids with a significant number of columns with 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.
* '''Operators''' : the ability to create, modify, delete, script, rename, and copy operators. Ability to directly specify failsafe operator.


=== 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}}'''E211016-1'''</span> : UI : update legacy taskbar notification icons.
* '''UI''' : update legacy taskbar notification icons.
 
=== Bugs ===
* {{RoadmapSpanBugColor}}'''B211110-2'''</span> : Dashboard : Alarms category column not showing metric name. ''Affected versions 0.23.2109.0+''


== 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-collapsed"
* {{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.
|-
| '''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.
|-
| '''Connection''' : Ability to open the Job Monitor without opening an Insight.
|}


=== Enhancement / Improvement ===
=== <span style="color:#0072c6">Enhancement / Improvement</span> ===
* {{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''.
{| class="wikitable sortable mw-collapsible mw-collapsed"
** ''number of deleted jobs since last poll'' would additionally log the names of jobs missing.
! &nbsp;
* {{RoadmapSpanEnhanceColor}}'''E210112-1'''</span> : Insight Log : row header icons for long running jobs.
|-
* {{RoadmapSpanEnhanceColor}}'''E170517-1'''</span> : Job Conflicts : additional context menu items, ''job history''.
| <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''.
* {{RoadmapSpanEnhanceColor}}'''E200612-3'''</span> : Job History : access job properties.
* ''number of deleted jobs since last poll'' would additionally log the names of jobs missing.
* {{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.
| <strong>Insight Log</strong> : row header icons for long running jobs.
* {{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 ??)
| <strong>Job Conflicts</strong> : additional context menu items, ''job history''.
* {{RoadmapSpanEnhanceColor}}'''E211014-1'''</span> : Job Properties : display the Job GUID.
|-
* {{RoadmapSpanEnhanceColor}}'''E211018-1'''</span> : 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.
| <strong>Job History</strong> : access job properties.
* {{RoadmapSpanEnhanceColor}}'''E211018-2'''</span> : Dashboard : change ''Date'' column type from text to DateTime for better filtering options.
|-
* {{RoadmapSpanEnhanceColor}}'''E211020-1'''</span> : Log Viewer : change ''Log Date/Time'' column type from text to DateTime for better filtering options.
| <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.
|}


== Ready for Next Release ==
== Ready for Next Release ==
=== Version 0.24 ===
== Released with version 0.23.2111.0 ==
* {{RoadmapSpanEnhanceColor}}'''E211021-1'''</span> : Job Conflict Outlook : refactor to Job Conflicts.
=== <span style="color:#1FB141">New</span> ===
* {{RoadmapSpanEnhanceColor}}'''E200919-4'''</span> : About dialog license indicator; showing the number of days before expiry; if expiry date is approaching, tab icon is now present and number of days highlighted to bring focus.
{| class="wikitable sortable mw-collapsible mw-collapsed"
* {{RoadmapSpanEnhanceColor}}'''E211026-2'''</span> : verbiage for ''Suspend Job'' tooltip in Job Monitor is incorrect. Cannot extend job suspension from the context menu, therefore revised.
! &nbsp;
* {{RoadmapSpanEnhanceColor}}'''E211026-1'''</span> : change verbiage in the suspend/resume create job dialog of ''Agent Job Monitor'' to ''Job Monitor''.
|-
* {{RoadmapSpanEnhanceColor}}'''E211001-3'''</span> : Insight tabs context menu foreground color from white to black, easier to read.
| <strong>Insight</strong> : Two (2) new job metrics. One, successful job outcomes with failed job steps from the entire job history. Two, successful job outcomes with failed job steps in the past 3 days. This brings the total number of monitored metrics to 65.
* {{RoadmapSpanEnhanceColor}}'''E211028-3'''</span> : Due to improved performance in release 0.23.2109.50, help verbiage on form and in pop-up help dialog changed to suit.
|}
* {{RoadmapSpanBugColor}}'''B211005-1'''</span> : Exceptions can be thrown when/if the preferences xml, '''''SQLAI_Preferences.XML''''', has been modified/deleted outside of SQL Agent Insight. Default preferences are assigned prior to loading to mitigate this issue. The preferences file should only be modified by SQL Agent Insight, however, we cannot prevent a user from doing so.
 
* {{RoadmapSpanEnhanceColor}}'''E210718-1'''</span> : Remove CR and LF characters from description and body column data to prevent cell text wrapping. ''Database Mail Items; Database Mail Event Log''
=== <span style="color:#0072c6">Enhancement / Improvement</span> ===
* {{RoadmapSpanBugColor}}'''B211110-1'''</span> : System.NullReferenceException: 'Object reference not set to an instance of an object.' may occur after closing an Insight. Resolved.
{| class="wikitable sortable mw-collapsible mw-collapsed"
! &nbsp;
|-
| <strong>Job Conflict Outlook</strong> : refactor to Job Conflicts.
|-
| <strong>About</strong> : license indicator; showing the number of days before expiry; if expiry date is approaching, tab icon is now present and number of days highlighted to bring focus.
|-
| <strong>UI</strong> : verbiage for ''Suspend Job'' tooltip in Job Monitor is incorrect. Cannot extend job suspension from the context menu, therefore revised.
|-
| <strong>UI</strong> : change verbiage in the suspend/resume create job dialog of ''Agent Job Monitor'' to ''Job Monitor''.
|-
| <strong>UI</strong> : Insight tabs context menu foreground color from white to black, easier to read.
|-
| <strong>UI</strong> : Due to improved performance in release 0.23.2109.50, help verbiage in Job Conflicts and its pop-up help dialog changed to suit.
|-
| <strong>Database Mail Items</strong> : Remove CR and LF characters from description and body column data to prevent cell text wrapping. ''Database Mail Items; Database Mail Event Log''
|}
 
=== <span style="color:#FF0000">Bugs Squashed</span> ===
{| class="wikitable sortable mw-collapsible mw-collapsed"
! &nbsp;
|-
| <strong>Preferences</strong> : Exceptions can be thrown when/if the preferences xml, '''''SQLAI_Preferences.XML''''', has been modified/deleted outside of SQL Agent Insight. Default preferences are assigned prior to loading to mitigate this issue. The preferences file should only be modified by SQL Agent Insight, however, we cannot prevent a user from doing so.
|-
| <strong>Insight</strong> : System.NullReferenceException: 'Object reference not set to an instance of an object.' may occur after closing an Insight. Resolved.
|-
| <strong>Dashboard</strong> : Alarms category column no longer showing metric name. ''Affected versions 0.23.2109.0, 0.23.2109.50''
|-
| <strong>Insight</strong> : Insight log collection finish time is the same as the collection start time.
|-
| <strong>Insight</strong> : Threshold validation may sometimes result in an incorrect severity being applied to a metric, and potentially not issuing notifications.
|}

Revision as of 12:19, 2 January 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 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.
  • Operators : the ability to create, modify, delete, script, rename, and copy operators. Ability to directly specify failsafe operator.

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.
Connection : Ability to 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.

Ready for Next Release

Released with version 0.23.2111.0

New

 
Insight : Two (2) new job metrics. One, successful job outcomes with failed job steps from the entire job history. Two, successful job outcomes with failed job steps in the past 3 days. This brings the total number of monitored metrics to 65.

Enhancement / Improvement

 
Job Conflict Outlook : refactor to Job Conflicts.
About : license indicator; showing the number of days before expiry; if expiry date is approaching, tab icon is now present and number of days highlighted to bring focus.
UI : verbiage for Suspend Job tooltip in Job Monitor is incorrect. Cannot extend job suspension from the context menu, therefore revised.
UI : change verbiage in the suspend/resume create job dialog of Agent Job Monitor to Job Monitor.
UI : Insight tabs context menu foreground color from white to black, easier to read.
UI : Due to improved performance in release 0.23.2109.50, help verbiage in Job Conflicts and its pop-up help dialog changed to suit.
Database Mail Items : Remove CR and LF characters from description and body column data to prevent cell text wrapping. Database Mail Items; Database Mail Event Log

Bugs Squashed

 
Preferences : Exceptions can be thrown when/if the preferences xml, SQLAI_Preferences.XML, has been modified/deleted outside of SQL Agent Insight. Default preferences are assigned prior to loading to mitigate this issue. The preferences file should only be modified by SQL Agent Insight, however, we cannot prevent a user from doing so.
Insight : System.NullReferenceException: 'Object reference not set to an instance of an object.' may occur after closing an Insight. Resolved.
Dashboard : Alarms category column no longer showing metric name. Affected versions 0.23.2109.0, 0.23.2109.50
Insight : Insight log collection finish time is the same as the collection start time.
Insight : Threshold validation may sometimes result in an incorrect severity being applied to a metric, and potentially not issuing notifications.