?
Solved

SQL Server Web Traffic Limitations

Posted on 2016-08-16
4
Medium Priority
?
92 Views
Last Modified: 2016-08-30
We use sql server 2012 web on our web server and we time races.  Some races are fairly large and some days we have multiple races going on at a time.  Currently we time the race with software a copy of the db on our local machines and then upload the results to the web.  Occasionally we return an error message during times of high traffic that locks one transaction as the "victim" when uploading data to the web.  Is there a way to minimize this from happening.  I am wondering about some good database design practices or a way to give one transaction priority over others.

I know this is a very vague question but any insight would be much appreciated.  If I get some general responses that I think would apply to our situation I will flesh those out with further questions.
0
Comment
Question by:Bob Schneider
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 51

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 41757887
Occasionally we return an error message during times of high traffic that locks one transaction as the "victim" when uploading data to the web.
This is typically a deadlock behavior.
There are some ways to minimize deadlocks but in your case maybe lower the isolation level would be best thing to do.
0
 

Author Comment

by:Bob Schneider
ID: 41757904
THank you.  I will read those articles.  I may have further questions.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41776484
Bob, do you still need help with this question?
0
 

Author Comment

by:Bob Schneider
ID: 41776620
I haven't had the chance to look at the responses so I will close it out and re-post if questions arise after researching.  Quite honestly, it looks like the posts are what I am looking for.

Thanks so much for the help.
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question