The client runs Microsoft Dynamics 365 CRM and ERP databases on a Back Office SQL Server environment, alongside other production SQL Server systems with disaster recovery replication in place.

Business Challenges

Running Dynamics 365 CRM and ERP on SQL Server day to day surfaces a steady stream of maintenance, patching, and performance work that has to be handled without disrupting live operations.

Storage and log growth on core systems

Data files on D365CRMIDB and D365ERPIDB, and transaction logs across production servers, needed regular shrinking wherever utilization crossed the defined threshold.

Patching risk on production SQL Server

Applying cumulative updates and security patches without structured pre-checks and post-checks risked destabilizing live systems.

Limited real-time visibility into operational risk

Long-running queries, blocking sessions, job failures, unauthorized login creation, DR synchronization lag, missing backups, and TempDB growth all needed continuous tracking rather than after-the-fact discovery.

Security and high-availability gaps

The environment needed a documented security and backup strategy, including Always On Availability Group configuration and failover support.

Query performance drift

Missing statistics and indexes affected query performance across the environment.

Project Objectives

Geopits was engaged to provide ongoing managed database support for Geojit's Microsoft SQL Server environment, covering Dynamics 365 CRM and ERP databases and other production systems, with a focus on stability, security, and performance.

Key Goals:

Keep database and log file growth under control through regular maintenance
Maintain patch currency with structured pre-checks and post-checks and clear CU recommendations
Provide continuous monitoring and rapid response across critical database alerts
Strengthen security, backup, and high-availability posture through Always On AG configuration
Improve query performance through targeted indexing and statistics maintenance

Solution Provided by Geopits

Geopits runs this as a continuous managed service across storage maintenance, patch support, monitoring, security, and performance tuning.

Data File Maintenance

Performed data file shrinking for D365CRMIDB and D365ERPIDB on the Back Office server.

Log File Maintenance

Performed log file shrinking for production servers where log file utilization exceeded the defined threshold.

Patch Management Support

Conducted pre-checks and post-checks for SQL Server patching activities and shared security and CU update recommendations with the client.

Continuous Monitoring

Continuously monitored long-running queries, blocking sessions, job failures, new login creation alerts, DR server synchronization lag, missing backups, TempDB growth, and other critical database alerts.

Key outcomes

Dynamics 365 databases kept lean

Regular data file shrinking on D365CRMIDB and D365ERPIDB, and log file shrinking wherever utilization crosses the defined threshold, keeps storage growth under control on the Back Office server and other production systems.

Patch cycles validated end to end

Pre-checks and post-checks around every SQL Server patching activity, paired with security and cumulative update recommendations shared with the client.

Round-the-clock alerting coverage

Continuous monitoring spans long-running queries, blocking sessions, job failures, new login creation, DR synchronization lag, missing backups, and TempDB growth.

Always On AG in place for failover

Security analysis and backup strategy work, including Always On Availability Group configuration, gives the environment failover support.

Query performance actively tuned

Missing statistics and indexes are identified and addressed on an ongoing basis to keep query performance on track.

Conclusion

Geopits provides ongoing managed database support for Geojit's Microsoft SQL Server environment, covering Dynamics 365 CRM and ERP databases and other production systems. The engagement spans storage and log maintenance, patch validation, continuous monitoring, security and high-availability configuration, and query optimization, keeping the environment stable, secure, and performant on a day-to-day basis.

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.