logo

Thông báo

Icon
Error

Chia sẻ
Tùy chọn
Xem
Xem bài viết cuối
Offline admin  
#1 Đã gửi : 16/05/2019 lúc 01:46:54(UTC)
admin

Danh hiệu: Administration

Chức danh:

Nhóm: Administrators
Gia nhập: 23-07-2013(UTC)
Bài viết: 6,117
Man
Viet Nam
Đến từ: Vietnam

Cảm ơn: 10 lần
Được cảm ơn: 2 lần trong 2 bài viết

If you have experienced this error code 10928: Resource ID: 3 on your Azure SQL Database, that means that you have reached a limit of concurrent logins allowed for that database on that service tier. The error message looks like this:

Msg 10928, Level 20, State 1, Line 1

Resource ID : 1. The request limit for the database is 400 and has been reached. See http://go.microsoft.com/fwlink/?LinkId=267637 for assistance.

Basic tier has a limit of 30 concurrent workers and a limit of 30 concurrent logins. Those limits are extended to 60 if you choose Standard S0 to S3, and if you choose S4 the limit is extended to 400. S6 has a 800 limit.

To better deal with these limits, please read the following article:

How to prevent this issue?

Let's suppose that you have a S2 database. This is a Standard tier database that allows you to have a maximum of 120 users logged in at the same time, according to the table below (numbers valid for June of 2015 at the time of this publication). If you allow your application to try to login the 121st user, then your application will get throttled with this error 10928 Resource ID: 3.

 

Service Tier/Performance Level

DTU

MAX DB Size

Max Concurrent Requests

Max Concurrent Logins

Max Sessions

Benchmark Transaction Rate

Predictability

Basic

5

2 GB

30

30

300

16,600 transactions per hour

Good

Standard/S0

10

250 GB

60

60

600

521 transactions per minute

Better

Standard/S1

20

250 GB

90

90

900

934 transactions per minute

Better

Standard/S2

50

250 GB

120

120

1,200

2,570 transactions per minute

Better

Standard/S3

100

250 GB

200

200

2,400

5,100 transactions per minute

Better

Premium/P1

125

500 GB

200

200

2,400

105 transactions per second

Best

Premium/P2

250

500 GB

400

400

4,800

228 transactions per second

Best

Premium/P3

1000

500 GB

1,600

1,600

19,200

735 transactions per second

Best

Table 1: Current Azure SQL Database Resource Limits in June 2015.

 

Here are a few suggestions for you to prevent that from happening:

-        Migrate the S2 databases to a higher level tier that would serve the purposes of your applications needs of having more than 120 concurrent logins, for example.

-        Develop your own mechanism of governing the access to your databases. Block the Logins that are beyond the maximum capacity of the database you chose. (120 maximum logins in the case of S2s)

-        Treat the exception that your application gets whenever the limits of Logins are reached (error 10928, resource ID 3), and inform the user in a graceful way that there no more available connections at that moment, and then retry to connect in every so many seconds, until there is an available login connection.

-        Increase the service level (i.e. from S2 to S3, or P2) whenever necessary, and decrease it back when the higher number of available logins is not necessary anymore (From a financial standpoint, this should cost you only a few extra cents, or few extra Dollars per hour during these times of extra capacity need)

 

This is not a comprehensive list, and you can come up with many more suggestions, but it is a good way to get started, and to prevent this kind of throttling. 

More resources about this topic:

Azure SQL Database Resource Limits

https://msdn.microsoft.com/en-us/library/azure/dn338081.aspx

Azure SQL Database Service Tiers and Performance Levels

https://msdn.microsoft.com/en-us/library/azure/dn741336.aspx

Source : https://blogs.technet.microsoft.com/latam/2015/06/01/how-to-deal-with-the-limits-of-azure-sql-database-maximum-logins/

Ai đang xem chủ đề này?
OceanSpiders 2.0
Chủ đề tương tự
How to Control Change Requests? (PMP)
Bởi admin 23-08-2019 lúc 11:20:58(UTC)
How to Write a Resignation Letter (Môi trường làm việc)
Bởi admin 22-08-2019 lúc 04:43:42(UTC)
How to Decline a Job Offer (Môi trường làm việc)
Bởi admin 22-08-2019 lúc 04:42:44(UTC)
How to Set Time Limit for Idle Remote Desktop Sessions (Window Server)
Bởi admin 25-12-2018 lúc 12:01:11(UTC)
How to set time limit for disconnected sessions Windows Server 2012R2 (Window Server)
Bởi admin 25-12-2018 lúc 11:49:48(UTC)
How to use session storage in ASP.Net Core? (.NET Core)
Bởi admin 21-11-2018 lúc 11:32:03(UTC)
How to check which .NET Core version is installed? (.NET Core)
Bởi admin 19-11-2018 lúc 04:42:00(UTC)
How to delete a workspace using the tf command (Quản lý dự án trong lập trình)
Bởi admin 31-07-2018 lúc 01:15:17(UTC)
HOW TO GET THE TIME IN HH:MM AM PM FORMAT IN SQL SERVER (SQL Server cơ bản)
Bởi admin 29-08-2017 lúc 03:00:25(UTC)
How to use BundleMinifier? (MVC Web Application)
Bởi admin 04-07-2017 lúc 05:43:18(UTC)
How to Ask for, Grant and Deny Favors (Nghệ thuật ứng xử với sếp)
Bởi admin 27-06-2017 lúc 06:08:09(UTC)
How to convert File to byte[] (Java)
Bởi admin 19-04-2017 lúc 10:56:09(UTC)
How to use SET vs SELECT (SQL Server cơ bản)
Bởi admin 30-11-2016 lúc 09:35:43(UTC)
How To Select Alternate Rows From A Table In SQL Server (SQL Server cơ bản)
Bởi admin 23-11-2016 lúc 05:44:28(UTC)
How to find the duplicate names from the SQL Server table? (SQL Server cơ bản)
Bởi admin 23-11-2016 lúc 11:08:13(UTC)
Di chuyển  
Bạn không thể tạo chủ đề mới trong diễn đàn này.
Bạn không thể trả lời chủ đề trong diễn đàn này.
Bạn không thể xóa bài của bạn trong diễn đàn này.
Bạn không thể sửa bài của bạn trong diễn đàn này.
Bạn không thể tạo bình chọn trong diễn đàn này.
Bạn không thể bỏ phiếu bình chọn trong diễn đàn này.

| Cung cấp bởi YAF.NET 2.2.4.14 | YAF.NET © 2003-2021, Yet Another Forum.NET
Thời gian xử lý trang này hết 0.321 giây.