- 0 minutes to read

About using Microsoft SQL Server with Nodinite

Unlock the full potential of Nodinite by choosing the right Microsoft SQL Server configuration. This page details supported versions, editions, prerequisites, and best practices to ensure optimal performance, security, and scalability for your monitoring and logging needs.

✅ Supports a wide range of SQL Server versions and editions
✅ Clear prerequisites for seamless installation and upgrades
✅ Best practices for security, performance, and backup
✅ Guidance for high availability, clustering, and cloud options

On this page, you will learn about some important prerequisites and options for installing and using Nodinite with Microsoft SQL Server.

SQL Server Versions and Editions

Nodinite supports a broad range of Microsoft SQL Server versions and editions, including Enterprise, Standard, and Express. Choose the edition that matches your business needs and expected data volume.

  • SQL Express is supported
  • SQL Server Managed Instance (Azure) is supported
    • Azure SQL Databases are currently NOT supported
SQL Server Version Always On support Cluster support Stand alone Nodinite Version
SQL Server Managed Instance (Azure) >=6.1
2022 ->6
2019 ->6
2017 ->6
2016 ->6
2014 ->6
2012 ->6
2008 R2 ->5.4

Developers can use the Developer edition for non-production environments.

If you require Logging Service, you will almost always need the Enterprise or Standard edition for sufficient capacity and features.

Enterprise Standard Express
Maximum Database Size 524 PB 524 PB 10 GB
CPUs/Cores OS Max 4 sockets or 24 cores 1 socket or 4 cores
Max Memory OS Max 128 GB 1.4 GB
SQL Profiler

SQL Server Always On

For high availability, Nodinite supports SQL Server Always On. Review the About SQL Server Always On Availability Groups guide for detailed configuration steps and recommendations.

SQL Express

SQL Express is supported but has limitations. It is generally not recommended for environments with Logging Service. If you use Nodinite only for documentation and Monitoring, SQL Server Express may suffice.

SQL Server Version Always On support Cluster support Stand alone Nodinite Version
2022 -> 6
2019 -> 6
2017 -> 6
2016 -> 6
2014 -> 6
2012 -> 6
2008 R2 ->5.4

Warning

The 10 GB limit for SQL Express makes it a poor choice for logging scenarios.

Tip

SQL Express 2019 and later can be upgraded to Standard edition, allowing you to start small and scale as your business grows.

Installation Path

If Nodinite is not installed on the same Windows Server as SQL Server, you can install SQL Server in any folder. For multi-server environments, review System Parameters and the SqlPackageExecutable user guide for configuration examples.

Collation

Nodinite requires a SQL Server instance with a collation of type CI_AS (Case Insensitive, Accents Sensitive). Choose a collation that matches your language, policy, and business requirements.

Learn more about SQL Server Collations in the official documentation.

Security

Security is critical for your SQL Server environment. Follow these best practices:

Account for SQL Server Instance

Run the SQL Server instance with an AD service account (not a local account) to ensure proper SPN registration in Active Directory. This is required for Kerberos authentication and secure delegation. See Trusted for delegation.

Kerberos

Kerberos is enforced by Windows and is essential for secure, multi-server environments. Ensure the following are properly configured:

Trusted for delegation

See the Trusted for delegation user guide for details.

SPN

When Nodinite uses a Linked Server, the SQL Server instance(s) must have its Service Principal Name (SPN) properly registered. See Account for SQL Server Instance for more information.

Linked Server

Review the Linked Servers section for configuration guidance.

DTC

See the Transactions MSDTC user guide.

Note

The type of DTC configuration varies with your SQL Server setup and organizational policies.

Performance optimizations

Maximize your Nodinite experience by following these performance tips:

  • Run Nodinite in dedicated SQL instances to guarantee resources and simplify troubleshooting
  • Keep the Logging Service close to the SQL Server hosting the Log Databases
  • Repeat these optimizations on ALL SQL Server instances (including BizTalk Server databases)
  • Use -T1118 Trace flag on SQL Instances (<2016) to optimize TEMPDB
  • Disable PAC Verification if your policy allows, to reduce RPC calls and improve performance
  • Install Nodinite on machines with dedicated swap volumes (>2.5x physical RAM) and SQL disks with >300 MB/s R/W
  • Ensure a secure backup volume or network share with enough free space for Nodinite databases
  • Windows Servers hosting Core Services should have at least 16GB RAM; high-volume environments may need more
  • Use Simple recovery mode for Log Databases with BizTalk Server to boost performance

TempDB optimization

  • For each core (up to 8), create 1 tempdb file of at least 128 MB (no auto growth)

    For example, with 14 cores, use 8 tempdb files. Placing tempdb files on different volumes can further improve performance.

Backups

Nodinite databases are critical for your monitoring and logging operations. Follow these best practices to ensure data integrity and availability:

  • DO NOT LOSE ANY DATA OR CONFIGURATION!

    Important

    Make sure to backup all your Nodinite databases, and make sure the documentation for the restore operation is available to the appropriate stakeholders