Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Advanced Clustering Question: how can I monitor Clustered MSDTC Transaction Statistics Expand / Collapse
Posted Thursday, June 20, 2013 10:45 AM


Group: General Forum Members
Last Login: Monday, December 21, 2015 8:37 AM
Points: 119, Visits: 939
We have a robust 3-node cluster that includes Clustered MSDTC. You can see Transaction Statistics by using the Component Services snap-in for MMC. I don't have an exact screenshot, but see this one -- you would double-click on Transaction Statistics and see a bunch of numbers...

(I got that from here:

But how can I read these values programmatically, so I can track them over time, store them into a SQL database, alert on them, etc?

Any help appreciated!

Post #1465843
Posted Wednesday, July 3, 2013 3:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 6, 2015 8:30 AM
Points: 30, Visits: 351
You will need to read data from the COM+ Catalog:

"The COM+ catalog provides a layer of abstraction over the actual details of where and how COM+ configuration data is stored. Much of the data is stored in the COM+ registration database (or RegDB), which holds data for all configured components installed in COM+ applications. This database is used at application run time to provide configuration data to COM+ to properly activate objects in an appropriate context, enabling services to be provided for objects per their configuration. The RegDB itself is a transacted resource manager that uses DTC transactions through the compensating resource manager; when you make persisted configuration changes, they are committed transactionally. The only way that you can access the RegDB is through the COM+ catalog, using the COMAdmin objects or the Component Services administrative tool."

It sounds like you may be able to connect to the COM+ Catalog RegDB database using

Have a look at the above at page 350+ and you may be able to get some ideas, going further this isn't something I've done before as i'm not a developer so these are just purely links that may provide you with more information.
Post #1469926
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse