microsoft sql server 2012 express edition - limit of concurrent inserts

Question

Is there any limit on the number of concurrent inserts when using Microsoft Sql Server 2012 express edition ? I am aware that are limitations on the number of cpus that can be use, the 1GB of Ram limitation and the 10GB disk space limitations (more here ), but I want to know if there are any limitations on concurrency.

score 6 · Accepted Answer · answered Apr 10 '12 at 13:18

6

No, it boils down to what you can squeeze out of it based on the other limitations/hardware. There is no "rate limit".

answered Apr 10 '12 at 13:18

AdaTheDev

142,592
28
206
200

http://msdn.microsoft.com/en-us/library/cc645993.aspx grep "Unlimited Concurrent DM Queries" there is no yes on the Express columns. There must be a limit! – clyfe Apr 10 '12 at 13:20
3

@clyfe - that relates to Data Mining - note Express doesn't have *any* support for any of those Data Mining features. It's not talking about concurrent inserts in the OP's context – AdaTheDev Apr 10 '12 at 13:26

score 2 · Answer 2 · answered Apr 10 '12 at 13:37

There was some performance throttling in SQL Server MSDE but that was removed in SQL Server 2005 Express.

From SQL Server 2005 Express Edition Overview

there is no workload throttle and the engine performs as in other editions.

I have not heard or seen that it have been added again in later versions.

microsoft sql server 2012 express edition - limit of concurrent inserts

2 Answers2