SQL Server Case Study |
SQL Server performance tuning for leader in digital communications technology for mobile workforces.This services company has developed and hosts (amongst many other innovations) an application that enables forms data on mobile devices to be transmitted and stored on a central server over standard GPRS communications. Performance of the system is critical particularly as there are a large number of clients using the service in the field. The system has seen enormous growth over the last few years and the sheer volumes of data are causing the system to hit occasional performance problems. There was a suspicion that that the database server may be at least part of the problem. Ballard Chalmers were assigned the task of investigating the SQL Server with the objective of improving overall performance. The configuration of the server, capacity of the hardware and network bandwidth was assessed. An examination of the database tables and usage of clustered and non clustered indexes was evaluated. An analysis of recovery model was carried out as was an analysis of the query plans, and blocking locks for the critical queries. Recommendations and configuration changes were made to ensure the system was operating at 100% optimum and to minimise the risk of future database performance problems recurring. Related links
 |