Skip to main content

Hardware performance

The easiest method to gain performance is to add resources to the database server. Ensure you verify that the allocated resources are actually usable by the database service; for example, ensure the hypervisor is not sharing them with other VMs.

  • Free space is very important:

    • If there is no space to write changes, both the MSSQL database and our product will stop working.

    • The database needs at least 40% free space, because the tempdb can grow dramatically during auto discovery and other bulk updates/automation, the database files tend to get fragmented, and indexes on very large tables grow fast and can get fragmented as well.

    • Bravura Security Fabric will stop functioning when there's more than 90% space used (that's the Default, but is configurable: can be reduced for very large drives.

  • When the available RAM is exhausted, the Windows OS will proceed to swap to disk, which can make an instance grind to a halt.

Monitoring your servers health regularly is an important task that will identify if you need to add more physical resources. Conduct regular database maintenance and as your server nears its physical capacity, consider upgrading the hardware or adding more resources.