Wanna know where you fit in relation to someone else? Get the answers to these questions.

Now that's a big trophy.

Now that’s a big trophy.

1. How many SQL Server instances do you have? The pro folks use the word “instances” rather than servers because clusters may have multiple SQL Server instances per node.

2. How many DBAs work with you? One person managing 300 instances is very different than a team of 5 people managing those same servers.

3. What’s the total data size? You don’t have to get fancy and calculate space used – just add up all the files in Windows Explorer. If you want to collect this on a regular basis, use the backup sizes from the msdb tables.

4. How busy is your busiest server? Check the Perfmon counter SQL Server: SQL Statistics – Batch Requests per Second during your peak load times.

Have these answers ready off the top of your head, and you’ll get much better advice from other admins. The answers for a 100GB server doing 100 batch requests per second are very different than the ones for 10TB doing 100,000 batch requests per second.

Brent Ozar
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.

I’m mostly a figurehead here at Brent Ozar Unlimited. My true skills are menu advice, interpretive dance, and reading Wikipedia.
Brent Ozar on sabtwitterBrent Ozar on sablinkedinBrent Ozar on sabinstagramBrent Ozar on sabgoogleBrent Ozar on sabfacebook
↑ Back to top
  1. Isn’t the answer always “buy bigger hardware”?!? 🙂

    My clients are sometimes lucky if they know whether or not they are even USING SQL Server! Just had a potential client tell me (in the first 3 minutes of the call – yes, I always verify) that yes they were using SQL Server for their data storage. After dealing with NDA, contract, SOW, etc., it turns out they are using MySQL and the LAMP stack. Sigh…

  2. Would be interesting to actually collect responses from the readers and tally em up to get a rough idea of what the ‘other side’ is dealing with and where you fit in (albeit on a tentative sample size)

    1 – 125 (prod)
    2 – 3
    3- 3TB
    4 – 5-6k

  3. Am I going to be the one to have to do it? Alright.

    But he said that size *didn’t* matter!?

  4. 1. 700
    2. 3,5
    3. 50TB

  5. 1. 70
    2. 3
    3. 2.8TB
    4. 700/Sec

  6. 1. = One

    2. = One – Me. 🙂

    3. = 37.5 GB

  7. 1. 1150
    2. 1 in dk, 2 in sweden, ? in india
    3. 275+ TB

  8. 1. 80
    2. 2+1
    3. 12TB
    4. ~4000

  9. OK, I’ll play

    1. 121 (54 I have access to, plus 67 I don’t yet)
    2. me and me alone. I am the first DBA my employer has ever had in 40 years, SQL instances are a mess!
    3. 8 TB (of those I have access to )
    4. ~1200

Leave a Reply

Your email address will not be published. Required fields are marked *