SSRS: Use single transaction when processing the queries

Question 1: In SSRS report, What is the functionality behind the check box displaying 
"Use single transaction when processing the queries" in data source properties?
(Follow the below screen shot for your reference)



















Answer: This option will be useful if any report is using more than one data set under common datasource. By checking this option we can reduce the network traffic. If this option is checked then all datasets under a report will use same open connection to hit the database. 

Example - If any report is using more than one datasets under a common data source along with checked box "Use single transaction when processing the queries".
So only one connection will maintain for all data set.

In the other hand if same option is unchecked then all data sets will open separate connections to hit the database.

 Please share your comments if this post is useful.


Post a Comment

4 Comments

  1. Thanks for such a helpful information.

    ReplyDelete
  2. Excellent and really helpfull explanation.
    Thank you.

    ReplyDelete
  3. Wonderful explanation, i think it will help performance improvement.

    ReplyDelete