March 15, 2016 at 4:19 am
Forgive me ... I know nothing about SSRS & would appreciate your time:
Background:
2008 R2.
Reports I need will not be overly complex / resource intensive.
I have 20 odd instances of SQL & want basic admin / capacity etc. reports
I don't have a test system, or I'd test instead of bothering you good people!
1. Is RS free? Completely, no matter if it's installed locally / on it's own server etc?
2. With multiple SQL instances, do I need an installation of RS for each? Or can 1 RS serve multiple SQL instances?
3. If it's 1 x RS for multiple, is performance going to be a factor?
3. I have various SQL instances on a cluster of 3 nodes. How do I install RS on a cluster? I know it's not cluster aware, if I install on 1 x node, what will happen when that node is down for a time?
Thanks
March 15, 2016 at 8:13 am
snomadj (3/15/2016)
Forgive me ... I know nothing about SSRS & would appreciate your time:Background:
2008 R2.
Reports I need will not be overly complex / resource intensive.
I have 20 odd instances of SQL & want basic admin / capacity etc. reports
I don't have a test system, or I'd test instead of bothering you good people!
1. Is RS free? Completely, no matter if it's installed locally / on it's own server etc?
It's not free, it's included with the SQL Server license. Technically you're paying for it as much as you're paying for the SQL Server Agent, although SSRS is included in the Express version and the Agent isn't.
2. With multiple SQL instances, do I need an installation of RS for each? Or can 1 RS serve multiple SQL instances?
No, SSRS can connect to any number of sources. It's like saying that you could only connect to a single instance with SSMS.
3. If it's 1 x RS for multiple, is performance going to be a factor?
It's not about multiple sources, but the workload of the server. Queries are done in the different SQL instances, display is prepared on the SSRS instance. Ideally, you'll have different servers for the database engine and the reporting services.
3. I have various SQL instances on a cluster of 3 nodes. How do I install RS on a cluster? I know it's not cluster aware, if I install on 1 x node, what will happen when that node is down for a time?
Thanks
I don't know the answer for the last one, sorry.
March 15, 2016 at 8:17 am
snomadj (3/15/2016)
1. Is RS free? Completely, no matter if it's installed locally / on it's own server etc?2. With multiple SQL instances, do I need an installation of RS for each? Or can 1 RS serve multiple SQL instances?
3. If it's 1 x RS for multiple, is performance going to be a factor?
3. I have various SQL instances on a cluster of 3 nodes. How do I install RS on a cluster? I know it's not cluster aware, if I install on 1 x node, what will happen when that node is down for a time?
1. SSRS is included with your SQL Server licensing -- so it's not free, but it is no additional cost.
2. Yes, you can run SSRS on one server and pull data from all of the other servers/instances if you wish.
3. Performance will depend upon how many users are hitting SSRS and how good/bad your report queries are. I'd suspect from what you describe, it won't be an issue.
3. If the server with SSRS is down, you obviously wouldn't be able to run any reports with that SSRS instance. I don't have cluster background to help more here -- sorry.
I hope this helps,
Rob
March 15, 2016 at 9:17 am
Perfect, thank you both for clear & concise answers! It really helps.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply