SQL Server Consolidation Enhances Performance

Problem: M Financial Group serves affluent individuals and Fortune 1000 companies through an exclusive network of independent financial services firms. Due to rapid expansion, M Financial's SQL server environment had grown to more than 60 databases on over 15 servers with a myriad of Excel spreadsheets and Access databases. Needless to say, the company was struggling to keep its databases up-to-date.

Solution: M Financial hired Marquam Group to review the health of their system and to make recommendations based on the growing needs of the company. The Marquam team first analyzed the usage of key database servers. Next, they created a monitoring system to track the performance of the databases along with procedures to maintain the servers. Marquam Group also developed a plan to consolidate M Financial's servers with recommendations to upgrade hardware for key systems. In addition to the immediate benefits in efficiency from the SQL server consolidation, the new systems also provided the company with improved security, enhanced reliability, and a scalable infrastructure. The results of properly sizing servers with database settings exponentially boosted performance boost - processing times in some cases were improved by over 200%!