Software Architecture – Microsoft SQL Server Express Edition with Advance Features -Licensing Query

While Exploring Licensing option for PCMS ERP Pegasus Cargo Management System, i had passed a query to Microsoft-Pakistan.

My Query to Microsoft Licensing Team – Islamabad – Pakistan

We are evaluating to use Microsoft SQL Server Express edition with advance features for our product.

With reference to your link below,
http://msdn.microsoft.com/en-us/library/cc645993.aspx
We have some questions as:

1. Is there any limitation of number of clients connecting to SQL Server express edition with advance features?

2. Secondly, table with title as “Scalability and Performance” in the above link suggests that there is a limitation of “Maximum memory utilized” as “1 GB” for SQL Server Express edition with advance features.. What is the meaning of this limitation, can you please explain it in more detail? Does this memory refer to the size of memory that can be used in system where SQL server will be installed or it is the memory being used by SQL server process in task manager of OS.


Is there any limitation of number of clients connecting to SQL Server express edition with advance features?

Microsoft Answer:- Yes, generally SQL Server allows 32,767 concurrent / simultaneous connections, however for your instance you can check by running the @@MAX_CONNECTIONS function. This function would return you the maximum number of connections on that particular instance, however it can be different from the currently configured maximum number of connections on that particular instance so this is configurable (sp_configure) but staying within the maximum connection limit.

Secondly, table with title as “Scalability and Performance” in the above link suggests that there is a limitation of “Maximum memory utilized” as “1 GB” for SQL Server Express edition with advance features.. What is the meaning of this limitation, can you please explain it in more detail? Does this memory refer to the size of memory that can be used in system where SQL server will be installed or it is the memory being used by SQL server process in task manager of OS.

Microsoft Answer:- This is the maximum memory which SQL Server express can use, regardless of the system memory.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: