You are correct, the opposing paths of dedicated versus shared SQL Servers have been major trends for different reasons at many organizations.Neither path is necessarily right or wrong as an approach, but the support and development related to each path should be analyzed from an organizational level and then a decision should be made.In other circumstances, the consolidation is for the hardware, storage, Windows and SQL Server instances.Both alternatives have advantages and disadvantages, so what is the correct path? When considering migrating to SQL Server 2005 or 2008, should a consolidation effort be considered as well if we have a large number of SQL Servers are in scope for the project?
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
Since each workload can demand different computing resources, it's important to measure the needs of each workload and allocate workloads tso that the underlying host servers are not overloaded -- a process known as "workload balancing.".