Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009

    Unanswered: MS-SQL Performance issue

    What is the performance effects if one keeps multiple databases on a single server.
    i mean if there are blocks on one db,does it affect the performance of other Db??

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    There are physical resource implications, but nothing else.

    EDIT - and that isn't really a property of multiple databases. I mean that multiple databases will share the same memory, CPU, disk (probably). If one db is getting thrashed then other queries on any db will be affected as there will be less physical resources to go round.
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Dec 2007
    London, UK
    In SQL Server 2008 Enterprise you have the option to create resource pools and workload groups so that activitiy in one database can't monopolise memory and processor required by other databases. In Standard Edition and in earlier versions you don't have that option.

Posting Permissions

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