Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2012
    Posts
    2

    SQL Consilidation question

    I am fairly new to SQL. I have built many basic SQL servers, but have never tried consolidating them. I am looking for ANY and ALL advise for doing this. Here is the situation.... I have approximately 12 instances of SQL running throughout my network. Each instance contains 1 database per. Some of the instances are full blown SQL, others are SQL express. I would like to consolidate these SQL instances into one server, running all of the databases. At this point, I am not even sure where to start.

    I have been looking into licensing and keep getting several different answers on how I should do this. The SQL server would be running on a VM. Each Virtual host has 2 quad core processors. I was thinking about licensing 4 cores and running one server on these four cores. I have been told though that if I want to be able to migrate this server from one host to another, I would need to license all 8 cores. Then I am told that I can run as many SQL servers as I want and migration is not an issue. Well, licensing cores is not cheap and I don't want to Over-license if I don't need to.

    I am looking for advice as to how I should do this. Anyone have any advice for consolidating my SQL instances?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,815
    "12 instances of SQL" doesn't make sense.
    SQL is a query language not something that is installed or even has an instance

    That's like saying: I have 12 instances of Java running...

    What exactly are you talking about?
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Dec 2012
    Posts
    2
    I have 12 separate SQL servers, running different versions of Microsoft SQL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •