- Read Books Online about recovery models and backups.
- Read what Paul Randal has written about it in his blog and in TechNet Magazine.
- Check out Ola Hallengren’s database maintenance solution before you write your own.
Nearly three years ago I wrote about how to query the ReportServer database and see who is running which reports. Since then I’ve made it a bit more focused. Which reports are being used the most? Which users are the busiest and which reports are they looking at? Here’s what I came up with.
(NB: This is for 2008 or 2008 R2 Reporting Services in standalone mode. I’ve no idea what you get in SharePoint mode.)
Which reports are being used the most?
If you click on a report you see…
Who has been using that report?
Report User Heatmap
Who are the busy users?
If you click on a user you see…
Report User History
Which reports has that user has been running?
Feel free to download the RDL files and stored procedures here and use them yourself.