Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

How to check the logs in report server database?

Asked by Rohit Jhadav Nov 28, 2019 1.8K views 1 answer
Share

Your answer

1 Answer

Prateek Jain JanBask Expert Latest answer

Answered on Nov 9, 2019

Logs in the database can be checked by either tables or pre-defined views. If any developer who has proper level of knowledge about the reporting server db then it’s easier to check the logs via table. However, there is another easy to use the logs. Reporting server Logs are primary execution logs. Reporting server database primarily gets created in the SSRS instance of sql server. You can check information like count of report execution, processing time, output format used most. It also tells specific time set about how much time it took to render and execute the data set query. Please find below query: 

select * from [dbo].[ExecutionLog]


select * from [dbo].[ExecutionLog2]


Was this helpful?

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.