Post reply

Migrating many onto one SQL box

  • October 19, 2010 at 12:09 pm

    #241882

    I have many small in size SQL servers that we are considering migrating onto one server, for cost savings.

    Before migrating these onto one box, I thought it best to do some performance metrics over time to make sure I can combine all of these smaller db's onto one server without performance issues.

    What would be the best way for me to insure that I can migrate sucessfully?

  • October 19, 2010 at 12:59 pm

    #1239288

    Measure the usage of various instances, keeping in mind CPU and disk. RAM is hard since they tend to use all memory, but look at #s of connections and transactions and take a guess. I would migrate instances one at a time and watch the load for a week or so to be sure you are not overloading the server.

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

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