• Article Topics

  • Become a member of the SQLDBASupport community and receive notifications of new posts by email

    Join 82 other followers

  • Are you writer? Become an Author! Mail to

    amitvaid81 @ gmail dot com

  • Founder

    This is journey of a SQL DBA. I now work as a Sr. Database Architect and Solution Consultant, generally in performance tuning, clustering or high availability. The opinions expressed herein are my own personal opinions through real time experience.

    Amit Vaid

Basic Performance Investigation

When we have to go through a performance issue, the first thing that we have to do is gathering all the information as possible from the user that is reporting the issue. Many times, the source of the problem is on the user environment and we have to ensure that the problem is a real performance problem before starting the investigation. In order to gather information, we need to ask to the user as many question as we can build approaching meaningful information (like error messages, actions performed, etc) about the issue and if needed, we can ask the user to share their desktop to understand at all the user problem.

  Continue reading