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