Post reply

Performance monitor...Transactions/sec

  • January 27, 2004 at 9:35 am

    #160730

    How would you define the SQLServeratabases Transaction/sec counter?

    More specifically, how would you define a "Transaction" in this case?  Are select statements included?

     

    Jeff


    "Keep Your Stick On the Ice" ..Red Green

  • January 28, 2004 at 4:19 am

    #491908

    In explination it is "Number of transactions started for the database."

    It does not include Select as it does not cuase data changes.

    But note I have seen some items throw weird results that I haven't pinned down. For example I ran an Update statement on a quite system (one that has no live transactions going against it and only for testing), I recieved an 11.94 as the number of transactions at that moment. On subsequent runs it show 1. Also when I open the table in EM for desing view it I get weird results unless I open it repeatedly by itself all in a row, if ran the update the results from the output change.

    With this in mind I hav to say I just use it when I think a DB may have a lot of activity going on on the server and want to test that DB to get a vague idea.

  • January 28, 2004 at 8:39 am

    #491991

    Thanks..that is probably the best explanation I could get.  Or could hoep for.   I am seeing some odd results myself and have been hoping to figure it out.

    Thanks..............


    "Keep Your Stick On the Ice" ..Red Green

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

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