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.
asked Aug 21 '12 at 02:08 PM in Default
There's no set answer that anyone can provide to this question.
Your transaction throughput will depends on a great many factors such as:
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.
answered Aug 21 '12 at 02:48 PM
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
answered Aug 21 '12 at 05:07 PM
Kev Riley ♦♦