• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

What does instances mean wrt the limitations on sqlexpress?

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?
0
Cahirbarnagh
Asked:
Cahirbarnagh
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
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...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
1 instance is basically nothing else than 1 installation of sql server on 1 pc.
each such instance
* has a name or defaults as default instance
* has a set of the system databases (master, msdb, model, tempdb ...)
* has it's own windows service
* has it's own set of security records (logins)
* ...


0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
... uses it's own set of memory.
hence, having too many instances would simply slow down all of them..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now