question

caouellet avatar image
caouellet asked

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.
transaction
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SirSQL avatar image
SirSQL answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

AmirNBA9 avatar image
AmirNBA9 answered

In ComputerWorld book page 16 , said 5,000 transaction per-second in SQL-Server 2005

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.