December 10, 2003 at 3:32 pm
Hi I'm doing some performance monitoring and was wondering if someone could shed some light on this counter? In particular what is considered low and what is considered high?
Or what is the maximum sql server can handle?
Thanks
December 10, 2003 at 5:26 pm
low and high depend on your system. I've had 11k/sec for some systems that maxed the server and 100/sec for other systems.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 10, 2003 at 6:53 pm
Does the transaction per second refer to kb or number of transactions?
If it's number then what counter do use to see the size in kb?
December 11, 2003 at 1:44 am
it's number of transactions .. to see throughput you'd really need to measure pages/sec or throughput on the disk system in read and write bytes/sec
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 10, 2010 at 10:37 am
Yes, it is relative. Steve, do you know of any TSQL commands to get the TPS?
June 10, 2010 at 10:46 am
Yep.
SELECT cntr_value, *
FROM sys.dm_os_performance_counters
WHERE counter_name = 'transactions/sec'
AND OBJECT_NAME = 'SQLServer:Databases'
AND instance_name = 'AdventureWorks'
http://msdn.microsoft.com/en-us/library/ms187743%28v=SQL.100%29.aspx
June 11, 2010 at 7:24 am
I see, you still have to run counters. But our clients often refuse to do that. Is there any other query that can yield TPS without running counters?
June 11, 2010 at 5:58 pm
Not that I know of. The counters have to be captured somehow. If clients don't want to do that, then I guess there's nothing to be done.
January 7, 2013 at 8:53 am
Hi Steve,
Do you know how to measure the max of a given server - (instead of finding out the hard way)? So that the TPS is less relative and more interpretive?
I just measured various databases for a test server I set up and they range between TPS of 1 million and zero. Oddly msdb has 1,160,005 which seems incredibly large. I am trying to figure out what to make of these numbers. Thank you!
Edited:
I believe I found my own answer: The entire script is here: http://stackoverflow.com/questions/5019593/sql-server-2008-transaction-per-second-for-specific-database
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply