The Four Answers To “How Big Is Your SQL Server?”

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.

Previous Post
Always On Availability Groups, Backup Checksums, and Corruption
Next Post
RECOMPILE Hints and Execution Plan Caching

9 Comments. Leave new

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.