How to find solution when 200 user access site and call a store at the same time made SQL Server Azure dieSQL Server query to find all permissions/access for all users in a databaseNew Azure SQL Database Services, how scalable and what are DTUsAzure SQL server max pool size was reached errorAzure SQL - DTU CPU usage disparitySQL Azure DTUs at 100% troubleshootIndex rebuild freezes database even with online=onHow can I find out why azure SQL Database is restarting/resetting periodically?Azure DTUs for a medium size applicationUmbraco admin panel slowdown with azure basic database plan and website performs too slow“Login failed for user ''.” SqlException when accessing Azure SQL DB via MSI with a EF code-first implementation
What kind of environment would favor hermaphroditism in a sentient species over regular, old sexes?
What do astronauts do with their trash on the ISS?
What would a Dragon have to exhale to cause rain?
How can I make dummy text (like lipsum) grey?
Who is frowning in the sentence "Daisy looked at Tom frowning"?
Would life always name the light from their sun "white"
How could it be that 80% of townspeople were farmers during the Edo period in Japan?
Was the dragon prowess intentionally downplayed in S08E04?
Does a non-singular matrix have a large minor with disjoint rows and columns and full rank?
Cuban Primes
What are the effects of eating many berries from the Goodberry spell per day?
A latin word for "area of interest"
I recently started my machine learning PhD and I have absolutely no idea what I'm doing
Why use a retrograde orbit?
Why aren't satellites disintegrated even though they orbit earth within their Roche Limits?
Divisor Rich and Poor Numbers
Why do galaxies collide?
Would a "ring language" be possible?
What color to choose as "danger" if the main color of my app is red
Pedaling at different gear ratios on flat terrain: what's the point?
Why does the U.S military use mercenaries?
Capital gains on stocks sold to take initial investment off the table
Why is Drogon so much better in battle than Rhaegal and Viserion?
Do high-wing aircraft represent more difficult engineering challenges than low-wing aircraft?
How to find solution when 200 user access site and call a store at the same time made SQL Server Azure die
SQL Server query to find all permissions/access for all users in a databaseNew Azure SQL Database Services, how scalable and what are DTUsAzure SQL server max pool size was reached errorAzure SQL - DTU CPU usage disparitySQL Azure DTUs at 100% troubleshootIndex rebuild freezes database even with online=onHow can I find out why azure SQL Database is restarting/resetting periodically?Azure DTUs for a medium size applicationUmbraco admin panel slowdown with azure basic database plan and website performs too slow“Login failed for user ''.” SqlException when accessing Azure SQL DB via MSI with a EF code-first implementation
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have a store to get a list of something in system. To get information by business requirement, this store selects data from 20 tables in a database and makes some complex calculations.
I tuned this store, it run very fast about 0.4s for a user, max output result is 160 thousand records. But when test with more than 200 user access at the same time made database down, it spend 80%-100% resource of database.
My database is SQL Azure using max allowed resourced from Microsoft (24 vcore, 3k DTU, database size IS around 30G).
If anyone is an expert in this areas, please suggest a solution to solve these issues, my system is a web app allowing users around the world access. My team also is tuning from app as using catching, sharing between app and database.
sql-server 
azure-sql-database edited Mar 23 at 17:40
marc_s
589k13111281277
asked Mar 23 at 16:10
thanh lethanh le
1
add a comment |
I have a store to get a list of something in system. To get information by business requirement, this store selects data from 20 tables in a database and makes some complex calculations.
I tuned this store, it run very fast about 0.4s for a user, max output result is 160 thousand records. But when test with more than 200 user access at the same time made database down, it spend 80%-100% resource of database.
My database is SQL Azure using max allowed resourced from Microsoft (24 vcore, 3k DTU, database size IS around 30G).
If anyone is an expert in this areas, please suggest a solution to solve these issues, my system is a web app allowing users around the world access. My team also is tuning from app as using catching, sharing between app and database.
sql-server azure-sql-database edited Mar 23 at 17:40
marc_s
589k13111281277
asked Mar 23 at 16:10
thanh lethanh le
1
1
How do you expect advice without providing DDL, sample data, and the stored procedure code?
– SQLRaptor
Mar 23 at 16:25
The execution plan might help too. Assuming the query is purely CPU bound and it takes .4s to run a single query, you won't be able to run more than 9.6 per second with 24 vcores and less if it's a parallel query. Caching is likely at least part of the solution.
– Dan Guzman
Mar 23 at 22:29
Hi, if my answer helps you, could you please accept it?Thanks and have a good day.
– Leon Yue
Mar 27 at 9:12
add a comment |
I have a store to get a list of something in system. To get information by business requirement, this store selects data from 20 tables in a database and makes some complex calculations.
I tuned this store, it run very fast about 0.4s for a user, max output result is 160 thousand records. But when test with more than 200 user access at the same time made database down, it spend 80%-100% resource of database.
My database is SQL Azure using max allowed resourced from Microsoft (24 vcore, 3k DTU, database size IS around 30G).
If anyone is an expert in this areas, please suggest a solution to solve these issues, my system is a web app allowing users around the world access. My team also is tuning from app as using catching, sharing between app and database.
sql-server azure-sql-database edited Mar 23 at 17:40
marc_s
589k13111281277
asked Mar 23 at 16:10
thanh lethanh le
1
I have a store to get a list of something in system. To get information by business requirement, this store selects data from 20 tables in a database and makes some complex calculations.
I tuned this store, it run very fast about 0.4s for a user, max output result is 160 thousand records. But when test with more than 200 user access at the same time made database down, it spend 80%-100% resource of database.
My database is SQL Azure using max allowed resourced from Microsoft (24 vcore, 3k DTU, database size IS around 30G).
If anyone is an expert in this areas, please suggest a solution to solve these issues, my system is a web app allowing users around the world access. My team also is tuning from app as using catching, sharing between app and database.
sql-server azure-sql-database sql-server azure-sql-database edited Mar 23 at 17:40
marc_s
589k13111281277
asked Mar 23 at 16:10
thanh lethanh le
1
edited Mar 23 at 17:40
marc_s
589k13111281277
asked Mar 23 at 16:10
thanh lethanh le
1
edited Mar 23 at 17:40
marc_s
589k13111281277
edited Mar 23 at 17:40
marc_s
589k13111281277
edited Mar 23 at 17:40
marc_s
589k13111281277
589k13111281277
asked Mar 23 at 16:10
thanh lethanh le
1
asked Mar 23 at 16:10
thanh lethanh le
1
asked Mar 23 at 16:10
thanh lethanh le
1
1
1
How do you expect advice without providing DDL, sample data, and the stored procedure code?
– SQLRaptor
Mar 23 at 16:25
The execution plan might help too. Assuming the query is purely CPU bound and it takes .4s to run a single query, you won't be able to run more than 9.6 per second with 24 vcores and less if it's a parallel query. Caching is likely at least part of the solution.
– Dan Guzman
Mar 23 at 22:29
Hi, if my answer helps you, could you please accept it?Thanks and have a good day.
– Leon Yue
Mar 27 at 9:12
add a comment |
1
How do you expect advice without providing DDL, sample data, and the stored procedure code?
– SQLRaptor
Mar 23 at 16:25
The execution plan might help too. Assuming the query is purely CPU bound and it takes .4s to run a single query, you won't be able to run more than 9.6 per second with 24 vcores and less if it's a parallel query. Caching is likely at least part of the solution.
– Dan Guzman
Mar 23 at 22:29
Hi, if my answer helps you, could you please accept it?Thanks and have a good day.
– Leon Yue
Mar 27 at 9:12
1
1
How do you expect advice without providing DDL, sample data, and the stored procedure code?
– SQLRaptor
Mar 23 at 16:25
How do you expect advice without providing DDL, sample data, and the stored procedure code?
– SQLRaptor
Mar 23 at 16:25
The execution plan might help too. Assuming the query is purely CPU bound and it takes .4s to run a single query, you won't be able to run more than 9.6 per second with 24 vcores and less if it's a parallel query. Caching is likely at least part of the solution.
– Dan Guzman
Mar 23 at 22:29
The execution plan might help too. Assuming the query is purely CPU bound and it takes .4s to run a single query, you won't be able to run more than 9.6 per second with 24 vcores and less if it's a parallel query. Caching is likely at least part of the solution.
– Dan Guzman
Mar 23 at 22:29
Hi, if my answer helps you, could you please accept it?Thanks and have a good day.
– Leon Yue
Mar 27 at 9:12
Hi, if my answer helps you, could you please accept it?Thanks and have a good day.
– Leon Yue
Mar 27 at 9:12
add a comment |
1 Answer
1
active
oldest
votes
I think you can use Intelligent Insights to troubleshoot Azure SQL Database performance issues.
Intelligent Insights automatically detects performance issues with SQL Database and Managed Instance databases based on query execution wait times, errors, or time-outs. It outputs detected performance patterns to the diagnostics log.
As you said,when test with more than 200 user access at the same time made database down, it spend 80%-100% resource of database. You can follow this tutorial , maybe can help you solve and optimize Azure SQL database performance issue.
Hope this helps.
answered Mar 25 at 1:58
Leon YueLeon Yue
862114
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55315729%2fhow-to-find-solution-when-200-user-access-site-and-call-a-store-at-the-same-time%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I think you can use Intelligent Insights to troubleshoot Azure SQL Database performance issues.
Intelligent Insights automatically detects performance issues with SQL Database and Managed Instance databases based on query execution wait times, errors, or time-outs. It outputs detected performance patterns to the diagnostics log.
As you said,when test with more than 200 user access at the same time made database down, it spend 80%-100% resource of database. You can follow this tutorial , maybe can help you solve and optimize Azure SQL database performance issue.
Hope this helps.
answered Mar 25 at 1:58
Leon YueLeon Yue
862114
add a comment |
I think you can use Intelligent Insights to troubleshoot Azure SQL Database performance issues.
Intelligent Insights automatically detects performance issues with SQL Database and Managed Instance databases based on query execution wait times, errors, or time-outs. It outputs detected performance patterns to the diagnostics log.
As you said,when test with more than 200 user access at the same time made database down, it spend 80%-100% resource of database. You can follow this tutorial , maybe can help you solve and optimize Azure SQL database performance issue.
Hope this helps.
answered Mar 25 at 1:58
Leon YueLeon Yue
862114
add a comment |
I think you can use Intelligent Insights to troubleshoot Azure SQL Database performance issues.
Intelligent Insights automatically detects performance issues with SQL Database and Managed Instance databases based on query execution wait times, errors, or time-outs. It outputs detected performance patterns to the diagnostics log.
As you said,when test with more than 200 user access at the same time made database down, it spend 80%-100% resource of database. You can follow this tutorial , maybe can help you solve and optimize Azure SQL database performance issue.
Hope this helps.
answered Mar 25 at 1:58
Leon YueLeon Yue
862114
I think you can use Intelligent Insights to troubleshoot Azure SQL Database performance issues.
Intelligent Insights automatically detects performance issues with SQL Database and Managed Instance databases based on query execution wait times, errors, or time-outs. It outputs detected performance patterns to the diagnostics log.
As you said,when test with more than 200 user access at the same time made database down, it spend 80%-100% resource of database. You can follow this tutorial , maybe can help you solve and optimize Azure SQL database performance issue.
Hope this helps.
answered Mar 25 at 1:58
Leon YueLeon Yue
862114
answered Mar 25 at 1:58
Leon YueLeon Yue
862114
answered Mar 25 at 1:58
Leon YueLeon Yue
862114
answered Mar 25 at 1:58
Leon YueLeon Yue
862114
862114
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55315729%2fhow-to-find-solution-when-200-user-access-site-and-call-a-store-at-the-same-time%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
How do you expect advice without providing DDL, sample data, and the stored procedure code?
– SQLRaptor
Mar 23 at 16:25
The execution plan might help too. Assuming the query is purely CPU bound and it takes .4s to run a single query, you won't be able to run more than 9.6 per second with 24 vcores and less if it's a parallel query. Caching is likely at least part of the solution.
– Dan Guzman
Mar 23 at 22:29
Hi, if my answer helps you, could you please accept it?Thanks and have a good day.
– Leon Yue
Mar 27 at 9:12