SQL Agent Insights:Roadmap: Difference between revisions
No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
* {{RoadmapSpanEnhanceColor}}'''E210228-3'''</span> : convert entire SQL Agent Insight project to .NET 6 | * {{RoadmapSpanEnhanceColor}}'''E210228-3'''</span> : 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. | * {{RoadmapSpanEnhanceColor}}'''E210725-1'''</span> : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor. | ||
* {{RoadmapSpanEnhanceColor}}'''E211021-1'''</span> : Job Conflict Outlook : rename to Job Conflicts. | |||
* {{RoadmapSpanEnhanceColor}}'''E211016-1'''</span> : UI : update legacy taskbar notification icons. | |||
== Future Considerations == | == Future Considerations == | ||
| Line 17: | Line 19: | ||
** user selectable jobs; Gantt chart timeframe based on earliest job history log entry. | ** user selectable jobs; Gantt chart timeframe based on earliest job history log entry. | ||
* {{RoadmapSpanNewColor}}'''N181004-1'''</span> : Database Mail : purging of database mail items and mail log history. | * {{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 | * {{RoadmapSpanNewColor}}'''N171010-2'''</span> : Job Monitor : copy a job(s) between monitored instances. | ||
* {{RoadmapSpanNewColor}}'''N190802-1'''</span> : Job Monitor : multi-row selection of jobs to perform actions against selected jobs. | * {{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. | * {{RoadmapSpanNewColor}}'''N200827-2'''</span> : Preferences/Insight Config : notification quiet hours/days. | ||
| Line 26: | Line 28: | ||
* {{RoadmapSpanNewColor}}'''N210706-2'''</span> : Job Monitor : additional column, ''Number of Alerts''. | * {{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''. | * {{RoadmapSpanNewColor}}'''N210706-1'''</span> : Schedules : new context menu with options, ''Job properties'', ''Job history'', ''Purge job history''. | ||
* {{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. | |||
* {{RoadmapSpanNewColor}}'''N211018-1'''</span> : ability to open the Job Monitor without opening an Insight for monitoring from Connection dialog. | |||
=== Enhancement / Improvement === | === Enhancement / Improvement === | ||
| Line 34: | Line 39: | ||
* {{RoadmapSpanEnhanceColor}}'''E200612-3'''</span> : Job History : access job properties. | * {{RoadmapSpanEnhanceColor}}'''E200612-3'''</span> : Job History : access job properties. | ||
* {{RoadmapSpanEnhanceColor}}'''E210103-1'''</span> : Insight Log : buttons similar to Log Viewer to filter entries based on severity. | * {{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. | |||
* {{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 ??) | |||
* {{RoadmapSpanEnhanceColor}}'''E211014-1'''</span> : Job Properties : display the Job GUID. | |||
== Ready for Next Release == | == Ready for Next Release == | ||
=== Version 0.24 === | === Version 0.24 === | ||
Revision as of 04:28, 21 October 2021
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
- Template:RoadmapSpanNewColorN210330-1 : Azure SQL managed instance support
- Template:RoadmapSpanNewColorN210821-1 : Insight : new job metric showing successful jobs that have failed steps in the history.
- Template:RoadmapSpanNewColorN210913-1 : UI : implement column chooser for all data grids with a significant number of columns with ability to save layout.
Enhancement / Improvement
- Template:RoadmapSpanEnhanceColorE210228-3 : convert entire SQL Agent Insight project to .NET 6
- Template:RoadmapSpanEnhanceColorE210725-1 : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
- Template:RoadmapSpanEnhanceColorE211021-1 : Job Conflict Outlook : rename to Job Conflicts.
- Template:RoadmapSpanEnhanceColorE211016-1 : UI : update legacy taskbar notification icons.
Future Considerations
New
- Template:RoadmapSpanNewColorN210818-1 : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
- Template:RoadmapSpanNewColorN210111-1 : Preferences : email authentication via OAuth2.
- Template:RoadmapSpanNewColorN201014-1 : 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.
- Template:RoadmapSpanNewColorN181004-1 : Database Mail : purging of database mail items and mail log history.
- Template:RoadmapSpanNewColorN171010-2 : Job Monitor : copy a job(s) between monitored instances.
- Template:RoadmapSpanNewColorN190802-1 : Job Monitor : multi-row selection of jobs to perform actions against selected jobs.
- Template:RoadmapSpanNewColorN200827-2 : Preferences/Insight Config : notification quiet hours/days.
- implement globally with configuration option to override per Insight.
- Template:RoadmapSpanNewColorN200822-1 : Insight : open the Job Monitor upon opening the Insight.
- Template:RoadmapSpanNewColorN210510-1 : Job Monitor : change owner of a job or multiple jobs.
- Template:RoadmapSpanNewColorN210610-1 : Job Conflicts : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
- Template:RoadmapSpanNewColorN210706-2 : Job Monitor : additional column, Number of Alerts.
- Template:RoadmapSpanNewColorN210706-1 : Schedules : new context menu with options, Job properties, Job history, Purge job history.
- Template:RoadmapSpanNewColorN211020-1 : Insight : logging of heartbeat messages toolbar indicator; blue/green heart icon.
- Template:RoadmapSpanNewColorN211001-1 : 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.
- Template:RoadmapSpanNewColorN211018-1 : ability to open the Job Monitor without opening an Insight for monitoring from Connection dialog.
Enhancement / Improvement
- Template:RoadmapSpanEnhanceColorE200602-2 : 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.
- Template:RoadmapSpanEnhanceColorE210112-1 : Insight Log : row header icons for long running jobs.
- Template:RoadmapSpanEnhanceColorE170517-1 : Job Conflicts : additional context menu items, job history.
- Template:RoadmapSpanEnhanceColorE200612-3 : Job History : access job properties.
- Template:RoadmapSpanEnhanceColorE210103-1 : Insight Log : buttons similar to Log Viewer to filter entries based on severity.
- Template:RoadmapSpanEnhanceColorE211020-2 : UI : filter pane checkbox consistency (style/colors) to match filter popup dialogs.
- Template:RoadmapSpanEnhanceColorE211011-2 : Job History : remove CR and LF characters from message text for better appearance.
- Template:RoadmapSpanEnhanceColorE211011-3 : Suspended / Paused Jobs : ability to resume job(s) from this dialog. (checkbox column ??)
- Template:RoadmapSpanEnhanceColorE211014-1 : Job Properties : display the Job GUID.