troubleshooting Question

How to fix a slow running update statement

Avatar of stressfreewebs
stressfreewebs asked on
Microsoft SQL ServerASPWindows Server 2008
16 Comments2 Solutions3855 ViewsLast Modified:
Hi Experts,

I have an e-mail table which has reached around 90,000 records. This is running on MSSQL server, and has a size of 1.5GB.

A script is hanging, and after a lot of response.write / response.flush statements through the ASP document, I have isolated the exact line which it is timing out on.

UPDATE EMails SET eProcessedDate = '2013-09-09 14:58:53', eProcessedBy = 0, eAutoIndex = 1, eStatus = 2 , eContract = 122 WHERE eId = 89611

eProcessedDate is a datetime field
All the others are integers

I can't work out why such a simple statement would hang.

Can anyone advise steps to optimise the table, or to diagnose why it is hanging?

Thanks!
Dan
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 16 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros