June 25, 2015 at 12:38 pm
I have about 50 databases that are only accessed once a month and on a predictable schedule. Would it free up resources on the server if they were kept offline and brought online only when needed ?
Thanks
June 25, 2015 at 12:43 pm
As long as they are not being accessed anybody, then they should not be using any resources.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 25, 2015 at 3:46 pm
What type of resources are you trying to free up?
Joie Andrew
"Since 1982"
June 26, 2015 at 5:49 am
Any plans or data in cache would be removed. But, if they're not being accessed, then the standard processes within SQL Server would also remove them over time, so... it's a wash really.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 26, 2015 at 7:17 am
Any maintenance plans you're running that look at all online databases would have less work to do if you took those databases offline. That might help if you only have a narrow window for maintenance.
Not executing the maintenance plan against those databases may or may not be a good thing.
Reducing the workload of the maintenance plan by skipping these database, if desired, can also be accomplished without taking the databases offline.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 26, 2015 at 7:22 am
Alvin Ramard (6/26/2015)
Any maintenance plans you're running that look at all online databases would have less work to do if you took those databases offline. That might help if you only have a narrow window for maintenance.Not executing the maintenance plan against those databases may or may not be a good thing.
Reducing the workload of the maintenance plan by skipping these database, if desired, can also be accomplished without taking the databases offline.
True. Although, presumably, you'd still want backups and consistency checks on those databases, so having them offline could actually be problematic in that regard. Hard to say which is better.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 26, 2015 at 7:28 am
Are you facing any resource issue? provide more detail.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 26, 2015 at 7:34 am
Grant Fritchey (6/26/2015)
Alvin Ramard (6/26/2015)
Any maintenance plans you're running that look at all online databases would have less work to do if you took those databases offline. That might help if you only have a narrow window for maintenance.Not executing the maintenance plan against those databases may or may not be a good thing.
Reducing the workload of the maintenance plan by skipping these database, if desired, can also be accomplished without taking the databases offline.
True. Although, presumably, you'd still want backups and consistency checks on those databases, so having them offline could actually be problematic in that regard. Hard to say which is better.
Unless the databases are causing a problem, I'd leave them online.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 26, 2015 at 7:44 am
Alvin Ramard (6/26/2015)
Grant Fritchey (6/26/2015)
Alvin Ramard (6/26/2015)
Any maintenance plans you're running that look at all online databases would have less work to do if you took those databases offline. That might help if you only have a narrow window for maintenance.Not executing the maintenance plan against those databases may or may not be a good thing.
Reducing the workload of the maintenance plan by skipping these database, if desired, can also be accomplished without taking the databases offline.
True. Although, presumably, you'd still want backups and consistency checks on those databases, so having them offline could actually be problematic in that regard. Hard to say which is better.
Unless the databases are causing a problem, I'd leave them online.
I agree.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply