Consolidation

  • Hi,

    I was wondering if anyone knows of a good resource for PRActical tips on consolidating SQL servers.  The goal is to cut down on the number of physical servers, optomize performance and reach highest availability and managebility (easy on both DBAs and Sys admins).  Things like RAID suggestions, CPU, Memory, etc....

     

    Thanks

    A.

  • From my own personal experience we here are wanting to consolidate SQL Servers also. The way I am approaching it is taking each applications into account. We do not buy high end servers so I have to make sure I do not put too many apps. on one server. I also take into account the different apps. as to how they support SQL Server, some are quick to responding to upgrades and service packs, others are way behind. If you consolidate a bunch of purchased apps and you have a little bit of both you will have to wait until all certify changes in order to upgrade. I also monitor which apps. use a lot of CPU and or memory and # of connections and try to find the right combination that way also. We also have a clustered SQL Server that is for high availablility that are avail. via our web portal so those type apps go there because if that SQL Server needs to come down for something if the portal is down that app is down anyway. Likewise I also have a server that is for SQL Server apps. that are basically M-F 8-5 and those type apps live there. I am trying to have new apps that come here ONLY put the database on the server running SQL Server and put the app. software on an app. server. That way if an upgrade to the app requires a reboot it will not effect the other SQL Server databases. Also, if I need to move SQL server to a new server (thinking about Win2003 and SQL 2005) its an easier task just to move dbs and not dbs AND reinstalling the app.

  • We consolidate our servers by utilizing a SQL "Farm". This is a SQL clustered environment where we re-locate similar applications to reside together on a specific instance. These are dependent on SLA requirements. We have the same for our web apps.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply