Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Load Poll


The Load Poll

Author
Message
Nadrek
Nadrek
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1029 Visits: 2673
cfradenburg (12/21/2012)

And thus concludes my TPS report.


Ah.... yeaaahhhh... you see, we've changed to a new TPS report format, and that... that's the old format. Yeahhhh... we send a memo out, and I'll get you a copy of it tomorrow... because, yeahhhh, we'll need you to come in on Saturday. At 9.

Most of our systems peak in the low tens and average single digits. Our few very large production systems average low to mid triple digits, with peaks in the low to mid four-digit numbers, though performance during those peaks is still quite good.

Note that of course "transactions" can be small or large, and thus don't say a whole lot by themselves.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36038 Visits: 18733
Vila Restal (12/21/2012)

Lastly, this method of collecting a poll isn't very efficient for you or the contributors.
Does this blog not have a survey facility or at least a thread that can be voted on?


Polls don't work well here. We've tried, and they often are forcing people into a certain answer. I was hoping to get counts and some background, just as you gave.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
david.beav
david.beav
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 21
Situation: 60GB production database for medium-sized company, 700+ web users during the day, some usage 7*24.

We've never thought about our system in terms of TPS... we just focus on CPU utilization on the database server. Our machine runs all 8 cores between 20 and 40% during the business day, and down to 1% overnight. Whenever utilization gets over 50% our users start to complain about speed, and it's almost always some explainable cause.

In the last 30 seconds we've been between 20 and 40%, and SQL says we've done 86,000 transactions... so I guess we're running 2,800 TPS.

We can take the system down during off hours (with advance notice) for up to an hour with no problem. More than an hour offline starts to cause real problems with the team serving our customers.

Our biggest performance pain point is trying to get big jobs done overnight. We have to sequence backup, export to data warehouse, synchs with other databases, and 45 minutes worth of database maintenance scripts so they don't run concurrently, but our overnight users always feel real system slowdowns in the depths of the night.
blakmk
blakmk
SSC-Enthusiastic
SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)

Group: General Forum Members
Points: 142 Visits: 337
Im designing a system to scale to 12,000 TPS. It involved some clever tricks such as using Service Broker for Lazy processing.

Sql Server Blog
Sql Server Consultancy

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search