SQL Agent Insights:Roadmap: Difference between revisions

From SQL Agent Insights Wiki
(Created page with "== In Development / Researching == * <span style="color:#0072c6">N210330-1</span> : Azure SQL managed instance support * <span style="color:#0072c6">E210228-3</span> : convert...")
 
No edit summary
 
(94 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 Insights? Read more below.
== In Development / Researching ==
== In Development / Researching ==
* <span style="color:#0072c6">N210330-1</span> : Azure SQL managed instance support
<br/>
* <span style="color:#0072c6">E210228-3</span> : convert entire SQL Agent Insight project to .NET 6
* Azure® SQL managed instance support.
* <span style="color:#0072c6">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:#0072c6">E210725-1</span> : Preferences : omit asking to create suspend/resume jobs when opening Job Monitor.
* Different licensing models.
* <span style="color:#0072c6">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.
* N210818-1 : Job Monitor : a single instance of Job Monitor that consolidates all jobs from all currently monitored instances.
* Proxy creation, deletion and modification.
* E200602-2 : Job Monitor : new metrics including, ''has steps'', ''no history'', ''success rate < 100%'', ''successful job runs with failed job steps'', ''has alerts'', ''has targets''.
* Ability to sync settings between Insights.
* N210111-1 : Preferences : email authentication via OAuth2.
* Calendar control to supplement Job Outlook.
* N201014-1 : Job History : Gannt chart similar to Job Conflicts but for Job History.
* Ability to overlay multiple instances within Job Outlook.
** user would select jobs to chart.
<br/>
** Gantt chart timeframe based on earliest job history log entry.
{{BrentecFooter}}
* N210112-1 : Insight Log : row header icons for long running jobs.
{{MicrosoftFooter}}
* E170517-1 : Job Conflicts : additional context menu items, ''job history''.
* E200612-3 : Job History : access job properties.
* N181004-1 : Database Mail : purging of database mail items and mail log history.
* N171010-2 : Job Monitor : copy a job(s) between monitored SQL instances.
* N190802-1 : Job Monitor : multi-row selection of jobs to perform actions against selected jobs.
 
== Ready for Next Release ==

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