SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


reporting services


reporting services

Author
Message
tcronin 95651
tcronin 95651
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1456 Visits: 593
I have two reporting services environments. First one is a native running on the same sql 2008r2 box using the 2008r2 box for it's backend. The box is a monster 256 gig or RAM and 64 core. The other box I have is a 2008 server running reporting server on same box as SQL Server backend also hosting Sharepoint. The share point is 2007 and this reporing server is running sharepoint integrated mode. For licensing reasons I was going to move the 2nd instance of reporting server (2008 version), which is lightly used and move it to the same box as a 2nd instance and governor it (all of this is enterprise edition). Does this seem feasible. From a performance standpoint I can stand up the 2nd instance pretty easily without impact. More of and issue of sharepoint configuration time than anything.
THanks
happycat59
happycat59
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8479 Visits: 3281
tcronin 95651 (7/22/2014)
I have two reporting services environments. First one is a native running on the same sql 2008r2 box using the 2008r2 box for it's backend. The box is a monster 256 gig or RAM and 64 core. The other box I have is a 2008 server running reporting server on same box as SQL Server backend also hosting Sharepoint. The share point is 2007 and this reporing server is running sharepoint integrated mode. For licensing reasons I was going to move the 2nd instance of reporting server (2008 version), which is lightly used and move it to the same box as a 2nd instance and governor it (all of this is enterprise edition). Does this seem feasible. From a performance standpoint I can stand up the 2nd instance pretty easily without impact. More of and issue of sharepoint configuration time than anything.
THanks


from a licensing perspective, I do not think that what you are planning will actually change anything unless you are planning to completely remove SSRS from the SharePoint server. That assumes that the configuration and content databases for SharePoint 2007 are on the SharePoint server.

This also assumes that you are "happy" that the new instance of SSRS does not need to be integrated with SharePoint.



tcronin 95651
tcronin 95651
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1456 Visits: 593
the intention was to remove the reporting server from the sharepoint box entirely and have this on the second instance. I get sharepoint integrated is better, but not my choice. This is right now a way to address licensing issue they have.
happycat59
happycat59
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8479 Visits: 3281
tcronin 95651 (7/24/2014)
the intention was to remove the reporting server from the sharepoint box entirely and have this on the second instance. I get sharepoint integrated is better, but not my choice. This is right now a way to address licensing issue they have.


Are there any other bits of SQL Server installed onto the SharePoint server (e.g. the RDBMS for SP config/content database) ?



Gazareth
Gazareth
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7586 Visits: 6045
Note you can't use resource governor on the reporting service itself, only connections to the database.
So report rendering/processing etc will be ungoverned.
It's also not instance aware so you might not get the results you expect.

If possible, I'd create a VM on the big host server and install reporting services on that. At least you can limit the CPU then.

Of course, if it's only lightly used then probably not an issue :-)

Like happycat, I can't see how this fixes a licensing issue if SQL remains on the second box.

Cheers
Gaz
tcronin 95651
tcronin 95651
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1456 Visits: 593
The new box is proc licensed, the one I am moving from is CA licensed and with Sharepoint hitting the reporting server on that box MS says have to have a SQL license for every user. Make 2nd instance on new box that issue goes away due to proc license
Gazareth
Gazareth
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7586 Visits: 6045
Cheers, that makes sense, but are the sharepoint databases going to remain on the second box?
Same issue if they are?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search