This engagement is typically best conducted over a period of two weeks, depending on the size and scope of your specific environment. Artifacts from this engagement include high level findings and recommendations. These findings reference a variety of scripts and output: analysis of Performance Monitor, SQL Profiler and detailed DMV findings.
TopSchool, Inc. provides solutions offering Student Lifecycle Management. TopSchool engaged us for an analysis of their environment. Due to tremendous growth they wanted to ensure their existing SQL Server 2005 database environment would be able to scale and perform at optimal levels. The engagement tasked us with discovering any issues in the environment, documenting those issues, providing recommendations and a path to remediate the problem areas.
The engagement resulted in:
Performance has increased dramatically and the databases at TopSchool are able to scale and perform beyond their original design, allowing for additional significant growth.
TopSchool benefited from our engagement with Jeremy Lowell of Data Realized in many ways. We appreciated Jeremy’s deep expertise in Microsoft SQL Server and his ability to come up to speed on our environment quickly. Working closely with our team, his insight and recommendations were invaluable and helped us produce outstanding results—in infrastructure, performance, and strategy.
- Jeff Olin, Vice President, Software Engineering at TopSchool