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.
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 (https://technet.microsoft.com/en-us/library/ms177433(v=sql.105).aspx)
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.
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…
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.