SAN vs Tuning? - A SQL Server Audits Case Study

Increasing Disk Utilization

A high-end EMR system was experiencing throughput problems.

With over 2,000 concurrent users working against more than 130 GB of underlying data, disk utilization was saturated and users were beginning to complain about slow performance.

The Hardware Solution ($100,000)

An outside consultant recommended spending nearly $100,000 on a new SAN solution to help provide high-speed disk to help overcome issues with I/O contention.

The SQL Server Audits Solution ($2,000)

I was engaged to help with SAN migration.

But when I analyzed the existing workload and performance metrics I determined that new hardware wasn't needed.

Instead, by modifying key indexes and fill-factors, and modifying database file structure and placement, I was able to tune the EMR system to overcome disk contention without disrupting end-users.

The entire analysis and tuning process took less than 20 hours, and helped ensure future growth and performance - without requiring any additional hardware.

SQL Server Expertise

At SQL Server Audits, I can help save you money and help solve your complex SQL Server problems and concerns.

Contact me today to help put the power of SQL Server Audits to work for you.