Barrie Pike, head of business intelligence and portals at Conchango, explained that just because SQL Server appears to be running smoothly, it does not mean that it is working at optimum performance.
Conchango's Health Check takes a holistic view of the implementation to ensure that the minimum number of servers are employed and that they are tuned to suit their designated tasks. To do this, the company reviews the hardware, network, code, data models and database requirements to produce a report of short-term and long-term recommendations to improve the system.
Short-term solutions could include configuration changes and more efficient memory use, while long-term recommendations might include storage configuration, high availability or clustering.
"The starting point is to establish exactly what the customer wants to achieve with their technology," said Pike. "We can then ensure their SQL Server works as hard as possible to support their strategic goals."
Health Check also examines the number and types of databases being run and suggests ways in which the server count can be reduced.
During the beta phase of development, Conchango found one instance where changing a single CRM component resulted in customer searches that once took five seconds being completed in less than one second.