SQL Agent Insights:Roadmap: Difference between revisions

From SQL Agent Insights Wiki
No edit summary
 
(83 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 ==
* {{RoadmapSpanNewColor}}'''N210330-1'''</span> : Azure SQL managed instance support
<br/>
* <span style="color:#3CB5B2">'''E210228-3'''</span> : convert entire SQL Agent Insight project to .NET 6
* 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.
* <span style="color:#3CB5B2">'''E210725-1'''</span> : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
* Different licensing models.
* {{RoadmapSpanNewColor}}'''N210913-1'''</span> : UI : implement column chooser for all data grids with a significant number of columns with ability to save layout.
* Copy agent jobs between monitored instances.
 
* Job conflicts per individual job.
== Future Considerations ==
* Dynamic metric thresholds.
* <span style="color:#8450A0">'''N210818-1'''</span> : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
* Proxy creation, deletion and modification.
* <span style="color:#3CB5B2">'''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''.
* Ability to sync settings between Insights.
** ''number of deleted jobs since last poll'' would additionally log the names of jobs missing.
* Calendar control to supplement Job Outlook.
* <span style="color:#8450A0">'''N210111-1'''</span> : Preferences : email authentication via OAuth2.
* Ability to overlay multiple instances within Job Outlook.
* <span style="color:#8450A0">'''N201014-1'''</span> : Job History : Gantt chart similar to Job Conflicts but for Job History.
<br/>
** user would select jobs to chart.
{{BrentecFooter}}
** Gantt chart timeframe based on earliest job history log entry.
{{MicrosoftFooter}}
* <span style="color:#8450A0">'''N210112-1'''</span> : Insight Log : row header icons for long running jobs.
* <span style="color:#3CB5B2">'''E170517-1'''</span> : Job Conflicts : additional context menu items, ''job history''.
* <span style="color:#3CB5B2">'''E200612-3'''</span> : Job History : access job properties.
* <span style="color:#8450A0">'''N181004-1'''</span> : Database Mail : purging of database mail items and mail log history.
* <span style="color:#8450A0">'''N171010-2'''</span> : Job Monitor : copy a job(s) between monitored SQL instances.
* <span style="color:#8450A0">'''N190802-1'''</span> : Job Monitor : multi-row selection of jobs to perform actions against selected jobs.
* <span style="color:#8450A0">'''N200827-2'''</span> : Preferences : notification quiet hours/days.
* <span style="color:#8450A0">'''N200822-1'''</span> : Insight : open the Job Monitor upon opening the Insight.
* <span style="color:#3CB5B2">'''E210103-1'''</span> : Insight Log : buttons similar to Log Viewer to filter entries based on severity.
* <span style="color:#8450A0">'''N210510-1'''</span> : Job Monitor : change owner of a job or multiple jobs.
* <span style="color:#8450A0">'''N210610-1'''</span> : Job Conflicts : a single instance of Job Conflicts that consolidates all jobs from all currently monitored instances.
* <span style="color:#8450A0">'''N210706-2'''</span> : Job Monitor : new column, ''Number of Alerts''.
* <span style="color:#8450A0">'''N210706-1'''</span> : Schedules : new context menu with options, ''Job properties'', ''Job history'', ''Purge job history''.
 
== Ready for Next Release ==
=== Version 0.24 ===

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