Server prerequisites
For installing SQL Governor, a "clean slate" standalone server (physical or virtual) is needed with the following requirements:
- Windows Server 2012/2016 64-bit (any version)
- The installation media or an internet connection is also needed
- Internet Information Services (IIS)
- SQL Server 2016 64-bit SP 2 or later
- Basic tempdb optimization as MS SQL Server best practice: http://technet.microsoft.com/en-us/library/ms175527(v=sql.105).aspx
- SQL Server Reporting Services
- SQL Server Integration Services
- Database Mail should be configured
- SQL Server Agent should be running with a startup type of automatic
- Sufficient disk space for SQL Server data files
- PowerShell version 4.0 or newer
- If TLS/SSL encryption is desired, a server certificate is needed.
- Certificate must provide internally-resolvable FQDN for the SQL Governor server.
- TLS/SSL is useful only on scenarios in which SQL Governor and Proxy servers are separated computers.
Hardware requirements
The hardware requirements are mostly dependent on how long the data is stored and the number of instances and databases. Longer storage times and a high number of databases means more disk space is needed. A higher number of instances or databases also increases the hardware requirements.
The following requirements are good rules of thumb for installations of various sizes:
< 1,000 databases
- Standard edition
- Preferred separate standalone or virtualized SQL Server instance
- Minimum 4-core 2,0 GHz Intel E5 processor
- Minimum 16 GB RAM
- Minimum 20 GB disk space
- Appropriate backup space / device
- Necessary disk space for system OS and paging
< 10,000 databases
- Standard or enterprise edition
- Separate standalone or virtualized SQL Server instance
- Minimum 6-core 2,0 GHz Intel E5 processor
- Minimum 64 GB RAM
- Minimum 200 GB disk space
- Appropriate backup space / device
- Necessary disk space for system OS and paging
< 100,000 databases
- Enterprise edition
- Separate standalone SQL Server instance
- Minimum 12-core 2,0 GHz Intel E5 processor
- Minimum 256 GB RAM
- Minimum 2 TB disk space
- Appropriate backup space / device
- Necessary disk space for system OS and paging
< 1,000,000 databases
- Enterprise edition
- Separate standalone SQL Server instance
- Minimum 12-core 2,0 GHz Intel E5 processor
- Minimum 384 GB RAM
- Minimum 20 TB disk space
- Appropriate backup space / device
- Necessary disk space for system OS and paging
Browser support
The recommended browser for SQL Governor is Microsoft Edge. Other browsers are supported with some limitations.
- Microsoft Chromium Edge
- Fully supported
- Internet Explorer
- Not recommended
- Version 11 works but renders some UI components slower
- Compatibility mode is not supported
- Older versions are not supported
- Google Chrome
- Not recommended
- Works but some UI components may not resize correctly
- Report page does not render correctly
The UI is optimized for a 1920 x 1080 resolution screen size (zoom 100%, DPI 100%). Higher zoom levels and custom DPI settings may cause issues with the scaling of some components.