Diwali (also spelled Divali in other countries) or Deepavali is popularly known as the festival of lights. It literally means “array of light”. Diwali is the most important festival of the year and is celebrated with families performing traditional activities together in their homes. Deepavali is an official holiday in India. I pretty much work every day except today. I dedicate this day to my family. This is their day.
Every year on Deepavali I share a database tips with all of my blog readers. I quite often get ask if I can help people with their systems performance. I am always willing to help people to check their system performance. If you want me to help you check your system’s performance and get early opinion from me about your system. You can send me result of following queries in excel to me.
-- Query 1
-- Query 2
ORDER BY wait_time_ms DESC
Once I receive your result, I will get back to you with proper first glance suggestions. May be your performance problem is very much visible but you have not paid attention to it.
Here are few tricks which always worked
Reference: Pinal Dave (http://blog.SQLAuthority.com)