What are the Microsoft SQL Database requirements for LinkFixer Advanced?
Modified on: Wed, 18 Mar, 2026 at 5:01 PM
LinkFixer Advanced supports Microsoft SQL Server and requires specific database configurations to ensure optimal performance and stability.
Database Setup
- Create a dedicated SQL database specifically for LinkFixer Advanced
- LinkFixer Advanced will automatically create the required database schema upon first connection
Database Growth Configuration
By default, SQL Server grows databases dynamically (“organically”). However, during large scan operations, this can lead to excessive resource usage.
Recommendations:
- Pre-allocate at least 1 GB of database space
- Log file size: ≥500 MB
- Configure database growth in 500 MB increments
Server Resource Requirements
For optimal performance:
CPU: 8 cores minimum (16 cores recommended for ≥5 TB datasets)
Memory: 16 GB minimum (32 GB recommended for ≥10 TB datasets)
Memory Management Tip:
- Limit SQL Server instance memory to 8–16 GB, depending on system capacity
Limit SQL Server memory usage to 50% of total system RAM
Warning:
Setting memory too high can cause resource contention
Setting it too low may prevent SQL Server from starting or degrade performance
Permissions and Access
- LinkFixer Advanced requires a dedicated database
- The application (or user running it) must have db_owner permissions
Schema Requirements
- LinkFixer Advanced is not designed to work within a shared database schema
- It uses the default schema (dbo)
- It does not support named or custom schemas within a shared database
There should be no conflicts with other databases, as LinkFixer Advanced operates within its own dedicated schema.
Additional Reference
For more information about SQL Server default schemas, refer to Microsoft documentation on the Default Schema concept.