Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, June 20, 2013 10:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:08 AM
Points: 119, Visits: 928
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: http://blogs.technet.com/b/askcore/archive/2009/02/18/how-to-configure-multiple-instances-of-distributed-transaction-coordinator-dtc-on-a-windows-server-failover-cluster-2008.aspx)

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: Thursday, November 20, 2014 6:38 AM
Points: 30, Visits: 313
You will need to read data from the COM+ Catalog:

http://msdn.microsoft.com/en-gb/library/windows/desktop/ms679168(v=vs.85).aspx

"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 VB.net:

http://books.google.co.uk/books?id=YvTwDUld1LEC&lpg=PA350&ots=UaB0R5bUxQ&dq=access%20com%2B%20RegDB%20Database&pg=PA350#v=onepage&q=access%20com+%20RegDB%20Database&f=false

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