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

Considerations for location of Reporting Services databases Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 3:30 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:24 AM
Points: 2,351, Visits: 2,700
Hello experts,

I'm working on designing a SQL Server 2008 R2 Reporting Services (SSRS) topology, and a couple of my colleagues asked to see if SSRS can have its databases installed remotely, that is, separately from the other SSRS components. It looks like this is possible, but the question was also raised as to whether we could install it on our main OLTP db server.

1. My instinct tells me that this wouldn't be advisable for performance reasons, but is this feasible depending on the expected load for the SSRS installation?

2. Also, does it cost more in licenses to have SSRS host its own databases, or is the cost of an SSRS database instance for the ReportServer and ReportServerTempDB databases included in the license for the main OLTP db server that doesn't have SSRS on it? For example, according to this page, scaling out SSRS seems to increase the cost dramatically.
http://www.networkworld.com/community/node/43349

3. That same article also suggests that it is best to separate the web server for SSRS as well, meaning at least one more server for that component. Is this really the necessary best practice across the board, or can it depend on the size of the expected user base of SSRS users (in our case, something like 20-30 users)?

Thanks for any help - I am in the middle of reading up on the related documents myself (for example here technet.microsoft.com/en-us/library/ms157293(v=sql.105).aspx and here http://technet.microsoft.com/en-us/library/cc966418.aspx), but thought I would put this question out there in case someone happens to provide information while I'm researching.

Thanks again.

- webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1497058
Posted Monday, September 23, 2013 2:10 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: Friday, August 8, 2014 1:35 PM
Points: 3,475, Visits: 580
Hi Webrunner,

I like your joke about SQL Server Query in a bar.

As you say you have 20 to 30 users and probably guessing no more than 5 people will run reports at the same time, no need to separate anything. Yes, you will need extra licensing for scaled out deployment and you will need extra servers for SSRS web and SSRS DB and also check SQL Server editions that allow distributed deployment. You may be running a lower edition.

Performance consideration: depends on SQL load and Network load, what is busier.

Security Consideration: if all your 30 users are inside the company FW and you set up SSRS permissions correctly and your SQL Server is secured, and the server is not exposed to Internet or DMZ, i think you will be OK (the disclamer here- not responsible if something happens...)



Regards,
Yelena Varshal

Post #1497546
Posted Friday, September 27, 2013 8:41 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:24 AM
Points: 2,351, Visits: 2,700
Thanks for your reply!

I have one additional question - is it necessary to run Enterprise Edition for a report server of smaller scale, or would SQL Server 2008 R2 Standard Edition suffice? If this is not a simple answer, do you at least know the features and other variables to consider?

Thanks again,
webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1499432
Posted Friday, September 27, 2013 9:23 AM
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: Friday, August 8, 2014 1:35 PM
Points: 3,475, Visits: 580
Hi,

yes, you can run SSRS on Standard edition.
Please review comparing features by edition

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx/css

Features Supported by the Editions of SQL Server 2008 R2
and scroll down to the Reporting section. I think even the web edition supports it.

This article also allow you to navigate to other versions, use the dropdown right below the article title.

Yelena




Regards,
Yelena Varshal

Post #1499461
Posted Friday, September 27, 2013 9:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:24 AM
Points: 2,351, Visits: 2,700
Yelena Varshal (9/27/2013)
Hi,

yes, you can run SSRS on Standard edition.
Please review comparing features by edition

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx/css

Features Supported by the Editions of SQL Server 2008 R2
and scroll down to the Reporting section. I think even the web edition supports it.

This article also allow you to navigate to other versions, use the dropdown right below the article title.

Yelena



Thank you, Yelena, for your reply.

webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1499467
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse