Maximum size, connection limit and which version of SQL Server should I use in my desktop application

Asked

Viewed 751 times

-1

I am developing a system and I am using SQL Server 2014 database, but free. Which version can I use so that I don’t limit my bank’s resources when I reach a larger size or exceed a number of connections?

sql-server

2 answers

3


Limit every database has, SQL Server with fewer limitations is Enterprise (very expensive), and Standard solves most cases well. Of course if you need Enterprise resources you will probably already be a very experienced DBA and this information is irrelevant.

In some cases it might be good to use the web edition or even Azure (cloud subscription) and pay for what you use effectively.

When you need to solve questions so you can always refer to the product page that has everything.

There’s a page with comparison between different editions of SQL Server.

  • 1

    The maximum limitation of open connections in SQL Server is 32k. If you are doing something much wrong, arrives at that value long before it is really necessary to do the Shard. Own experience... Oh, I don’t know what version used in the work, but I didn’t find anything in sources indicating a higher value. Maybe in other editions it has a lower maximum value, but it really seems that this 32k is a hard limit

  • After 10k, it sinks so deep that I find it impractical in qq hw.

0

When you are developing a solution (or an application), you should take into account a few points:

  1. How many users will make simultaneous use of the Database
  2. What is the volume (in MB/GB) of information that will be hosted after X time (preferably year(s))

Particularly, I believe these points are critical to know which editions and/or versions of SQL Server are suitable for your solution.

Tip: always choose to use the latest versions. They support everything the previous ones support with the addition of having new features.

For simpler solutions where data competition is relatively low (small shops, site with few visits) SQL Server Express responds very well. It comes with 10GB, maximum consumption of 1GB RAM per BD and accepts up to 5 simultaneous connections with your server. It is true that today’s applications use connections in which they open, perform the necessary querys and close the connection again, all very fast.

More complex scenarios than these, I recommend SQL Server Standard.

Browser other questions tagged sql-server

You are not signed in. Login or sign up in order to post.