SQL Agent Insights:Roadmap: Difference between revisions
(→New) |
|||
| Line 3: | Line 3: | ||
== In Development / Researching == | == In Development / Researching == | ||
=== New === | === New === | ||
* Azure SQL managed instance support | * Azure SQL managed instance support. | ||
* | * Convert entire SQL Agent Insight project to .NET 6+. | ||
* | * Different licensing model for free version. | ||
=== Enhancement / Improvement === | === Enhancement / Improvement / Bug Fixes === | ||
* | * Dashboard improvements. | ||
* | * Tray icon context menu bug fixes/improvements. | ||
* | * Job Monitor tile bar improvements. | ||
== Future Considerations == | == Future Considerations == | ||
Revision as of 16:26, 16 October 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.
- Convert entire SQL Agent Insight project to .NET 6+.
- Different licensing model for free version.
Enhancement / Improvement / Bug Fixes
- Dashboard improvements.
- Tray icon context menu bug fixes/improvements.
- Job Monitor tile bar improvements.
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. |
| Job Monitor : Ability to dock/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.
|
| 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. |