Printing Labels Pegs Database Server At 100% Cpu S’abonner
We're on 10.1 SR1 Automation edition with 80 printers. The bartender components are installed on one server and the system database is located on our SQL Server 2012 instance. That SQL server has 4 CPUs and 24 GB of memory.
Since going to 10.1, we've noticed that everytime someone prints a label (we print via Commander), the CPUs on the database spike to 100% until the print job finishes. The normal baseline for the CPUs is around 10%. See the attached screen shot. We have confirmed the CPU spike comes from the SQL Server instance that hosts the Bartender system database. It also hosts about 50 other databases but the traffic is fairly light and when label printing is disabled, we don't see any CPU spikes. We didn't have this issue when we were on 9.3.
Any ideas? We're having some performance issues with our applications due to these spikes.
Vous devez vous connecter pour laisser un commentaire.