Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

reporting services Expand / Collapse
Author
Message
Posted Tuesday, July 22, 2014 8:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:05 PM
Points: 59, Visits: 109
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
Post #1595115
Posted Wednesday, July 23, 2014 11:02 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 8:56 PM
Points: 3,033, Visits: 2,636
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.



Post #1595793
Posted Thursday, July 24, 2014 6:51 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:05 PM
Points: 59, Visits: 109
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.
Post #1595879
Posted Thursday, July 24, 2014 10:21 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 8:56 PM
Points: 3,033, Visits: 2,636
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) ?



Post #1596078
Posted Friday, July 25, 2014 4:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:21 AM
Points: 2,014, Visits: 3,452
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
Post #1596145
Posted Friday, July 25, 2014 6:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:05 PM
Points: 59, Visits: 109
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
Post #1596188
Posted Friday, July 25, 2014 8:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:21 AM
Points: 2,014, Visits: 3,452
Cheers, that makes sense, but are the sharepoint databases going to remain on the second box?
Same issue if they are?
Post #1596255
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse