Hi there,
We have a system that is logging alarms for several sewage pumpstations. We recently had a problem with the HMI machine where the Microsoft SQL Server was running at close to 100%. I was unsure what SQL server was doing, so I disabled it in the services manager.
However, after doing this I found that I could not search the database for alarms (which makes sense). I then restarted the SQL Server, but once again found that it pushed the computer CPU close to 100%.
Is there any reason for this? How could this be fixed?
-andrew