Whenever the DBSS_DTC_Information collection runs it gets the following error (there can similar errors to the below but the solution is applicable for all):
Foglight is monitoring a SQLSERVER 2008 R2 Cluster on Windows 2008 R2 servers and the following message appears in the SQL Server agent log:
---
---
The following alarm is raised even though the DTC is running on a machine separated from the SQL Server itself:
---
The Distributed Transaction Coordinator (DTC) service is installed but not running.
---
How to configure the Agent to address DTC service located on the same machine where the SQL Server is?
What does this alarm mean and what should we do to resolve this issue?
The error is being receive due to unexpected configuration of the customer environment (f.g : number of DTC services which running on the same host machine).
There are two main scenarios when using DTC:
There are two main scenarios when using DTC:
SCENARIO 1 - the DTC resides on the same SQL Server host
The Agent Status Property parameter "DTC service name" should be set with the name of the DTC service that services the SQL-Server instance. The names of the DTC services should be taken from the following WMI query (can be run via WMI explorer):
select Name from Win32_PerfFormattedData_MSDTC_DistributedTransactionCoordinator
* In this scenario there is no need to fill in the DTC SERVICE HOST
* In this scenario there is no need to fill in the OS login credentials.
Scenario 2 - Setting the Agent to address DTC service which is installed on its own machine
In this case, fill in the:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center