Click here to Skip to main content
15,881,424 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Hello All,

I have a server on which 15-20 large databases are stored.Some of them are not in use.

I am thinking to make them offline instead of deleting them.

My question is , once i take database offline will it release some load on server?
Will my queries run faster if i reduces number of online databases on server?
(i think more number of databases hosted on server , slower the server will be)


Thanks
Posted
Updated 13-Aug-13 20:53pm
v2

if servers is low on hardware, making database offline does reduces server load up to some extenet.
 
Share this answer
 
I agree with Maciej Los here. It doesn't matter if the databases are unused.

Quote:
Will my queries run faster if i reduces number of online databases on server?

That depends. Depends on how many users are accessing/querying in your database hosted in the server. Depends on the query you sent.


Quote:
(i think more number of databases hosted on server , slower the server will be)

That also depends. Example: In server 1, you have 4 databases but 3 of them are unused, with 16 users accessing the database. In server 2, you have 2 databases, both of them are used, with 16 users accessing each database. What server do you think is slower?

Quote:
once i take database offline will it release some load on server?

What 'load' are we talking about? The workload or the space?
 
Share this answer
 
I think it's not important that the databases are unused. It's important how many place they occupy.

I would suggest you to shrink[^] the databases and detach[^] them to make a copies. After that remove detached databases from server (if they are really unused). You'll be able to attach them anytime you want.

Please, use Google with sentence: SQL Server perfomance fo further information.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900