Why does Navireo slow down? Five things we check first
Slow document lists and frozen windows rarely have a single cause. Here’s the order in which we diagnose them.
The complaint usually sounds the same: “it was fine this morning, and now the document list takes a minute to open.” Before anyone suggests a new server, it’s worth checking a few things in order.
1. Database locks
If the slowdown appears when many people work at once, locks are the first suspect. One user’s long transaction can stop everyone else. We check who is blocking whom and which query is behind it.
2. Missing indexes
Document tables grow every year. A query that was fast with a few thousand rows starts scanning the whole table at a few hundred thousand. SQL Server suggests missing indexes, but not every suggestion is worth implementing.
3. Server memory and disk
- does SQL Server have a memory limit that leaves room for the OS,
- are data and log files on fast storage,
- does the backup run outside working hours.
4. Extensions and integrations
Custom Sfera add-ons and sync services can load the database more than users do. Check how often they run and whether they keep transactions open.
5. The network
Last, but not always least: the network. A damaged cable or an overloaded switch produces symptoms very similar to a slow database. That’s why we also measure response times from the workstation.
The most expensive fix – a new server – is rarely the first one you need.
If this sounds familiar, get in touch. We’ll start by measuring.