Does Reporting Services lock tables? Possible Duplicate:
  Does SSRS lock the table when querying?  




I'm using SQL Server 2008 R2 and Reporting Services. Do the reports block other queries or are they executed in highly isolated transactions, such as a snapshot? 

Next obvious question: Can reporting services produce deadlocks or timeouts in other queries as a result of locking tables for a long time?
FYI, unless specifically directed, all TSQL statements are presumed Snap-Shots.

1st Question:


So Think of it as your SSRS is looking at your data as if it were a View/Select statement.


2nd Question:


It could, pending on the volume of calculation (SSRS) and volume of users.  Think you would have to have well over 10% CPU/RAM utilization from SSRS and over 50% CPU/RAM utilization from general queries in order for you to notice an effect, albeit hardly noticeable (like 1-10 nSecs).