Q&A: Dealing with Thousands of Databases (Part 3)

Andy Levy
This is Part 3 in a three-part series. Please see Part 1 and Part 2 for more. What does your average day look like? I’m going to punt to my “A Day in the Life” series here. When you started, did you know what your position was going to look like 1 month, 6 months, 1 year, 5 years from then? How accurate has that been so far? I’ve only been at my current job for about 2 1/2 years, but I can speak to the shorter intervals.

Q&A: Dealing with Thousands of Databases (Part 2)

Andy Levy
This is Part 2 of a series. Please see [Part 1]/2019/09/03/qa-dealing-with-thousands-of-databases/) for the background and more. What is the most unexpected experience you’ve had in this position? I have two answers to this question. I write more dynamic SQL in any given week than I had previously in my career - all years combined! Many DBAs deal with issues around parameter sniffing and plans being stuck in cache that don’t work well for a number of their requests as a result.

Q&A: Dealing with Thousands of Databases

Andy Levy
This is part one of a three-part series. I’ve mentioned in various places, including in blog posts on occasion, that my production SQL Server instance hosts several thousand (nearly 9000 as of this writing) databases. People are usually surprised to hear this and it often leads to interesting conversation. Jon Shaulis (blog | twitter) asked me on Twitter recently: @ALevyInROC Have you written before about your experience managing thousands of databases by chance?