ApexSQL Knowledgebase: Managing the ApexSQL ConnectionMonitor 2008.exe process

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly.

FAQs

Quick answers to common questions.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools.

Online Documentation

All of our help files for download or convenient viewing online.

Videos

Watch product demos, training videos, or tutorials of our products' main features.

ApexSQL Knowledgebase

Tips and How-to Articles for Apex SQL Tools

Managing the ApexSQL ConnectionMonitor 2008.exe process

DESCRIPTION
This article describes how to stop, start, enable, or disable the ApexSQL Log Connection Monitor. It also describes how to get its current status (e.g. Is it running? Disabled? etc.)

For more information about ApexSQLConnectionMonitor.exe and how to uninstall it (and ApexSQL Log's other server-side components), please click here.

SOLUTION
To manage the ApexSQLConnectionMonitor2008.exe process, run the following commands in Microsoft SQL Server's master database:

For ApexSQL Log 2008.01 - 2008.03 versions
To start the ApexSQLConnectionMonitor2008.exe process

EXEC MASTER.dbo.Sp_apexsqlconnectionmonitor2008_start

The connection monitor must be enabled before it can be started.

To stop the ApexSQLConnectionMonitor.exe process

EXEC MASTER.dbo.Xp_apexsqlconnectionmonitor2008_stop

When the server restarts, the ApexSQLConnectionMonitor2008.exe process will start again. If you don't want this to happen, disable the process after stopping it.

To disable the ApexSQLConnectionMonitor.exe process

EXEC MASTER.dbo.Xp_apexsqlconnectionmonitor2008_disable

To enable the Connection Monitor

EXEC MASTER.dbo.Xp_apexsqlconnectionmonitor2008_enable

To see the current status of the Connection Monitor

EXEC MASTER.dbo.Xp_apexsqlconnectionmonitor2008_info

Starting from the ApexSQL Log 2008.05 version
To start the ApexSQL ConnectionMonitor process

EXEC MASTER.dbo.Sp_apexsqllog2008connectionmonitor_start

The connection monitor must be enabled before it can be started.

To stop the ApexSQLLog2008ConnectionMonitor.exe process

EXEC MASTER.dbo.Xp_apexsqllog2008connectionmonitor_stop

When the server restarts, the ApexSQLLog2008ConnectionMonitor.exe process will start again. If you don't want this to happen, disable the process after stopping it.

To disable the ApexSQLLog2008ConnectionMonitor.exe process

EXEC MASTER.dbo.Xp_apexsqllog2008connectionmonitor_disable

To enable the Connection Monitor

EXEC MASTER.dbo.Xp_apexsqllog2008connectionmonitor_enable

To see the current status of the Connection Monitor

EXEC MASTER.dbo.Xp_apexsqllog2008connectionmonitor_info

AUTHOR
Janice Lee

LAST REVIEW DATE
10 June 2009

Labels: ApexSQL Log

posted by Janice Lee on Wednesday, June 10, 2009

0 Comments: