Versions Compared

Old Version 1

changes.mady.by.user user-eb51a

Saved on

compared with

New Version 2

changes.mady.by.user user-eb51a

Saved on

Key

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

The following guidelines estimate the hardware resources required to deploy SQL Diagnostic Manager depending on the number of servers you want to monitor with SQLDM.

Installs under 20 servers

Single-server deployment - Includes the SQL Diagnostic Manager Services and the SQL Server hosting the SQLdm Repository (clustered for redundancy).

TypeRequirement
Operating System

You can easily and quickly install IDERA SQL Secure on any computer that meets or exceeds the following hardware, software, and permission requirements. Before installing SQL Secure, also review the product components and architecture as well as how the product works.

Typical requirements

A typical install sets up all SQL Secure components on the same computer. The following table lists the requirements for a typical installation.

Hardware/softwareRequirementCPU2.0 GHz or higherMemory2 GB64-bit Operating System
  • Windows 11
    • Windows 10

    Windows Server 2012

    Windows Server 2012 R2

    Windows Server 2016

    Windows Server 2019

    Windows Server 2022

    Plus:

    • .Net framework 4.8
    • MDAC 2.8 or later
    Microsoft SQL Server for Repository

    Supports all editions except SQL Server Express for the following versions:

    • SQL Server 2012 
    • SQL Server 2014
    • SQL Server 2016
    • SQL Server 2017 (Windows)
    • SQL Server 2019 (Windows)
    • SQL Server 2022
    • SQL Server on Azure VM
    • SQL Server on Amazon EC2
    Microsoft SQL Server for audited instances
    • SQL Server 2012 SP1
    • SQL Server 2014
    • SQL Server 2016
    • SQL Server 2017 (Windows)
    • SQL Server 2019 (Windows)
    • SQL Server 2022
    • Azure SQL Database
    • SQL Server on Azure VM
    • Azure SQL Database
    • SQL Server on Amazon EC2
    • Amazon RDS for SQL Server

    Browser for online Help

    • Internet Explorer 11.x+
    • Microsoft Edge
    • Google Chrome
    • Mozilla Firefox

    • Safari

      Info

      Current versions plus three previous versions of these browsers support SQL Secure.

    Note

    Latest SQL Secure version no longer supports SQL Server 2000, SQL Server 2005 and SQL Server 2008R2 install Secure on a SQL instance with a different collation.

    Console requirements

    A console-only installation installs the SQL Secure Console. The console-only installation assumes that a full installation has already been completed on another machine. The following table lists all the requirements for a console-only installation.

    Windows 10

    Windows 11

    Memory8 GB
    CPU6 Core
    SQLdm Repository sizeApproximately 50GB
    SQL Server versionSQL Server 2008 R2 standard edition or higher
    Info
    The expected repository growth is approximately 1.5-3 GB per monitored instance for a year worth of collected data. Monitoring 15 instances could gather approximately 45 GB over the course of a year.

    Installs 20-50 servers

    Single-server deployment - Includes the SQL Diagnostic Manager Services and the SQL Server hosting the SQLdm Repository (virtualized/clustered for redundancy).

    TypeRequirement
    Operating System

    Windows Server 2012

    Windows Server 2012 R2

    Windows Server 2016

    Windows Server 2019

    Windows Server 2022

    Windows 10

    Windows 11

    Memory16 GB
    CPU6 Core
    SQLdm Repository sizeApproximately 150GB
    SQL Server versionSQL Server 2008 R2 standard edition or higher
    Info
    The expected repository growth is approximately 1.5-3 GB per monitored instance for a year worth of collected data. Monitoring 30 instances could gather approximately 90 GB over the course of a year.

    Installs 51-200 servers

    Dual-server deployment - The first server hosts the SQL Diagnostic Manager Services and the second server hosts the SQL Server and the SQLdm Repository database.

    • Machine 1 - Hosting the SQL Diagnostic Manager services (virtualized/clustered for redundancy)
    TypeRequirement
    Operating System

    Windows Server 2012

    Windows Server 2012 R2

    Windows Server 2016

    Windows Server 2019

    Windows Server 2022

    Windows 10

    Windows 11

    Memory8-16 GB
    CPU6 Core
    • Machine 2 - Hosting the SQL Server and the SQLdm Repository (clustered for redundancy)
    TypeRequirement
    Operating System

    Windows Server 2012

    Windows Server 2012 R2

    Windows Server 2016

    Windows Server 2019

    Windows Server 2022

    Windows 10

    Windows 11

    Memory16 GB
    CPU6 Core
    SQLdm Repository size200-600GB
    SQL Server versionSQL Server 2008R2 standard edition or higher

    Installs 201-300 servers

    Dual-server deployment - The first server hosts the SQL Diagnostic Manager Services and the second server hosts the SQL Server and the SQLdm Repository database.

    • Machine 1 - Hosting the SQL Diagnostic Manager services (virtualized/clustered for redundancy)
    TypeRequirement
    Operating System

    Windows Server 2012

    Windows Server 2012 R2

    Windows Server 2016

    Windows Server 2019

    Windows Server 2022

    Windows 10

    Windows 11

    Memory16 GB
    CPU8 Core
    • Machine 2 - Hosting the SQL Server and the SQLdm Repository (clustered for redundancy)
    TypeRequirement
    Operating System

    Windows

    Hardware/softwareRequirementCPU2.0 GHz or higherMemory2 GB32-bit or 64-bit Operating System
  • Windows 11
  • Windows 10
    • Windows

    Server 2012

    Windows Server 2012 R2

    Windows Server 2016

    Windows Server 2019

    Windows Server 2022

    Plus:

    • .Net framework 4.8
    • MDAC 2.8 or later
    Browser for online HelpInternet Explorer 9.0 or later

    SQL Server Versions and Editions

    SQL Secure runs on various Cloud Virtual Machines running Microsoft Windows Server and Microsoft SQL Server.

    SQL Secure monitors different SQL Server versions installed on-premise or on cloud platforms.

    ...

    Microsoft Azure VM (IaaS)

    ...

    Amazon EC2 (IaaS)

    ...

    Microsoft Azure SQL Database (PaaS)

    ...

    Collector permission requirements

    The following requirements are necessary for the SQL Secure Collector to access the SQL Server instances you want to audit. During install, you can input credentials for a Windows user account or SQL Server login.

    ...

    Windows 10

    Windows 11

    Memory32 GB
    CPU

    8 Core

    SQLdm Repository size600 GB or more
    SQL Server versionSQL Server 2008R2 standard edition or higher

    Installs over 300 servers 

    Dual-server deployment - The first server hosts the SQL Diagnostic Manager Services and the second server hosts the SQL Server and the SQLdm Repository database.

    • Machine 1 - Hosting the SQL Diagnostic Manager services (virtualized/clustered for redundancy) 
    TypeRequirement
    Operating System

    Windows Server 2012

    Windows Server 2012 R2

    Windows Server 2016

    Windows Server 2019

    Windows Server 2022

    Windows 10

    Windows 11

    Memory32 GB
    CPU

    8 Core

    • Machine 2- Hosting the SQL Server and the SQLdm Repository (virtualized/clustered for redundancy)
    TypeRequirement
    Operating System

    Windows Server 2012

    Windows Server 2012 R2

    Windows Server 2016

    Windows Server 2019

    Windows Server 2022

    Windows 10

    Windows 11

    Memory32 GB
    CPU

    8 Core

    SQLdm Repository size900 GB or more
    SQL Server versionSQL Server 2008R2 standard/enterprise edition

    Sample installations in large environments

    See the following sample customer installations for users with large environments:

    Installs 51-100 servers

    TypeIn-House Use

    Number of monitored servers

    		52

    Services and Repository installed on same machine

    		Hyper-V
    • 4 quad core processors
    • 14 GB of memory
    • Windows Server 2008 R2 Enterprise

    Data storage and grooming options

    • Repository size: 120 GB
    • Retain 60 days of history
    Monitoring features

    Monitor Windows and SQL Server performance and error log monitoring

      

    Type

    In-House Use

    Number of monitored servers

    90

    Services machine

    • 2 vCPU
    • 8 GB of memory
    • Windows Server 2008 R2 Enterprise

    Services machine

    • 2 vCPU
    • 8 GB of memory
    • Windows 2008 R2 Enterprise
    • Repository: SQL Server 2008 R2

    Data storage and grooming options

    • Repository size: 100 GB
    • Retain 60 days of history

    Monitoring features

    Monitor Windows and SQL Server performance

    Installs 201- 300 servers

    Type

    In-House Use

    Number of monitored servers

    234

    Services and Repository installed on same machine

    • Dell 2950
    • 2 quad core processors
    • 16 GB of memory
    • Windows Server 2003

    Data storage and grooming options

    • Repository size: 140 GB
    • Retain 30 days of history

    Monitoring features

    Monitor Windows and SQL Server performance and use Query Waits for specific periods of diagnostics

    Integrations

    Send alerts to HP Open View via a command line program (opcmsg)

    Type

    In-House Use

    Number of monitored servers

    274

    Services and Repository installed on same machine

    • 4 quad core processors
    • 128 GB of memory
    • Windows Server 2008 R2

    Data storage and grooming options

    • Repository size: 1.5 TB
    • Retain 365 days of history

    Monitoring features

    Monitor Windows and SQL Server performance

    Port requirements

    SQL Secure uses the default ports opened by the Windows operating system for local and remote communications. To learn about Windows port assignments, see

    Newtab2
    aliasArticle 832017
    urlhttp://support.microsoft.com/kb/832017/
    on the Microsoft Support site. To better understand how port assignments work when Windows Firewall has been configured, see
    Newtab2
    alias"Connecting through Windows Firewall"
    urlhttp://msdn.microsoft.com/en-us/library/aa389286%28VS.85%29.aspx
    on the MSDN site.

    TypeRequirementSQL Server Object Permissions and configuration collectionPort 1433 (or the configured SQL instance port for the audited instance)Windows file system and registry permissions collectionPort 135 (RPC connectivity)



    Scroll pdf ignore
    Excerpt
    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

    ...