Karthikeyan Kailasam

  • About Me
  • Capping MAXDOP in Azure SQL: How a Single Change Delivered a 57% Performance Gain

    For quite some time, our production Azure SQL Database suffered from unpredictable CPU spikes and throughput instability. While index tuning and routine maintenance offered some relief, the underlying “jitter” persisted. It wasn’t until we revisited our MAXDOP (Maximum Degree of Parallelism) settings that we finally achieved a stable baseline. Here is how we identified the…

    February 21, 2026