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.
We track and analyse over 100 SQL Server and Operating Systems performance counters to identify any potential infrastructure based bottlenecks.
Disks, network, CPU, memory and operating system settings which can impact on how SQL Server interacts with its host environment.
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.
Identify high value missing indexes, duplicate or unused indexes which create performance overheads and other DB internal misconfigurations.
Receive a detailed report akin to a Microsoft SQL RAP, containing all findings and recommendations.
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.
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.
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.
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.
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.
Highly recommended for SQL consulting and support services for enterprise or smaller scale solutions.
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.
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.
Don’t spend thousands on a Microsoft SQL RAP (Risk and Health Assessment Program)
before speaking with one of our specialist SQL Server DBAs!
Contact DBA Services
We typically respond within minutes.
Professional SQL Server Database Administration Services, because we believe every business deserves to have a specialist DBA.
QAssure # 16602. GITC #Q-6452
2/67 Dennis Rd,
PO Box 1208,
QLD Australia 4006