Hi please could someone give me a explination of how SQLserver deals with multiple databases, We have multiple website that are all run from the same server all from SQLserver. Now we have a couple of databases which are very busy and have a lot of people constantly accessing them and then we have quite a few with much less traffic.

How would these databases effect each other? Would the busy database, mean that the many small databases will all be slowed dramtically?

Everything is okay at the moment but we are considering putting another fairly large database on the server and am worried about it having a sever effect on the smaller databases. Cheers Nixies

If they are all on the same server and the server can't handle the large databases then yes, the smaller ones will be affected. Anything that puts a load on the server will affect *everything* else on that server.

Try some RAID (redundant array of independent disk)s.

Checkout these links.

http://www.sqlteam.com/item.asp?ItemID=1452
http://msdn.microsoft.com/library/en...tun_1_0m5g.asp
http://www.sql-server-performance.co...rver_setup.asp