Announcements
No record found.
Dear All,
Can you please let me know the use of database "ReportServerTempDB".
Please give me an example.
Please give me more shed on this.
Thanks!
Regards,
Arpan
*This post is locked for comments
You could simply Google this stuff sometime. I think you would find the answer to that question quite easily.
Thanks Brandon,
I find in Google already but not understand . So, I am asking the exact use of Reportserver_Tempdb.
Hi @rp@n
you can check this link
docs.microsoft.com/.../report-server-database-ssrs-native-mode
also here the difference between ReportServerTempDB and ReportServer databases
www.wattpad.com/14232885-what-is-difference-between-reportserver-and
Thanks Hakim,
As I understand ReportServer_TempDB is used for good performance.
Can you please give me an real example if I run any report then how ReportServer_Temp
db is work?
this database store temporary information about reporting services information,
if you access sessiondata table, you will find more details
, for example , if you open this table before run any report , you will find it empty
if you run a report , you will find record insrted about this report for this report with details like owner and report path...etc
Thanks Hakim
So, any report like
With Regular Table,
TempDB or
In Memory
These all kind of reports are stored in SessionData table ?
for the query report and RDP report, I found the two reports inserted in SessionData table
So, ReportServerTemoDB used only RDP and Query based report. Because it's stored in SessionData table.
I am talking about this types query and tempDB(that we use it),
but other types, I don't know the behavior
try to use in memory table and check the sessiondata table
Sure, I will check.
One things only if SessionData table stored session means it's hit ReportServerTempDB ?
It might be Query, RDP or InMemory.
Is't correct?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
