Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhit_kumar
Posting Yak Master
147 Posts |
 Posted - 2010-05-18 : 01:12:26
|
| Hello Experts,I want some feedback from your side, currently im using performance issues in Reports side.Currently my company using single server for handling ReportServer as well SAP Application server for our enduser. In that server i have my database server.So in same server end user doing work of SAP as well as Reports viewing and extracting.Because of that in single server lots of load is occuring. This server have only 4 GB of RAM.So now im planning to move ReportServer to another server, so that load should not occur in SAP server.So i want to know if i will do this it will help me or not for increasing my reports performance or not? Or should i increase the RAM in same server?Also note that if i move Reports to another server, but my database server is in old server so i can access data from my old server or not? and view and extract the report or not?Please guide me.Regards,AKM |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-18 : 02:07:21
|
| if you're putting reports in separate server it will surely improve performanceyou can still access data from db server and use it in your reports------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
abhit_kumar
Posting Yak Master
147 Posts |
Posted - 2010-05-18 : 02:27:42
|
| Thanks Visakh |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-18 : 14:14:59
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Performance question