General information
Forum:
Microsoft SQL Server
Title:
INSERT statements hang/timeout
Hey all,
Our imaging database decided to stop taking data yesterday.
INSERT statements (run directly from Query Analyzer on the server itself) run and run and never complete (I assume that is because Query Analyzer just doesn't have a default timeout set).
We can run SELECT statements on the same tables that disallow INSERTS.
We can run UPDATE statement on the same tables that disallow INSERTS.
Two tables in the database DO allow INSERTs. I have no idea why.
We rebooted the SQL Server machine. No effect.
Great. Now I just found out that after a loooooong time (like 20 minutes), INSERTs went through, and now all the tables are accepting INSERTs (at least from Query Analyzer). Is this some sort of crazy locking issue? What sp_ magic can I use to see what is going on? Has anyone else seen this type of INSERT slowdown?
I appreciate any thoughts on this matter.
Thanks!
JoeK
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only