Solved

SQL 2008 Report Server Best Practice

Posted on 2010-11-10
2
338 Views
Last Modified: 2012-05-10
What is Microsoft Recommodations for : keeping sql server report services and database engine installed on the same box. - For SQL 2008.
For SQL 2005 it was recommended that these two components should be installed on separate servers, Does the same recommodation still apply for SQL 2008?
0
Comment
Question by:Wizilling
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
sammySeltzer earned 250 total points
ID: 34107764
Always good idea to keep both separate.

For your satisfaction, please read:

http://stackoverflow.com/questions/190512/sql-server-separate-database-for-reports
0
 
LVL 4

Assisted Solution

by:MSSystems
MSSystems earned 250 total points
ID: 34114737
Yes, I think it is always a good idea to separate the two. However I am assuming that you are not going to report on millions of records. Otherwise you would not have asked this question.
If I am right you can host them on the same server. However I would have created a separate database just for reports. This gives you some flexibility. For example: you can put the database in a read only state. This helps a lot with performance and deadlocks.
If you want to chat more, let me know. Otherwise I apologise for the assumption.
0

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query help 15 68
Parsing this XML works but the other one doesn't 9 36
Many to one in one row 2 48
T-SQL: How to append a column for serialized JSON data? 2 51
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question