Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • 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

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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