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

Platform

Requirement

CPU
  • 2.0 GHz or higher
Memory
  • 1 GB

Operating System
(32-bit and 64-bit)

 

 Microsoft Windows
  • 10
  • 8
  • 7 SP1 or later
  Microsoft Windows Server
  • 2019
  • 2016
  • 2012 R2
  • 2012
  • 2008 R2
  • 2008 SP2 or later
  • 2003 SP2 or later
Development FrameworkMicrosoft .NET
  • 4.0 or later

Client Browser


  • Internet Explorer 7.0 or later

Cloud 
(for host and managing database instances)

  • Amazon Elastic Compute Cloud (EC2)
  • Microsoft Azure Virtual Machine (VM)

Cloud
(for managing cloud databases)

  • Amazon Relational Database Service (RDS) for SQL Server
  • Microsoft Azure SQL Database

Managed Database Instances

Amazon Relational Database Service for SQL Server


Microsoft Azure SQL Database


Microsoft SQL Server (Express, Standard, Enterprise)

  • 2019 (Windows, Linux)
  • 2017 (Windows, Linux)
  • 2016
  • 2014
  • 2012
  • 2008 R2
  • 2008
  • 2005

Red Hat Enterprise (OS)

  • 7.3

SUSE Enterprise (OS)

  • 12 SP2

Ubuntu (OS)

  • 16.04 LTS
  • 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 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