<div>
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.
</div>


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.

johnnyg123

<div>
<div class="content wysiwyg-content">
I have installed a local instance of sql 2014 <br />
<br />
just trying to do an insert of 76700 records to a table <br />
<br />
it has been running 20 minutes now<br />
<br />
I did in sp_who2 &nbsp;do not see any blocks<br />
<br />
if I do a &nbsp;select count(id) from name with (nolock) &nbsp;it shows 76700 &nbsp; yet the query is still running<br />
<br />
I'm confused<br />
<br />
are there some settings I should be looking at ?
</div>
</div>


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 ?

insert records to local sql instance hanging

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.