SQL Agent Insight uses a small amount of tempdb space, and if the option to suspend/resume agent jobs is chosen, SQL Agent Insight will create 2 custom agent jobs, 1 custom agent schedule, and 1 custom agent category, which are stored natively within msdb system database.
SQL Agent Insight has been tested with SQL Server® 2005 through to 2019.
Brentec always aims to support the latest version of the SQL platform within 6 months from the RTM release.
- Microsoft® .NET 4.6 (or greater) and a supported operating system are required.
- Available at the Microsoft® .NET Framework 4.6 (offline installer) page.
- for Windows Vista® SP2, Windows® 7 SP1, Windows® 8, Windows® 8.1, Windows Server® 2008 SP2 Windows Server® 2008 R2 SP1, Windows Server® 2012 and Windows Server® 2012 R2
- .NET 4.6 replaces 4.0 through 4.5.2 and released on 2015-07-20.
Starting with version 0.20 of SQL Agent Insight, the Microsoft® SQL Server® Feature Pack is no longer required as a separate install.
Instead, the project was compiled including the Microsoft.SqlServer.SqlManagementObjects (SMO) package 150.18118.0 (2019-04-20) from nuget.org.
Update February 26, 2020: In order to provide an efficient and optimized experience, starting with version 0.22 of SQL Agent Insight,
Microsoft® SQL Server® 2005, 2008 and 2008 R2 will no longer be supported.
For the best possible experience while using SQL Agent Insight it is highly recommended to use:
- Microsoft® Windows® 10 or Microsoft® Windows Server® 2016+
- Computer mouse and a minimum screen resolution of 1440 x 900
Testing and development has been successfully done with:
- Windows® 10 (Version 1903 – OS build 18362.356), against
- a SQL Server® collation of SQL_Latin1_General_CP1_CI_AS
- Other server collations have not been tested.
The following operating systems have not been tested extensively and will not be tested in the future, for the sake of time, and based on market share. However, if the above requirements are met, there is a pretty good chance SQL Agent Insight will function normally on these operating systems:
- Windows Vista® SP2 | 7 | 8 | 8.1