Comprehensive Database Performance Health Check
Comprehensive Database Performance Health Check is my the MOST popular service. Customer opts for this service when they face performance issues with SQL Server. Based on the complexity of your system, it can take anywhere from 2 to 4 hours to complete this entire exercise.
During this exercise, we identify your performance problem and chalk out an action plan to resolve them. Most of the time within the first 90 minutes, we will get to the part where we start implementing fixes for performance issues.
When do you need this?
It is recommended that you opt for this offering if you are facing any of the following symptoms with your server.
- The application runs slower
- Long running queries
- High CPU consumption
- Inefficient memory consumption
- Suddenly and abruptly getting slower queries
- Lots of deadlocks
- Frequent timeouts
- Database log file growing continuously
- Database backup slow or failing
- Out of date index maintenance
During this engagement, we will work together and do a comprehensive health check of your system and find appropriate solutions.
What is included in the service?
I explain every single setting of your system in detail to you and your team with guidance on what should be the ideal settings for the same. I also will give you All the Scripts which I use for analysis your system’s performance with necessary explanation.
Once we are done with the performance tuning analysis, you will know where exactly you have performance bottleneck and its potential solution.
Here is a brief list of activities which we will do for performance health check:
- Index Analysis
- Index Optimization
- Index Maintenance
- Server/Instance Level Configuration Check
- I/O distribution Analysis
- SQL Server Resource Wait Stats Analysis
- TempDB Review
- Database Files (MDF, NDF) and Log File Inspection
- Log Reviews (Windows Event Logs, SQL Server Error Logs and Agent Logs)
- DBCC Best Practices Implementations
I do not need any username or password or any other information about your system.
We will work via GoToMeeting where you will be always in control of your system. Every single change we do or anything we need to deploy to improve performance of your system, I will guide you how exactly do so. It is your server and you will be always in control of the same. You need to know what are the changes we are doing and how to undo each of them.
From over 400 different customers, I have developed a unique methodology where I can help you learn performance tuning concepts without taking control of your system.
Does the user get ALL the scripts used during the engagement?
You will receive every single script which we will run during the engagement.
The matter of fact, I will not take control of your system at all. I will send you all the scripts which you will execute while both of us are sharing the screen during GoToMeeting sessions. Based on the outcome, I will teach you what exactly to do to fix the diagnosed performance issue.
When I teach my customers how to do any performance tuning tasks, rather than I do it myself, I have observed maximum return on investment from everyone.
How long does it take to complete it?
Maximum of 4 hours.
The entire Comprehensive Database Performance Health Check takes around a maximum of 4 hours. Before you ask me, how can we improve performance multifold in such a short time, the answer is very simple – I have worked with over 400 of different customers on performance tuning issue and I have seen all sorts of things. I have solutions ready with me for the 99% of the performance problems out in the world.
There have been instances when everybody believed SQL Server is the root cause of the slowness, but the real culprit was totally different (e.g. Corrupted disk, memory issues with Virtual Machine, etc.). In any case, we will figure out how healthy your SQL Server is during this exercise.
The best part is that most of the changes which we will discuss does not need any downtime or restart of the server. You can easily do this during your business hours without impacting your users.
Trust me – you want me to resolve your performance issues in the shortest period of the time, so you can do other things, which are more important to you.
What is the cost involved?
USD 2100 USD 1600 (for July/August 2017).
Yes, the price is fixed rate price for the entire exercise and we will accomplish everything listed in the section ‘What is included in the service?‘.
What is the guarantee of this service?
When we fall sick, we go to doctors. We expect doctors to diagnose illness and suggest us the course of action to recover ourself. As a cure doctors usually prescribe medicines, give us diet plan and suggest us a course of action to prevent our illness in the future.
Well, this is exactly the same service with databases. The slowness of your application can be either due to SQL Server or due to external reasons. We will figure out the root cause of the slowness. We will together identify the root cause of the performance problems.
If your problem is related to SQL Server we will do any of the following:
- Implement the configuration changes for SQL Server Databases
- Identify the performance bottlenecks
- Build a list of queries with areas of improvements
- Craft a solid action plan for the future to avoid server slowness
- Learn how to use various performance tuning scripts
- Follow up email support for the next 28 days
I guarantee you that we will do our best efforts to fix your performance issues while we are on the call.
I promise you that before the session ends, you will have clear action plans to keep your database at the optimum speed in the future.
How to get started?
There are three steps to get started
Step 1: Send me email at email@example.com with following information:
- Brief Problem Statement:
- SQL Server Version(s):
- Name of the Company:
- Country Located: (this helps to determine time zone)
Step 2: I will reply with following two information:
- Earliest Available Calendar:
- Payment Link (Credit Card, Debit Card, Bank Transfer and PayPal):
Once we agree on a meeting time and payment is received, we move to Step 3
Step 3: I send you GotoMeeting invite which you can share with your team
That’s it. We are ready to meet.