Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transactions Per Second Expand / Collapse
Author
Message
Posted Wednesday, December 10, 2003 3:32 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 11:17 PM
Points: 423, Visits: 531
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




Post #19087
Posted Wednesday, December 10, 2003 5:26 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:29 PM
Points: 32,834, Visits: 14,975
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
sjones@sqlservercentral.com
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
www.dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #90778
Posted Wednesday, December 10, 2003 6:53 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 11:17 PM
Points: 423, Visits: 531
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?




Post #90779
Posted Thursday, December 11, 2003 1:44 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:08 AM
Points: 2,674, Visits: 695
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



The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #90780
Posted Thursday, June 10, 2010 10:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 04, 2012 8:18 AM
Points: 155, Visits: 123
Yes, it is relative. Steve, do you know of any TSQL commands to get the TPS?
Post #935525
Posted Thursday, June 10, 2010 10:46 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:29 PM
Points: 32,834, Visits: 14,975
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #935533
Posted Friday, June 11, 2010 7:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 04, 2012 8:18 AM
Points: 155, Visits: 123
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?
Post #936004
Posted Friday, June 11, 2010 5:58 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:29 PM
Points: 32,834, Visits: 14,975
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.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #936378
Posted Monday, January 07, 2013 8:53 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 15, 2013 3:51 PM
Points: 1, Visits: 35
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
Post #1403679
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse