May 13, 2014 at 9:36 am
We are in the proof of concept phase of rolling out Reporting Services to our company. We hope to deploy RS on a win2012/ SQL2012 Enterprise cluster using scale out deployment across the two nodes. These nodes currently have instances running SharePoint and BizTalk, and there are no performance problems since the hardware is new and a bit of overkill for our environment. Our ERP system resides on a separate Oracle RAC so we will be accessing Oracle data. I have a few questions for anyone that has done or works with something similar.
1. What Should I be monitoring and will there be much extra load on the cluster?
2. What are others doing as far as authentication goes?
3. Is there a way in RS to gather usage stats for example how many times a report has been accessed?
4. What things have you seen that have come up that I may not be thinking about?
May 13, 2014 at 1:20 pm
I can only answer #3. The ReportServer database has a view, ExecutionLog3, that has tracks report calls. You'd have to do the aggregation yourself. Here's a good blog post about it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 22, 2014 at 12:22 pm
Thanks for the idea on the view, this will be very helpful. Any one else have any input?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply