Can I use Microsoft SQL Server with LinkFixer Advanced?

Can I use Microsoft SQL Server with LinkFixer Advanced?

Can I use Microsoft SQL Server with LinkFixer Advanced?

Modified on: Wed, 18 Mar, 2026 at 4:14 PM

Yes. LinkFixer Advanced supports Microsoft SQL Server, and its use is strongly recommended for improved performance—especially when working with large datasets.

Default Database vs. SQL Server

By default, LinkFixer Advanced uses SQLite, a file-based database included with the software.

SQLite
  1. Suitable for testing or smaller datasets (under ~250 GB)
  1. Simple setup with no additional configuration required
Microsoft SQL Server / SQL Express
  1. Recommended for large-scale processing
  1. Provides better performance and scalability

Performance Benefits

When using Microsoft SQL Server instead of SQLite:
  1. LinkFixer Advanced can utilize multi-threaded processing
  1. This enables faster scanning and processing of large volumes of files
  1. Overall project completion time is significantly reduced

Important Configuration Considerations

Database Growth Settings
By default, SQL Server expands the database size automatically as needed. However, during large scans, this can lead to excessive resource consumption.

Recommendations:
  1. Pre-allocate approximately 500 MB of database space per 100,000 files
  1. Configure database growth in 250 MB increments

Server Resource Recommendations

For optimal performance:
  1. At least 16 GB RAM
  1. Minimum of 4 CPU cores
Memory Management Tip:
  1. Limit SQL Server memory usage to 4 GB less than total system memory
  1. This ensures Windows retains enough memory to operate efficiently