sql server 2005: connection stats

  • I have a db that serves as the back-end to an Office Communication System. I need to create a asp .net website that will provide users connection data, such as how many connections at what time, etc.

    Where is this information maintained in the sql db? How would I provide this info? Any ideas to get me started would be great!

    Is presenting the data via an asp .net page the best solution or are there other, better ways, such as crystal reports? (I do not have reporting services installed)

  • Check out BOL for Dynamic Management Views. There is one called sys.dm_exec_connections that has user connections. There are many others that may have information you want as well.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply