Tune Your Queries with SQL Optimizer (Pt 1)
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are: Minimize Response Time – End users who are interacting wit...
Monitoring Workload – Heads or Tails, it’s two sides of the same coin
I often get asked about monitoring SQL workload that is consuming a database instance’s resources. The first question that comes to my mind is, “What is the symptom you are trying to resolve?” Are you...