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

avatar 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

avatar image

4.9k 4 5

(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

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(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: 5001 times

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

Copyright 2018 Redgate Software. Privacy Policy