Avatar of johnnyg123
johnnyg123
Flag 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 ?
SQL

Avatar of undefined
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.
ASKER CERTIFIED SOLUTION
Tomas Helgi Johannsson

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck