You can easily and quickly install SQL Doctor on any computer that meets or exceeds the following hardware, software, and permissions requirements.

Consider the following requirements when installing SQL Doctor in a typical environment:

Type

Requirement

CPU2.0 GHz or higher
Memory1 GB
Operating System (32-bit and 64-bit)
  • Windows Server 2003 SP2+
  • Windows Server 2008 SP2+
  • Windows Server 2008 R2
  • Windows 7 SP1+
  • Windows 8
  • Windows 10
  • Windows Server 2012
  • Windows Server 2012 R2
  • Windows 2016
  • Windows 2019
  • Microsoft Windows Azure
  • Amazon EC2
Microsoft .NET Framework.NET 4.0
Client Browser

Internet Explorer 7.0 or later

SQL Server
  • SQL Server 2005 - All Editions
  • SQL Server 2008 - All Editions
  • SQL Server 2008 R2 - All Editions
  • SQL Server 2012 -  All Editions
  • SQL Server 2014 - All Editions
  • SQL Server 2016 -  All Editions
  • SQL Server 2017 - All Editions (Windows and Linux)
  • SQL Server 2019
  • Microsoft SQL Azure
  • Amazon RDS SQL Sever

SQL Doctor is able to connect and analyze SQL Server instances running on the following operating systems (Windows and Linux):

Windows:

  • Windows Server 2003 SP2+
  • Windows Server 2008 SP2+
  • Windows 7
  • Windows 8
  • Windows Server 2008 R2
  • Windows Server 2012
  • Windows Server 2012 R2
  • Windows 10
  • Windows 2016

Linux:

  • Red hat Enterprise 7.3
  • SUSE Enterprise v12 SP2
  • Ubuntu 16.04LTS and 16.10
OLE Automation Enabled

By default, SQL Doctor uses WMI to collect data for the analysis. However, you can choose to use OLE automation instead. For more information, see SQL Doctor and OLE automation.

Permissions

SQL Doctor requires that the Windows account or SQL login used to connect to the analyzed SQL Server instance has sysadmin privileges on this instance.

SQL Doctor 3.7 supports Microsoft SQL Azure and Amazon RDS.

SQL Doctor supports the following Amazon regions:

  • AP-NORTH-EAST-1
  • AP-NORTH-EAST-2
  • AP-SOUTH-EAST-1
  • AP-SOUTH-EAST-2
  • CN-NORTH-1
  • EU-CENTRAL-1
  • EU-WEST-1
  • SA-EAST-1
  • US-EAST-1
  • US-GOVCLOUD-WEST-1
  • US-WEST-1
  • US-WEST-2
  • US-EAST-2

In SQL Doctor, the Azure master account has the equivalent of Sys Admin privileges.



IDERAProductsPurchase | Support | Community | Resources | About Us | Legal