Applications Systems

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

If a user monitors in SQL Server single-user mode when the Transaction Log is running, an error occurs in the DPA logs. The error shuts down DPA and repeatedly attempts to restart. This is caused by an issue the 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.

First published date

11/21/2018 11:18 PM

Last published date

5/10/2019 6:01 PM

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.

Product section

Database Performance Analyzer

Resolution

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.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.