Transactions Per Second

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Performance Tuning » Transactions Per Second

Transactions Per Second

Rate Topic

Display Mode

Topic Options

Author

Message

growl

Posted Wednesday, December 10, 2003 3:32 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 12:40 AM
Points: 423, Visits: 530

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

Steve Jones - SSC Editor

Posted Wednesday, December 10, 2003 5:26 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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

growl

Posted Wednesday, December 10, 2003 6:53 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 12:40 AM
Points: 423, Visits: 530

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

colin.Leversuch-Roberts

Posted Thursday, December 11, 2003 1:44 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:10 PM
Points: 2,668, Visits: 688

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

doc_sewell

Posted Thursday, June 10, 2010 10:37 AM

SSC-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

Steve Jones - SSC Editor

Posted Thursday, June 10, 2010 10:46 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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

doc_sewell

Posted Friday, June 11, 2010 7:24 AM

SSC-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

Steve Jones - SSC Editor

Posted Friday, June 11, 2010 5:58 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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

DinaDBA

Posted Monday, January 07, 2013 8:53 AM

Forum 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 »

Permissions