Link to home
Start Free TrialLog in
Avatar of johnnyg123
johnnyg123Flag for United States of America

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 ?
Avatar of ste5an
Flag of Germany image

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.
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial