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

    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
    Location
    One Flump in One Place
    Posts
    14,912
    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.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    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
  •