Very slow Delete from table with large BLOB data

Question

Very slow Delete from table with large BLOB data

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 1

With that small number of rows and rows-to-delete, I am guessing you were simply blocked. Run sp_who2 active while you are trying to do the delete to see who is blocking your delete action. If it isn't blocking then there is something REALLY wrong with your server. I could store/delete that much data on my cell phone in near real-time. 🙂

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Ed B Hall of Fame Points: 3669 More actions · Answer 2

How is data continually pumped in to this table if it only has 200 rows?

NabeelM SSC-Addicted Points: 448 More actions · Answer 3

Those 200 rows are just for sample data I am testing with. So I run a process that adds data and then clean up previously added data. We are expecting thousands of rows per day.