Solved

SQL Server Web Traffic Limitations

Posted on 2016-08-16
4
72 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
  • 2
  • 2
4 Comments
 
LVL 49

Accepted Solution

by:
Vitor Montalvão earned 500 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 49

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query Task 11 43
VB script help 23 32
SQL Session Remains Open After ReportViewerControl Form is Closed. 8 33
T-SQL: I need to add an index on a field 5 25
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

749 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