Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Error when monitoring in SQL Server Single User Mode when Transaction Log Freespace Alert is running

Error when monitoring in SQL Server Single User Mode when Transaction Log Freespace Alert is running

Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 1,165 Votes: 0 Revisions: 8

Overview

If you attempt to monitor in SQL Server single-user mode when the Transaction Log is running, the following error occurs in the DPA logs:

Monitor for database name failed in job [QuickPollJob] due to [Database name is already open and can only have one user at a time.

When this error occurs, it shuts down the DPA and repeatedly attempts to restart, which is caused by an issue SQL Server has with running the monitoring query at the same time as the dbcc sqlperf('logspace') query if one or more databases in the monitored instance are in single-user mode.

The dbcc command is used by the Transaction Log Freespace alert in DPA.  If the dbcc command takes a long time to run or is run often (again, if there is also a database in single-user mode), the DPA monitor will not have continuous monitoring.

Environment

All versions of DPA

Solution

To allow the DPA to monitor instances with single-user mode databases without this error, ensure that the monitored db instance is not in the Selected Database Instances list for a Transaction Log Freespace alert.

Last modified

Tags

Classifications

Public