patternMinor
Does SSRS lock the table when querying?
Viewed 0 times
ssrsthequeryingdoeswhentablelock
Problem
My senior DBA told me that SQL Query execution by default doesn't lock the table.
I was having some issues with my SQL Server Reporting Services (SSRS) report which seems to be getting some issues with locking and getting some errors.
I did some Googling but fell short of finding anything.
Do SSRS reports lock the tables that are being queried?
Is there any MSDN documentation that document this behavior specifically?
I was having some issues with my SQL Server Reporting Services (SSRS) report which seems to be getting some issues with locking and getting some errors.
I did some Googling but fell short of finding anything.
Do SSRS reports lock the tables that are being queried?
Is there any MSDN documentation that document this behavior specifically?
Solution
Short answer: No
Longer...
SQL Server doesn't know that it is SSRS sending it a query. So the query from SSRS will run like any other query.
It's more likely be that the query optimiser decides to use a table lock for the SSRS query. of course, it could be a different problem, but that's a different question
Longer...
SQL Server doesn't know that it is SSRS sending it a query. So the query from SSRS will run like any other query.
It's more likely be that the query optimiser decides to use a table lock for the SSRS query. of course, it could be a different problem, but that's a different question
Context
StackExchange Database Administrators Q#24091, answer score: 7
Revisions (0)
No revisions yet.