Geopits helped Practice Build, a Canada-based healthcare technology company, transform its Microsoft SQL Server environment by reducing report execution time from 2 hours to just 3 minutes. Through targeted query optimization, execution plan tuning, and intelligent indexing strategies, the engagement reduced SQL Server logical reads by up to 98%, improved application responsiveness, and enabled faster reporting across a 600 GB production database—all within a one-month engagement.‍

Industry

Healthcare Technology

Tech Used

Microsoft SQL Server on AWS EC2

About

Practice Build

Practice Build is a Canada-based healthcare technology company that delivers digital solutions supporting patient engagement, billing, financial reporting, and practice management.

Its Microsoft SQL Server environment hosted approximately 600 GB of production data supporting high-volume reporting and transaction processing. As data volumes and reporting demands increased, the database environment experienced growing performance challenges that affected report generation and application responsiveness.

To improve performance without changing the existing application, Practice Build partnered with Geopits to optimize its SQL Server environment and eliminate database bottlenecks.

Business Challenges

As reporting requirements and transactional workloads increased, the existing SQL Server environment began impacting business operations.

Slow Business Reporting

Business-critical reports processing large volumes of healthcare and financial data required up to 2 hours to complete, delaying access to operational and management information.

High Database I/O

Several reporting and transactional workloads generated excessive logical reads, resulting in inefficient query execution and increased SQL Server resource utilization.

Performance Bottlenecks

Growing data volumes across multiple production tables led to inefficient indexing and execution plans, reducing application responsiveness during peak reporting periods.

Limited Scalability

The existing database environment required optimization to efficiently support increasing workloads and future business growth.

Project Objectives

Geopits was engaged to improve SQL Server performance while ensuring uninterrupted production operations.

Key Goals:

Reduce report execution time
Improve SQL query performance
Optimize indexing strategies
Reduce database logical reads
Improve SQL Server resource utilization
Build a scalable database platform for future growth

Solution Provided by Geopits

Geopits conducted a comprehensive SQL Server performance assessment before implementing targeted optimizations across the production environment.

Database Performance Assessment

The engagement began with a detailed analysis of execution plans, query performance, indexing strategies, SQL Server STATISTICS IO output, and high-impact reporting workloads to identify the primary causes of excessive database I/O and performance degradation.

Query & Index Optimization

Geopits optimized nine business-critical reporting and transaction workloads by redesigning query execution strategies and implementing carefully designed covering nonclustered indexes. These improvements significantly reduced logical reads while improving query efficiency across large production datasets.

Performance Validation

Each optimization was benchmarked using SQL Server STATISTICS IO before deployment. Before-and-after logical read comparisons validated measurable performance improvements while ensuring application functionality remained unchanged.

Results & Business Impact

Geopits transformed Practice Build's SQL Server environment into a high-performing database platform capable of supporting large-scale reporting and transactional workloads more efficiently.

Capabilities

Before

After

Report Query Optimization

Business-critical reports took 2 hours to complete

Reports completed in 3 minutes

Query & Data Access Optimization

High logical reads increased SQL Server I/O

Logical reads reduced by up to 98%

Workload Performance Optimization

Large reporting workloads impacted application responsiveness

Faster reporting with significantly lower database I/O

Large-Scale Database Optimization

Database performance degraded as data volumes increased

Optimized reporting across a 600 GB production database

Advanced Indexing & Scalability Optimization

Existing indexing limited scalability

Optimized indexing strategy supporting future growth

Key outcomes

40× Faster Business Reporting

Business-critical reports that previously required 2 hours to generate are now completed in approximately 3 minutes, enabling faster operational and management decision-making.

Up to 98% Reduction in Database I/O

Through targeted query optimization and intelligent covering index design, Geopits reduced SQL Server logical reads by up to 98%, significantly improving overall database efficiency across reporting and transaction-processing workloads.

Improved Application Responsiveness

Optimized query execution and lower database I/O improved application responsiveness for reporting, billing, and operational workflows while minimizing resource contention.

Scalable SQL Server Environment

The optimized SQL Server platform now supports growing business workloads more efficiently, providing a stronger foundation for future expansion and continued performance.

Conclusion

Geopits helped Practice Build, a Canada-based healthcare technology company, transform its Microsoft SQL Server environment through targeted performance optimization and intelligent indexing strategies. Within a one-month engagement, Geopits reduced report execution time from 2 hours to just 3 minutes, lowered SQL Server logical reads by up to 98%, and optimized reporting across a 600 GB production database. The result was a faster, more responsive, and scalable SQL Server environment capable of supporting growing business demands.

Ready to Transform Your Data?

Geopits works alongside your team as a strategic partner, starting with stabilizing your current databases, then modernizing your data infrastructure, and ultimately helping you unlock the full potential of AI.

Book a Demo Learn More

170

Happy Clients so far

2100+

Databases Managed

142+

Successful Migrations

At Geopits, our mission is to empower businesses to achieve reliable, secure and high-performing database environments and to derive meaningful business insights.