Hardware Requirements
Hardware Requirements
The following memory and processor requirements apply to all editions of DBA xPress:
| Component | Minimum Requirement | Recommended Requirement |
|---|---|---|
| Memory | 4 GB | At least 8 GB |
| Processor Speed | 1.4 GHz | 2.0 GHz or faster |
| Processor Type | Not Applicable | Any x64 Processor |
Note: Hardware requirements can vary based on workloads and other processes.
Software Requirements
Software Requirements
- SQL Server Integration Services 2012, 2014, 2016, 2017 or SSDT 2010, 2012, 2014, 2016, 2017 (SQL Server Data Tools)
- Microsoft ® .NET 3.5 with Service Pack 1
- Microsoft ® .NET 4.0
- Microsoft ® .NET 4.5 (2017 Providers only)
- Microsoft ® SQL Server ® 2012 Transact-SQL ScriptDom x86
The following operating systems are supported by the SentryOne Workbench:
| 64-bit (x64) Operating Systems | 32-bit (x86) Operating Systems |
|---|---|
| Windows Server 2003 (at least Service Pack 2) * | Windows XP (at least Service Pack 3) * |
| Windows Vista (at least Service Pack 2) | Windows Server 2003 (at least Service Pack 3) * |
| Windows Server 2008 R2 | Windows Vista (at least Service Pack 2) |
| Windows Server 2012 | Windows Server 2008 R2 |
| Windows Server 2016 | Windows Server 2012 |
| Windows 7 | Windows 7 |
| Windows 8 | Windows 8 |
| Windows 10 | Windows 10 |
Important: Windows XP and Server 2003 have been deprecated from full support. Any issues encountered on either Windows XP or Server 2003 must be reproducible on newer versions of Windows to be eligible for support.
Required Permissions
Required Permissions
Many of the features within the SentryOne Workbench only need db_owner for database updates when upgrading from an older version to a newer version. Outside of database updates, you only need db_datareader and db_datawriter permissions.
The following is a comprehensive list of each feature and their required permissions:
DBA xPress Required Permissions
| Technologies | Required Permissions |
|---|---|
| Data Inspector, Data Space Analyzer, Data Surf, Object Browser, Schema Surf | Each object being manipulated:
|
| Schema Inspector, Schema Inspector Snapshot Tool | Each object being manipulated:
|
Workbench
System Requirements for other Workbench Products
The following prerequisites are required to enable some features within BI xPress and DOC xPress:
| 64-bit Operating Systems | 32-bit Operating Systems |
|---|---|
| Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 (or later) x64 | Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 (or later) x86 |
| Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x64 | Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x86 |
| Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x64 | Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x86 |
| Microsoft ® SQL Server ® 2012 (or later) Transact-SQL ScriptDom x64 | Microsoft ® SQL Server ® 2012 (or later) Transact-SQL ScriptDom x86 |
| Microsoft ® System CLR Types for Microsoft ® SQL Server ® 2012 (or later) x86 | |
| Microsoft ® SQL Server ® 2012 (or later) Shared Management Objects x86 | |
| Microsoft ® SQL Server ® 2012 (or later) Analysis Management Objects x86 | |
| Microsoft ® SQL Server ® 2012 (or later) Transact-SQL ScriptDom x86 |
Providers
| Provider | Operating Systems | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Hive |
| ||||||||||||
| SQL |
| ||||||||||||
| SSAS |
| ||||||||||||
| SSIS |
| ||||||||||||
| SSRS |
| ||||||||||||
| Informatica PowerCenter | If connecting to a SQL Repository:
|
Unsupported:
- SSAS, SQL, SSIS, and SSRS versions 2008 R2 and earlier are no longer officially supported. The providers remain accessible in the software if the prerequisites are met, however, we will not be able to provide support for any issues that are specific to these older releases.
- Hive, Informatica, and Oracle have been deprecated. No additional updates or support are available for these providers.
The following prerequisites are required to enable some features within BI xPress:
BI xPress extension for Visual Studio 2015 requires:
- An installation of one of the following editions of Visual Studio:
- Visual Studio 2015 Community Edition
- Visual Studio 2015 Professional
- Visual Studio 2015 Enterprise
- The following extension installed within their Visual Studio 2015 environment:
- SQL Server Data Tools for SQL Server 2016 (now includes BI Projects)
Plug-ins:
- Auditing Framework, BI Compare, Package Builder Wizard, and/or SSIS Unit Test:
- Any Third-Party Products (Connection Managers, Tasks, Components, etc.) that are used within the SSIS Package(s)
- Report Mover
- Reporting Deployment is compatible with SQL 2012 or later
- Report Monitoring Console:
- Reporting Performance Monitor is compatible with SQL Server 2012 or later
The following prerequisites are required to enable some features within DOC xPress:
- SQL 2012 or later is required to create a DOC xPress metabase.
Note: If you're connected to a valid DOC xPress metabase, SQL 2005 and up may be documented, though there are some limitations to SSRS 2005 and 2008 documentation.
- Documentation requires CHM (Compiled HTML Help)
