Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
