SQL Agent Insights:Roadmap: Difference between revisions

From SQL Agent Insights Wiki
No edit summary
 
(64 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/>
* {{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.
* Convert entire SQL Agent Insights project to .NET 6 or greater.
* {{RoadmapSpanNewColor}}'''N210913-1'''</span> : UI : implement column chooser for all data grids with a significant number of columns with ability to save layout.
* Different licensing models.
=== Enhancement / Improvement ===
* Copy agent jobs between monitored instances.
* {{RoadmapSpanEnhanceColor}}'''E210228-3'''</span> : convert entire SQL Agent Insight project to .NET 6
* Job conflicts per individual job.
* {{RoadmapSpanEnhanceColor}}'''E210725-1'''</span> : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
* Dynamic metric thresholds.
* {{RoadmapSpanEnhanceColor}}'''E211016-1'''</span> : UI : update legacy taskbar notification icons.
* Proxy creation, deletion and modification.
 
* Ability to sync settings between Insights.
== Future Considerations ==
* Calendar control to supplement Job Outlook.
=== New ===
* Ability to overlay multiple instances within Job Outlook.
* {{RoadmapSpanNewColor}}'''N210818-1'''</span> : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
<br/>
* {{RoadmapSpanNewColor}}'''N210111-1'''</span> : Preferences : email authentication via OAuth2.
{{BrentecFooter}}
* {{RoadmapSpanNewColor}}'''N201014-1'''</span> : Job History : Gantt chart similar to Job Conflicts but for Job History.
{{MicrosoftFooter}}
** 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}}'''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}}'''N200827-2'''</span> : Preferences/Insight Config : notification quiet hours/days.
** implement globally with configuration option to override per Insight.
* {{RoadmapSpanNewColor}}'''N200822-1'''</span> : Insight : open the Job Monitor upon opening the Insight.
* {{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.
* {{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}}'''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 ===
* {{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''.
** ''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.
* {{RoadmapSpanEnhanceColor}}'''E170517-1'''</span> : Job Conflicts : additional context menu items, ''job history''.
* {{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}}'''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.
* {{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.
* {{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.
 
== Ready for Next Release ==
=== Version 0.24 ===
* {{RoadmapSpanEnhanceColor}}'''E211021-1'''</span> : Job Conflict Outlook : refactor to Job Conflicts.
* {{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.
* {{RoadmapSpanEnhanceColor}}'''E211026-2'''</span> : verbiage for ''Suspend Job'' tooltip in Job Monitor is incorrect. Cannot extend job suspension from the context menu, therefore revised.
* {{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.

Latest revision as of 21:14, 4 November 2023

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


  • Azure® SQL managed instance support.
  • Convert entire SQL Agent Insights project to .NET 6 or greater.
  • Different licensing models.
  • Copy agent jobs between monitored instances.
  • Job conflicts per individual job.
  • Dynamic metric thresholds.
  • Proxy creation, deletion and modification.
  • Ability to sync settings between Insights.
  • Calendar control to supplement Job Outlook.
  • Ability to overlay multiple instances within Job Outlook.



Brentec Homepage | Consulting | Contact | Follow on Mastodon


Microsoft®, Windows® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Some icons courtesy of Icons8