SQL Server Performance

Consolildating the Dbs

Discussion in 'General Developer Questions' started by sahuja2, May 6, 2008.

  1. sahuja2 New Member

    Hi
    I have to consolidate 12 dbs ona server to a single database.The databases are having same objects. and few tables don't have primary key in them.
    Please suggest a work around for this
    Sumit
  2. satya Moderator

    Welcome to the forum.
    What is the relation between primary key and databases count?
    There isn't any, in this case have you tested or compared the current hardware and upcoming hardware of the servers to ensure those 12 databases can cope up with available resources.
    What kind of changes you are going to make on the SQL server memory?
    See the blog posts below:
    SQL Server consolidation & keeping up performance at the same time
    SQL Server consolidation and virtualization - hot topic in the industry
    What are advantages of 64-bit system in relation to SQL Server?
    Streamlining migration and consolidation - Servers
    SQL Server 2005 Design Considerations for Migration

Share This Page