Hello,
We have a third party application which uses SQL 2012 server express and it does not perform.
Situation
Around 50 concurrent users login to remote desktop server and from start up the third party client. The client access the main third party software on the server which is using SQL Express 2012.
Issues
Database is sending data at 100Mb/s, but also very often in the evening when nobody is working with the application. Further application gets timeout messages and trying to search in the database from client takes up to 15 seconden to get result.
Hardware
HP DL360 gen9, 5x 1TB RAID, enough memory and CPU.
Is there anyone who can us help with this issue? We want to pay for good help.
Regards,
Peter
peter@trace-route.nl
via a Windows 2012 RDP login server and a Windows 2012 server with third party server software and SQL