SQL SERVER – 10 Questions Where YES May Be a Wrong Answer – Performance Health Check

SQL SERVER - 10 Questions Where YES May Be a Wrong Answer - Performance Health Check 10Questions Today’s blog post created from a recent conversation with one of my customers. They asked me a very interesting question – “When should they hire me for my famous Comprehensive Database Performance Health Check?“. I send them following 10 questions and told them to take a quick quiz about their SQL Server Environment. They replied back to with YES to all the answers. If the answer to any of the following questions in YES, that means user can for sure improve their SQL Server’s Performance. After taking this quick test, my customer realized that they have amazing potential to improve the performance of their server.

Now here I encourage you to take this test and honestly post your score in the comments section or just send me an email at pinal@sqlauthority.com

10 Quiz Questions

Please Answer in Yes/No. If you do not understand the question, just mark that as a Yes!

Q1) Does your server occasionally slow down and root cause is unknown?

Q2) Do you have more than 10 indexes on any of your tables?

Q3) Is the fill factor of your server is set to 0 or 100?

Q4) Do you shrink your database regularly with maintenance jobs?

Q5) Does your log file keep growing bigger every day and root cause is unknown?

Q6) Does your index rebuilding process take longer duration every single day?

Q7) Does your customer have to wait over 5 seconds for your application screen to load?

Q8) Is your application running slow after SQL Server upgrade?

Q9) Do you know the optimal value of filegrowth for your system?

Q10) Do you still have a single MDF (data) file for your TempDB?

Here is the result:

If you get 7 or more YES in the 10 questions above, you can for sure get instant benefit from Comprehensive Database Performance Health Check.

If you score 10 YES, you must arrange a training for your organization where we will discuss along with your server’s health also following concepts:

  • Optimal Server Settings for Maximum Performance
  • Optimal Database Settings for Maximum Performance
  • Index Strategies and Maintenance Guidance
  • Basic Algorithm to Quickly Identify Performance Bottlenecks
  • Optimization Scripts which I use for My Customers

The entire Comprehensive Database Performance Health Check takes a maximum of 4 hours. Before you ask me, how can we improve performance multifold in such a short time, well, the answer is very simple – I have worked with over 300 of different customers on performance tuning issue and I believe I have seen all sorts of things and have solutions ready with me. 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.

Send me an email pinal@sqlauthority.com and let us talk – How can I help you?

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Exit mobile version