SQL Server Health Checks

Identify Mis-configurations and Problem Conditions before the Impact your Business.

Misconfigured SQL servers can have a significant impact on the performance, reliability, availability and recoverability of your business’ core database infrastructure. Given the high cost of SQL Server licensing, it’s always impressed us to find how many businesses fail to properly configure SQL Server to maximise the return on their investment!

Our SQL Server Health Check service conducts a detailed review of your SQL Server infrastructure, akin to a Microsoft SQL RAP (although we’d argue ours is even more detailed), which looks at everything from the hardware layer including disks, CPU, memory and network, up through the OS configuration and into SQL Server itself and even into specific problem databases.

For clients who have elected to perform our SQL Health check as part of our Managed SQL Server on boarding process, we’ll also incorporate remediation activities as part of our health check.

48 hours Performance Baseline Analysis

Review of Storage, Network, CPU and Memory Configurations

Detailed assessment of SQL Server Instance components including services configuration, maintenance plans, failure notifications and SQL operators, high availability configurations and more!

Critical business database reviews for misconfigurations including identification of any high value missing indexes, duplicate indexing, heap tables and much more.

Performance Baseline

We track and analyse over 100 SQL Server and Operating Systems performance counters to identify any potential infrastructure based bottlenecks.

Operating System

Disks, network, CPU, memory and operating system settings which can impact on how SQL Server interacts with its host environment.

SQL Components

Review of multiple instance configurations and environments which host multiple components such as SSRS, SSAS.

SQL Instance Configuration

Deep dive assessment of SQL Server’s instance components including core SQL build elements to ensure the installation has been comprehensively installed and configured.

Critical Databases

Identify high value missing indexes, duplicate or unused indexes which create performance overheads and other DB internal misconfigurations.

Recommendations

Receive a detailed report akin to a Microsoft SQL RAP, containing all findings and recommendations.

When Was Your Last SQL Server Health Check?

OUR SQL SERVER HEALTH CHECKS IDENTIFY CRITICAL MIS-CONFIGURATIONS IN OVER 97% OF ALL REVIEWS COMPLETED. IS YOUR BUSINESS AT RISK?

Call Now! 1800 SQL DBA

Why Clients Work With Us

DBA Services have saved the day for us many times over. The service we have received from them has been first class - nothing is a problem for them, and they have proved time and time again that they have a deep understanding of DBs. Highly recommended!

- William Buchanan

I would regard DBA services as a superior provider of Database services. They demonstrate exceptional professionalism and are truly focused on your business outcome. They are a sensational team. DBA Services P/L continues to be an excellent service provider with superb problem solving and solution creation talent.

Steve Anable

DBA Services was selected to provided GMH Systems Pty Ltd with SQL consulting services. The initial brief was to review and make recommendations on our SQL Server infrastructure and assist in achieving best industry practice in this area. To date Sia Shamsia our DBA Services consultant has proven to very knowledgeable and professional providing outstanding service and assistance. We have now extended our brief to include security and ongoing maintenance services across all our servers. We would not hesitate to recommend DBA Services to any company large or small that requires professional services delivered to the highest quality.

Graeme Andrew

Excellent enterprise-grade database services. I would not look anywhere else for in-depth SQL consulting, replication, high availability or troubleshooting services. DBA Services assisted with improving the database performance and resilience for a major ERP project of ours. Highly recommended.

David Levi

DBA Services do what they say they will: they look after your SQL databases. They do it in an unfussy way. They are bold enough to be decisive but respectful enough to consult you as needs must. They are a key component of our IT strategy. The first official workday of the year is the perfect day to write this email because I have enjoyed an unworried Xmas because I knew we were in safe hands.

Peter Moore

In my previous role at QSuper, Sia Shamsai provide DBA services in support of a major 24x7 business application. Over the 4+ years that we worked together I received excellent service. He was particularly knowledgeable in monitoring, maintenance and diagnostic work. As demand for the system grew, Sia helped to scale the DB infrastructure to provide best performance. I would strongly recommend Sia to anyone seeking someone with excellent DBA skills, up to and including enterprise-level infrastructure.

Russel Dickenson

Highly recommended for SQL consulting and support services for enterprise or smaller scale solutions.

Jonathan Burke

I have worked closely with Sia on numerous SQL projects over the years and have not found anyone that could surpass his knowledge and creativeness with SQL.

Alison Woolfrey

DBA Services have provided exceptional service on short notice during critical client disaster scenarios. Their in-depth knowledge of MSSQL performance tuning and HA design kept services running while providing recommendations for short and long term infrastructure improvements. I highly recommend them.