Healthcare-related Company in South Africa Fixed Slow and Erratic SQL Server with SQL Doctor

I am the lead developer for an IT company that deals with the healthcare industry in South Africa. We develop a variety of software products, which cover a wide range of services. One of the products uses SQL Server, which services a large client base. Clients connect using web services and data is processed within SQL Server. This means that we require a responsive, dependable and serviceable base.

About a month ago we started having slow-downs on the server. It wasn’t anything that I could put my finger on as it was a random event. Usually it had already passed when it was noticed and I had been alerted.