I regularly visit client sites and review their SQL Server configurations. I come across all kinds of strange settings. I’ve been thinking about a way to aggregate people’s configurations and see what’s common and what’s unique. I used to do that with polls on SQLTeam.com. I think we can find out more interesting things if we look at combinations of settings in relation to size and volume.
I’ve been working on an application for another project that is similar. It will be fairly easy to use that code for this. I can have something up and running in a few days – if people are interested in it. I admit that I often come up with ideas that just don’t make sense. This may be one of them. One of your biggest concerns has be how secure your data is. My solution is not to store anything identifying. The instance name and database names can both be “anonymized” and I don’t store the machine name or IP address or anything to do with logins.
Some of the questions I’m curious about are:
- At what size database does the Enterprise Edition become prevalent?
- Given the total size of the databases how much RAM is common?
- How many people have multiple data files? At what size does that become prevalent?
- How common is database mirroring? Replication? Log shipping?
- How common is full recovery mode? At what data size does it become prevalent?
I think those are all questions that are easy to answer -- with the right data. The big question is whether or not people will share their SQL Server configurations. I understand that organizations in regulated or high security environments can’t participate. But I think that leaves many, many people that can. Are you willing to share your configuration and learn about others? I have a simple sign up form here. It’s actually a mailing list signup that also captures your edition, number of servers and largest database. The list will only be used for this project.
Is your SQL Server is configured correctly? Do you wonder what the next step is as your data grows? Take a second and sign up.