Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

SQL Server 2008

Discussion in 'General' started by Novita Rini, Mar 26, 2016.

  1. Novita Rini

    Novita Rini New Member

    Hii, i am Novita,

    i have some database in one SQL Server.
    if one of database working with more data, the other database working slowly.
    So very disturb the others database. how the solution of this case?
  2. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Hi Novita,

    This sounds like a problem caused by resource-heavy queries. If this is a trend, there are several solutions.

    I would start by doing performance monitoring, in order to determine what exactly is causing the bottleneck. Is it CPU, RAM, or Disk IO.

    Then, first try and see if you can optimize or rewrite the query so it consumes less resources. If that fails, and there is a hardware bottleneck, add more hardware. A final resort could always be to move one or more of the databases to a separate server.

Share This Page