Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to speed up deployment time of SQL reports into SharePoint site?

Posted on 2008-10-12
4
Medium Priority
?
266 Views
Last Modified: 2008-10-17
Hello there Experts,

I have a SQL Reporting Server running in integrated mode inside a SharePoint portal.

My problem is that whenever I deploy reports from my local machine to SharePoint server, it takes very long time to deploy, whereas if I deploy to my local machine (//localhost/reportserver) , it's done very fast.

Any ideas as to what could be the problem with the server?

I know this is a very generic question, and there are probably hundreds of reasons that may cause the slow response. I was hoping though that you through some ideas on what could be the main contributor to the slow deployment.

Thank you so much in anticipation,

Hani
0
Comment
Question by:Mehawitchi
[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
  • 2
4 Comments
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 22700503
What syntax are you using to deploy locally and to Sharepoint?
0
 

Author Comment

by:Mehawitchi
ID: 22701113
Thanks for your help tedbilly. I hope I understand your question correctly

Target URL for the local deployment is:
http://localhost/reportserver

Target URL for SharePoint server:
http://marina:999/RC2

For deployment, I right-click my project and click 'Deploy' from the menu

Is that what you've asked for?

Thanks again,
Hani
0
 

Author Comment

by:Mehawitchi
ID: 22731907
Did not get a solution or possible answer
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 1500 total points
ID: 22737471
You links look fine.  It's probably simply the added overhead of Sharepoint.  We used SQL Reporting Services integration for awhile then disabled it.  We found there were too many performance problems.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

704 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