i am developing monitoring software for a variety of servers (including SQl server). I need to detect hung transactions, track them , etc etc. I am using C# to collect the perfmon counters. But i need to use other flags and constansts of the server as well. so can you tell me how i can do that? (i am not shy to use C++)
P.S. Any sugggestions to use more than just perfmon counters, flags, constants will also be greatly appreciated. I need to develop a fair monitoring software, so what all kind of data do you think i shud collect ?