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 |
|---|
| CPU | 2.0 GHz or higher |
| Memory | 1 GB |
| Operating System (32-bit |
Operating System 2008 SP3- 2003 SP2+
- Windows Server 2008
|
R2Windows Server 2003 SP3Windows XP Vista SP1+- Server 2008 R2
- Windows 7 SP1+
- Windows 8
- Windows
|
2012Windows .Net 3.5, .Net 4.0, and MDAC 2.864-bit Operating System | 2008 SP3+ (x64) 2008 + (x64) Server 2003 SP3 XP Professional (x64)Windows Vista Business and Enterprise (x64)Windows 7 SP1+ (x64)Windows 8 (x64)Windows 2012Windows 10- Microsoft Windows Azure
- Amazon EC2
|
| Microsoft .NET Framework | .NET 4.0 |
.Net 3.5, .Net 4.0, and MDAC 2.8 |
| Client Browser | Internet Explorer 7.0 or later |
| SQL Server |
Standard or Enterprise Edition SP1 or later- - All Editions
- SQL Server 2008
|
RTM or later- - All Editions
- SQL Server 2008 R2
|
or later- - 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 provides complete SQL performance tuning. Learn more > >
...
| Info |
|---|
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
|
| Note |
|---|
In SQL Doctor, the Azure master account has the equivalent of Sys Admin privileges. |
...