Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Can select statements cause blocking

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2014-06-06 : 05:49:52
Hi all,

If I have 2 or more process performing a SELECT on the same data can this cause blocking?

AQs far as I know you only get blocking when one process is doing a write and another is doing a read/write on the same data.

Thanks

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2014-06-06 : 07:04:30
maybe this is helpful:
http://stackoverflow.com/questions/1017177/sql-server-select-statements-causing-blocking


Too old to Rock'n'Roll too young to die.
Go to Top of Page
   

- Advertisement -