Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

SQL Diagnostic Manager 1012.2 3 requires Microsoft SQL Server 2005 SQL Server 2016 or above running on the computer that hosts the SQL Diagnostic Manager Repository database for all installations.

...

Info

To run PowerShell scripts, upgrade to PowerShell 3.0 or higher. This upgrade is required to use the PowerShell snap-in.

...

Consider the following requirements when installing all SQL Diagnostic Manager components on one computer.

Type

Requirement

SQL Server Standard or Enterprise Edition

  • SQL Server 2005 SP1 or later
  • SQL Server 2008 or later
  • SQL Server 2008 R2
    • SQL Server 2016

    Only on Windows and Linux

    • SQL Server
    2012
    • 2017
    • SQL Server
    2014
    • 2019
    • SQL Server
    2016
    • 2022
    Info

    SQL

    Server 2017

    Diagnostic Manager monitors and supports older versions of SQL Server on a best-effort basis.

    Hard Disk Space

    200 MB for all SQL Diagnostic Manager components

    Windows Permissions

    Your Windows Logon account includes local Administrator permissions

    SQL Server Privileges

    Either a Windows user account or SQL Server login that includes System Administrator privileges on the monitored SQL Server instances

    General requirements

    The following requirements apply for to all SQL Diagnostic Manager components.

    Type

    Requirement

    CPU

    2.0 GHz or higher

    Memory

    1 GB

    Operating System

    (32-bit and

    64-bit

    )

    • Windows
    Vista SP2 or later
    • 10
    • Windows
    Server 2008 SP2
  • Windows Server 2008 R2
  • Windows 7
    • 11
    • Windows Server 2012
    Windows 8
    • Windows Server 2012 R2
    • Windows
    8.1
    • Server 2016
    • Windows
    10
    • Server 2019
    • Windows Server
    2016
    • 2022

    Port Access

    5166, 5167, 5169

    Client Browser

    Internet Explorer 7.0 or later
    • Microsoft Edge
    • Google Chrome
    • Mozilla Firefox
    • Safari 9+

    Production requirements

    Consider the following requirements when installing SQL Diagnostic Manager in an environment where the components are on separate computers.

    ...

    titlePermissions and Privileges

    ...

    SQL Diagnostic Manager Console

    Type

    Requirement

    Disk Space

    40 MB

    SQL Server Permissions

    Your Windows login account includes Read Access to the SQL Diagnostic Manager Repository. You can specify a SQL Server login instead

    .

    Software Framework

    Microsoft

    .

    NET 4.0 (Minimum)

    Microsoft .NET 4.6.2 (Recommended)

    Monitor Resolution

    1280 x 1024 with small text for the best viewing of the SQL Diagnostic Manager Dashboard

    SQL Diagnostic Manager Services

    Type

    Requirement

    Disk Space

    50 MB

    Collection Service Permissions

    System Administrator privileges on the monitored SQL Server instances

    For more information, review the User Creation Scripts.

    Management Service Permissions

    System Administration privileges on the

    Sysadmin fixed server role on SQL Diagnostic Manager Repository instance

    Software Framework
    Windows Runtime Components
    • Microsoft .NET 4.
    0 SP2
    • 8+ (
    Minimum)Microsoft .NET 4.6.2 (Recommended)
    • Required)
    • MDAC 2.8
    Note

    SQL Diagnostic Manager 11.0 installer checks for your current .NET framework version and prompts the required .NET update. After installing the latest version of .NET Framework you need to reboot your machine. Otherwise, SQLDM installation fails.

    SQL Diagnostic Manager Repository

    Tip

    SQL Diagnostic Manager 7.2 and later includes a repository autogrow setting at 32 MB, which is sufficient for trial and small environments in production. Environments with larger, multi-server installations should change the repository autogrow setting to 250 MB or higher to prevent frequent data file autogrow, which can cause performance problems. Using percentage-based autogrow is not recommended.

    Type

    Requirement

    Disk Space

    1GB to 3GB for one year of data per monitored SQL Server instance

    SQL Server

    SQL Server Standard or Enterprise/Datacenter Edition

    • SQL Server
    2005 SP1 or later
  • SQL Server 2008 or later
  • SQL Server 2008 R2
    • 2016

    Only on Windows and Linux:

    • SQL Server
    2012
    • 2017 
    • SQL Server
    2014
    • 2019
    • SQL Server
    2016
    • 2022 
    Info

    SQL

    Server 2017 (Windows & Linux)

    Diagnostic Manager monitors and supports older versions of SQL Server on a best-effort basis.

    Cloud Deployment
    • Azure IaaS VM Windows
    • Azure IaaS VM Linux 
    • Amazon AWS IaaS VM Windows
    • Amazon AWS IaaS Linux 
    Note

    SQL Diagnostic Manager supports any IaaS deployment if the version of SQL Server used is supported.

    Info
    Below, some additional information about SQL Diagnostic Manager Repository requirements:
  • Database file size at creation time: 100 MB with and a filegrowth of 32 MB
  • Log initial size: 5 MB and a filegrowth of 32 MB
  • Default database collation: SQL_Latin1_General_CP1_CS_AS

    Monitored SQL Server Instances

    Type

    Requirement

    SQL Server
  • SQL Server 2005 SP1 or later
  • SQL Server 2008 or later
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014

    SQL Server Express, Standard, or Enterprise/Datacenter Edition

    • SQL Server
    2000 SP4 or later
    • 2014
    • SQL Server 2016
    • SQL Azure
    • Amazon RDS

    Only on Windows and Linux

    • SQL Server 2017
    • SQL Server 2019 
    • SQL Server 2022
    Info

    SQL Diagnostic Manager monitors and supports older versions of SQL Server on a best-effort basis.

    Cloud Deployment
    • Azure DB
      • Single
      • Elastic Pool
      • Managed Instance
    • Amazon RDS SQL 
      • SQL Server 2016
      • SQL
    Express 2008
      • Server 2017
      • SQL Server 2019
      • SQL Server
    Express 2008 R2
      • 2022
    • Azure IaaS VM Windows (All SQL Versions)
    • Azure IaaS VM Linux
      • SQL Server
    Express 2012
      • 2017
      • SQL Server
    Express 2014
      • 2019
      • SQL Server
    Express 2016
  • Microsoft SQL Azure
  • Amazon RDS
  • SQL Server 2017 (Windows & Linux)
      • 2022
    • Amazon AWS IaaS VM Windows (All SQL Versions)
    • Amazon AWS IaaS VM Linux
      • SQL Server 2017
      • SQL Server 2019
      • SQL Server 2022
    Note

    SQL Diagnostic Manager supports any IaaS deployment if the version of SQL Server used is supported.

    Info
    titleAWSAzure SQL and Amazon RDS permissions

    Review the Minimum and Recommended Permissions for Amazon RDS and the Minimum and Recommended Permissions for Azure SQL To monitor an Amazon RDS instance using SQL Diagnostic Manager, you have to create a SQL Server user on the instance with the following permissions:

    Roles: public

    Other permissions (under the Securables tab in using SSMS): View server state, View any definition, View any database, and Connect SQL.

    Note

    No OS Collections supported on Linux under monitored versions.

    server to monitor a cloud instance.

    This topic provides the minimum requirements for installing SQL Diagnostic Manager. For more information about installation requirements, view SQL Diagnostic Manager Hardware Sizing guidelines.

    SQL Diagnostic Manager Management Pack and SCOM support requirements

    The IDERA SQL Diagnostic Manager Management Pack for integration with SCOM is designed for System Center Operations Manager 2007 R2 and above. For more information about SQL Diagnostic Manager MP and SCOM installation, see Install and configure the SQL Diagnostic Manager Management Pack for SCOM.



    Legal
    Scroll pdf ignore
    SQL 
    SQLDiagnostic Manager
    identifies and resolves SQL Server performance problems before they happen. Learn more > >
    for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
    Newtabfooter
    aliasIDERA
    urlhttp://www.idera.com
    Newtabfooter
    aliasProducts
    urlhttps://www.idera.com/productssolutions/sqlserver
    Newtabfooter
    aliasPurchase
    urlhttps://www.idera.com/buynow/onlinestore
    |
    Newtabfooter
    aliasSupport
    urlhttps://idera.secure.force.com/
    |
    Newtabfooter
    aliasCommunity
    urlhttp://community.idera.com
    |
    Newtabfooter
    aliasResources
    urlhttp://www.idera.com/resourcecentral
    |
    Newtabfooter
    aliasAbout Us
    urlhttp://www.idera.com/about/aboutus
    |
    Newtabfooter
    aliasLegal
    urlhttps://www.idera.com/legal/termsofuse
    IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources