SQL Server Performance

Finding resource utilization by specifice Databases

Discussion in 'SQL Server 2005 General DBA Questions' started by Fais, Jan 13, 2008.

  1. Fais New Member

    Hi all,
    We are planning to move on clustering. Right now, we have one instance with all the 10 databases. Here , four are main databases used by the application, so we want to install this 4 on Default instance. And the remaining 6 databases , we want to install on other named instance in Clustering.
    So, if I want to find the resources, transactions, activity consumed by the remaining 6 databases,how can we find this, So that we can allocate some cpu's to default instance & allocate rest of the cpu's to the named instance.
    Could anyone help in this.
    Thanks.
  2. satya Moderator

Share This Page