<div>
Cahirbarnagh,<br />
&gt;&nbsp;a) Only 16 simultaneous calculations can be done.<br />
<br />
<br />
Each instance will work as a separate sql server, it has nothing to do with the no of connections... 
</div>


Cahirbarnagh,
> a) Only 16 simultaneous calculations can be done.


Each instance will work as a separate sql server, it has nothing to do with the no of connections...

<div>
... uses it's own set of memory.<br />
hence, having too many instances would simply slow down all of them..
</div>


... uses it's own set of memory.
hence, having too many instances would simply slow down all of them..

<div>
<div class="content wysiwyg-content">
SQLexpress has a limitation of 16 instances I believe. I have a website which has a front end that allows some calculations to be done and would like to know what this limitation means?<br />
Beginner wrt sql.<br />
a) Only 16 simultaneous calculations can be done.<br />
b) What happens on the 17th instance? <br />

</div>
</div>


SQLexpress has a limitation of 16 instances I believe. I have a website which has a front end that allows some calculations to be done and would like to know what this limitation means?
Beginner wrt sql.
a) Only 16 simultaneous calculations can be done.
b) What happens on the 17th instance? 


What does instances mean wrt the limitations on sqlexpress?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.