YOUR CHANNEL IS LOADING

LATEST EPISODES MORE EPISODES

  • 1

    SQL Server Should Work for Us

  • 2

    The Best Programmers

  • 3

    Do You Want a Meritocracy at Work?

  • 4

    The Watson Service

  • 5

    The Decision to Fail

The Voice of the DBA The Load Poll

MEVIOtoday

Dec 20, 2012 The Load Poll

I was taking to someone recently and this person had a large transaction load on their SQL Server. At least, I thought it was a large load. This person said they experienced 1000tps most of the time and this made maintenance, DR planning, and more a challenge. That's a lot lower than the TPCe performance system that has 4,614tps, but it's nothing to sneer at. That feels like a significant load to me.

However it's been awhile since I worked on a variety of systems as a consultant. I often see the forums at SQLServerCentral showing only tens of transactions/sec, based on the performance data that you can see at monitor.red-gate.com. This is the actual data from our servers and it seems like a low number to me.

 

Read the rest of "The Load Poll" at SQLServerCentral.