The first factor is SQL Server version requirements.If you have several applications that require older versions of SQL Server (e.g., SQL Server 2005) and some that can be upgraded to SQL Server 2012, having a single instance won't work.” and understand why it’s an important project to implement.Server consolidation is a way to make a more efficient IT environment by combining servers or replacing legacy servers with virtual systems, the cloud or Saa S products.Also, there are plenty of advantages by server virtualization.Do you know that your each physical servers are not performing up to the level that they can perform? In fact, only 20% to 30% of it’s capacity is being used in normal environment.
Server consolidation is an approach to the efficient usage of computer server resources in order to reduce the total number of servers or server locations that an organization requires. Businesses are increasingly turning to server consolidation as one means of cutting unnecessary costs and maximizing return on investment (ROI) in the data center.
Server consolidation is exactly what it sounds like, it’s essentially consolidating hardware for more effective usage.
Per Farnsworth, these all save “operational costs almost immediately.” Ron Kumar, of Psychz Networks, says the reason people should pursue server consolidation is because it “saves a lot of money.” He also had some recommendations on when to do it: Consolidation typically is recommended if you are moving from hardware that is 2-3 years old and you can utilize a new hardware with less than 70% of footprint from the previous years.
If an application requires that the login to the server be a member of the sysadmin fixed server role, you probably don't want to place that application's databases on an instance with other applications because that application could access the other data.
Many third-party vendors say that their applications require sysadmin rights, but often the applications don't.