• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 106
  • Last Modified:

SQL Server Web Traffic Limitations

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
Bob Schneider
Asked:
Bob Schneider
  • 2
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Bob SchneiderCo-OwnerAuthor Commented:
THank you.  I will read those articles.  I may have further questions.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Bob, do you still need help with this question?
0
 
Bob SchneiderCo-OwnerAuthor Commented:
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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now