troubleshooting Question

Occasionally Simple insert timeout with record inserted and update takes 10+ seconds on a table, rest of the times both operation takes less than 1 second.

Avatar of Maven 0001
Maven 0001 asked on
Microsoft SQL Server
63 Comments4 Solutions601 ViewsLast Modified:
As mentioned above i have situation where a simple inserts timeout. The table has 500000 records and inserts/update via procedure.

Insert is like

insert into table1
(column1,column2,entrydate,updatedate,status)
('','',getdate(),getdate(),'active')
Above statement times out.

update table table1
set column1=''
where column2='XYZ'
Above statements timesout or takes time between 5-25 seconds

Strange thing it works well for 98% of the time less than second.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 4 Answers and 63 Comments.
Start Free Trial
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 4 Answers and 63 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