Performance

Last Post 20 Jul 2005 12:28 PM by FredGiotti. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
FredGiotti
New Member
New Member

--
18 Jul 2005 04:03 AM
Is there any performance concerns if I install the reporting services databases on the same server where my OLTP databases live. I have noticed the RS lays down numerous SQL Agent jobs for its reports.

Thanks
FredGiotti
New Member
New Member

--
18 Jul 2005 08:39 AM
Are you recomending to isolate RS's two databases and the associated user databases? Or just the RS databaseses? Can you tell me how resource intensive RS is? I am new to RS so please excuse my lack of knowledge.
FredGiotti
New Member
New Member

--
18 Jul 2005 10:42 AM
Hi RM,

Are there any documention detailing performance? I need some proof to present to management on why to isolate it from my OLTP server.
FredGiotti
New Member
New Member

--
19 Jul 2005 11:14 AM
Can I ask you this, RM? If they came to you to install RS on your OLTP server what would your response be?

Thanks.
FredGiotti
New Member
New Member

--
20 Jul 2005 12:28 PM
I will not allow WEB services at all as well. Keep in mind the only portion of RS installed is the two databases. the WEB portion is installed on an application server.


Acceptable Use Policy
---