September 24, 2008 at 5:51 am
Theres no direct way to monitor number of committed transactions in SQL 2005 . I know the commited transactions/sec counter is in 2008 but we dont have 2008 installed.
besides using profiler to search based on the textData column like commit% , is there any way to monitor the number of committed transactions in SQL server 2005?
September 24, 2008 at 11:29 am
Not that I know of.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 24, 2008 at 12:40 pm
bummer. it would be real useful to be able to know how many transactions are being committed, as only committed transactions will be replicated as far as i know and it would give a good indication of the loads that will be pushed to the other server via replication.
oh well.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply