To avoid SQL Server sprawl IT departments should centrally manage their SQL Server installations. If a business unit requires database resources they should consult with the SQL Server team to deploy their database on one of the centrally managed SQL Servers. Properly managed, several hundred databases can be stacked on a single instance of SQL Server running on a multi-proc box, and offer better performance using this configuration than on a standalone server where SQL Server is the only database.
The advantages of consolidation are:
- Central management
- High availability
- Conservation of resources and licenses
- More efficient use of SQL DBAs as they have less SQL Servers to manage
- Enforcement of best practices and standards
- Easier maintenance – less servers to apply a service pack or critical hot fix to
- Better overall database performance
Dig Deeper on Database software management
Related Q&A from Hilary Cotter
SOA depicts how two services or programs can communicate with each other. Learn why SOA should catch the attention of service providers and the ... Continue Reading
Learn why Oracle VM would be chosen over Hyper-V or VMware and read an expert's recommendations for implementing Oracle VM. Continue Reading
Learn the new components of Windows XP SP3 including black hole router detection and network access protection. Compare XP SP3 features to Vista and ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.