just trying to do an insert of 76700 records to a table
it has been running 20 minutes now
I did in sp_who2 do not see any blocks
if I do a select count(id) from name with (nolock) it shows 76700 yet the query is still running
I'm confused
are there some settings I should be looking at ?
SQL
Last Comment
Tomas Helgi Johannsson
8/22/2022 - Mon
ste5an
Well, do you read the rows (not records) from a view or a table? How long does your test query runs without the NOLOCK hint? Open perfmon and take a look at the disk IO. Also open the Activity Monitor in SSMS to see wait is happening live.