473,785 Members | 2,607 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Reporting Services Speed Issue

24 New Member
I have a Web server running Reporting Services which has (all of a sudden) dropped in performance. When a user logs in, they are presented with an initial report (Main Menu) which provides links to other reports. This menu used to load up in less than a second now it takes 4-5.
If you click on any of the links to other reports from this menu, All of them used to load in less than 7 seconds and some were less than 3 seconds.
Now they can be anything over than 1 minute.

If I run the query from the dataset of the report directly on the SQL Server, they run as fast as the report used to open up so I dont believe the problem is with SQL Server.

The Web server has been rebooted and there is not much going on - process wise, but am a bit stuck as to what to check next.

Has anybody had any similar issues with reporting Services and/or know of anything I can check to get the speed back to what it used to be?

SQL SERVER = 2005
WINDOWS SERVER = 2003
ALL UPDATES/SPs APPLIED REGULARLY
Jan 7 '09 #1
0 1576

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3652
by: GeekMarine1972 | last post by:
We are planning to deploy the MS Reporting Services. Unfortunately, there isn't much guidance on how to effectively size a server. Here are my questions: 1) In an environment with 1 reporting server (hosting the reporting data layer, application, and management layer) connecting to 1 or more SQL servers (over 2 trunked 1Gbps switches connections), what is the constraining resource when running large reports against a database of say...
4
3918
by: Fabian von Romberg | last post by:
Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000 PRO and the other one is WIN 2000 ADV. SERVER. When I try to access a report using the webbrowser, I get the following error, this happens only if try access the report on the SERVER, it I try on my local machine, it works just fine. Any help will be much appreciated. Thanks in advance, Fabian von Romberg
8
2753
by: Woody Splawn | last post by:
I am asking this question here because I asked this question in the Reporting Services Newsgroup and did not get an answer. Does anyone know if Reporting Services is intended to work in a client/Server or Local machine environment? Based on what I have seen my guess is yes but that is a guess. In some materal it talks about it running on a web server but my supposition is that this does not necessarily mean that it would not make for a...
2
1156
by: gmv | last post by:
Hi, I need to study Reporting Services and I don´t know this tool ..... I wanna buy a good book about ..... Anybody knows ? What is the best book ? Thanks
1
4011
by: Larry Dooley | last post by:
Here's my issue. We've decided to replace a very critical (without it the business would lose lots of money) departmental reporting system with a built from scratch system based on .NET. The key component is a datagrid (it really turned the CIO's head). The issue is that the data source is Oracle. We've got a very complex reporting system that produces dynamic sql and sends it to oracle and takes back the result set and displays it. ...
0
435
by: rmk | last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development laptop ????? I have ASP.NET 1.1 and 2.0 installed on my laptop. I have Visual Studio 2003 and 2005 installed on my laptop. I have my default website configured for ASP.NET 2.0. I have the developer edition of SQL Server 2000 installed on my laptop as
2
2922
by: kbutterly | last post by:
Good afternoon, I have what appears to be a caching issue, but i'm a bit of a newbie at http headers so it may be something else. I have a small asp.net 2.0 application that is called to serve up some SQL Reporting Services reports. The asp pages are running under SSL as are the pages that call the asp app. The asp app runs correctly, but the reports cannot be opened or saved.
3
2901
by: Blasting Cap | last post by:
I'm using VS 2005, SQL 2005 reporting services. SQL reporting services is working, and I have it both on my local computer, as well as on a server. I've created a report in the SQL Business Intelligence development studio that works in that environment. I've uploaded the same report to both the Reporting services on my local computer as well as the server, and can log in to them and run the
0
1481
by: Just Me | last post by:
Hey Peeps, My exisiting scenario is SQL2000 with no reporting services, and we use Microsoft .NET 2003 and Crystal reports to report. This works reasonably ok. As the ASP.NET application uses one account to access the database, then the security for who can see a report is managed by the application, so far so good. Now im being tasked with moving all the reporting to SQL2005/Reporting services which I have not used in anger yet....
0
9645
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10341
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9954
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8979
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6741
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5383
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5513
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4054
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2881
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.