I don’t have the details but know of several instances where folks are using vanilla SQL Replication and pointing their reporting app server(s) against that read only replicated instance.
This takes the load off - especially folks who do a lot of reports.
I know we had a practice inside of Professional Services at one time for this - not sure state of the art currently.
Wow, that’s a big install! I would check your SQL performance but you would probably get better performance scaling up rather than out. We are looking at redoing our architecture and the sweet spot seems to be around a single DB server, three app servers with task agents, and a dedicated SSRS server.
Currently we are only running a single task agent. I know we can have up to 3. Anything special we need to do if we have 3 task agents running other then installing and configuring them? Is there a best practice?
From my experience, so your mileage may vary, but nothing special is required. We created two new app servers on two new servers and installed and configured the Task Agents. They poll the db to see if there are any tasks to process, and if so, it is passed to IIS to process. You can monitor the Ice.SysRptLst to see which server processed which task and I believe the processing duration.
SELECT HostComputer, RptDescription, COUNT(SysTaskNum) AS Reports, AVG(DATEDIFF(s,CreatedOn,LastActionOn)) AS AvgDuration FROM Ice.SysRptLst GROUP BY HostComputer, RptDescription
There is a lot more information on this thread as well: