|
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.
(comments are locked)
|
|
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.
(comments are locked)
|
|
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
(comments are locked)
|
