What is the maximum number of transactions a minute on SQL server 2008

I am currently looking at simulating a device data logging system. We hav e a number of devices sending data to our servers. Currently, they use a fixed length flat file logging system but they are looking for alternative logging system. I have build a simulator that generates a number of threads representing devices sending data to the database server. Now, an issue that some forsee is the file locks during transactions since a transaction can be sent every minute by all devices at once. I am wondering if that is a potential issue and how many simultaneous transaction a minute.
more ▼

asked Aug 21, 2012 at 02:08 PM in Default

caouellet gravatar image

0 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

There's no set answer that anyone can provide to this question.

Your transaction throughput will depends on a great many factors such as:

  • CPU speed
  • CPU count
  • Installed memory
  • Memory configuration
  • MAXDOP settings
  • Disk speed
  • Disk configuration (RAID)
  • Disk type (SSD/Platter/FusionIO)
  • Network latency between devices & SQL
  • Database configuration
  • Database schema
  • DRI
  • Indexes

These are just some of the considerations. The only way you will know if you can handle the required workload is to build a development environment and a test harness.

Microsoft publish benchmark information around real world applications and TPC testing, you can find that at http://www.microsoft.com/sqlserver/en/us/product-info/benchmarks.aspx

Suffice to say that you can fully optimize systems and get in excess of 2,000 transactions per second. But your mileage will significantly vary.
more ▼

answered Aug 21, 2012 at 02:48 PM

SirSQL gravatar image

4.8k 1 3

(comments are locked)
10|1200 characters needed characters left
You may also want to consider StreamInsight, http://www.microsoft.com/sqlserver/en/us/solutions-technologies/business-intelligence/complex-event-processing.aspx , but it's usefulness does depend on your specific scenario
more ▼

answered Aug 21, 2012 at 05:07 PM

Kev Riley gravatar image

Kev Riley ♦♦
54.3k 47 49 76

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 21, 2012 at 02:08 PM

Seen: 1869 times

Last Updated: Aug 21, 2012 at 05:07 PM