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.
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.