All geek questions in one place

Number of concurrent Sql server connections

I am creating a .net application with the Sql SQL server engine. I would like my site to be accessible to thousands of users per second. What is the number of connections calculated for? How many connections can IIS and Sql Server make?

+3
source share
4 answers

First, there is a difference between connections and connection pools. Is it good to look into this, since it is of great importance in performance. If you need a link, I can dig it out, but google / bing is your friend here. The key conclusion is: the minimum number of connection pools.

With that said, the number of connections depends on two things.

  • Windows Auth? , /

  • SQL Auth, ( ).

, IIS, SQL Server . , , , .

+3

, . IIS, SQL, .

+1

Windows SQL Server:

Windows is configured by default to handle tcpip concurrent connections from 1000 to 2000. For SQL Server, it will also depend on licenses and / or hardware that you did not specify. What equipment works in SQL?

0
source

You can set the limit yourself or find out what limit is already set in the IIS server settings.

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/b2b550de-f655-4fb6-9bed-dfc9583b6700.mspx?mfr=true

0
source

Source: https://habr.com/ru/post/1755524/

More articles:


All Articles