HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlModerate

Performance benefit of taking unused databases offline

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
databasesbenefitunusedofflineperformancetaking

Problem

I have several databases for legacy applications which run in VMs that are currently off until someone needs to look at some history. I have set each of the databases used by these applications to offline but I wanted to know:

Is there a performance benefit to having these unused databases in the offline state instead of sitting online but unused without any connections to them or queries run against them?

Solution

If the database has objects in memory, taking it offline will remove those objects from the buffer. This frees up memory for other database objects.

Also, taking it offline ensures that automated maintenance plans (backups, index maintenance, integrity checks...) don't waste any resources doing maintenance on it.

Context

StackExchange Database Administrators Q#30374, answer score: 13

Revisions (0)

No revisions yet.