April 17, 2008 at 9:40 pm
Hello,
I want to use Performance Monitor to get the information of the no. of transactions on a SQL Server, I have 3 choices :
(1)SQLServer:Databases(_Total)\Transactions/sec
(2)SQLServer:General Statistics\Transactions
(3)SQLServer:Transactions\Transactions
Here are a portions of their results :
"04/18/2008 10:52:25.047","1269.1720084522563","59","19"
"04/18/2008 10:52:40.047","255.35447957046077","57","20"
"04/18/2008 10:52:55.048","1742.9925524193841","59","19"
"04/18/2008 10:53:10.063","977.12747662613685","60","19"
"04/18/2008 10:53:25.064","96.633311517438898","61","21"
"04/18/2008 10:53:40.080","641.28684750507728","59","20"
"04/18/2008 10:53:55.080","224.54448295795697","60","19"
I expect (2) and (3) should be identical, but the differences among them are quite large.
Which of them should I use if I want to monitor the no. of Transactions on a SQL Server ?
April 18, 2008 at 7:42 am
They're all "number of transactions". If you look up the measures, it'll tell you precisely what it measures, and you can compare that to what you're trying to measure.
- 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
April 21, 2008 at 1:48 pm
transactions are only a measure you use to compare workload, the actual figures are pretty meaningless. You might find batches and/or compilations a slightly better measure. I use databases - total transactions and the transactions for individual databases as required.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
April 22, 2008 at 12:28 pm
GSquared (4/18/2008)
They're all "number of transactions". If you look up the measures, it'll tell you precisely what it measures, and you can compare that to what you're trying to measure.
To be fair to the OP, the "Explain" text for (2) and (3) are identical.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply