Solved

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

Posted on 2008-10-12
4
257 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
  • 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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now