asked on insert records to local sql instance hanging
I have installed a local instance of sql 2014
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 ?
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
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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.