Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments
Solved
ASP Error Message
Posted on 2012-12-21
I have a custom error message page that emails me when an error is encountered by a visitor. I am receiving following error message on some of the pages on my site, although to my knowledge it is not crashing the page for the end user??? Is that possible and how do I fix it?
[Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Thanks!!
[Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Thanks!!
[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
4 Comments
Active today
It sounds like multiple inserts are going on at the same time.
Does your database take a long time to do what it needs to do or do you have a bunch of loops or extracting more data fields then you need? I just gave a response to somebody else about using getrows instead of do until rs.eof.
if not rs.eof then
MyArray=rs.getrows()
end if
'close database
' now loop through the array
anything you can do to make it run faster especially if you are on a shared servicer or server with low memory/cpu.
Does your database take a long time to do what it needs to do or do you have a bunch of loops or extracting more data fields then you need? I just gave a response to somebody else about using getrows instead of do until rs.eof.
if not rs.eof then
MyArray=rs.getrows()
end if
'close database
' now loop through the array
anything you can do to make it run faster especially if you are on a shared servicer or server with low memory/cpu.
You can do the following to avoid deadlocks and locks on tables:
1) Replace Cursors with While Loops in SQL Server
2) Replace Temp Tables with Table Variables in Stored Procedures in SQL Server
1) Replace Cursors with While Loops in SQL Server
2) Replace Temp Tables with Table Variables in Stored Procedures in SQL Server
Active 7 days ago
Padas, that was me that you gave the advice to. I will try to implement that here. Wasn't sure that the same solution would prevent this issue from happening.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:
ht…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"!
Step 1: Open a new google tab
Step 2: Go to the left hand upper corn…
Suggested Courses
Course of the Month10 days, 19 hours left to enroll
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.