In this article
Forsta Plus installations with many active surveys should utilize the automatic survey database detachment/attachment feature. It is also recommended to monitor how many survey databases are attached at a given time if you suspect your database server is nearing capacity – detaching inactive databases frees up resources for live ones, and reduces time spent for failover if you are running an active-passive SQL cluster. The following query returns the amount of attached survey databases on a particular SQL Server instance:
select count(*)
from confirm_admin.dbo.surveydatabases
where active = 1;