Hi,
In a .net application there is a link that brings up a SSRS report.
I have noticed that if it is the first time this report is requested i.e. Application has just been opened and the report button is clicked, then it takes a while to get this report to appear on the screen. But if this report is requested again (i.e. for the second time or more) then it only takes a few moments for the report to appear on the screen.
So it seems that only the first time the report is requested it takes a longer time to get this report. Is there a way to reduce this initial load of the report?
Thanks
Each day, the first user who launches our RS reports always gets a long wait time. Subsequent report launches are normal. Does anyone know what is going on? If yes, what is the remedy?
I have a SQL Server 2005 Std. Ed. 64-bit installation. There is one instance supporting a single production database. I have a CLR udf. This udf uses the XMLDocument object to retrieve XML from a URL. When the CLR udf is executed, there seems to be an initial slow response time. Subsequent response times are very fast. If the CLR udf is not called for a few minutes and then called, the slowdown appears again.
Is there something happening behind the scenes with compilation or something like that which could cause this slowdown?
Hi, I use a Remote Sql Server Express instance, and I have a strange behavior.. The first connection is really slow and I don't know how to fix that.I read some posts about this topic but I didn't find the right solution.Is there a way to "keep alive" the connection between my IIS server and the SQL one ?I check the auto-close property and it sets to false. Any help ? Stan
I have some date criterias on my report that default and so I would like for the report not to display until the user clicks on the "view report" button.
Also, I would like to trap that button to send my own internal parameters to the report. How and where would I do that.
I'm running the report through report viewer and I have a subroutine that would refresh the report with my desired internal parameters. I just need to hook it up.
i have a MSSQL 2000 database with about 30 tables in it. On one of those tables i've defined an full text index on an image field. In this table are around 500 records with binary files.
it functioned well for a time but now when i try to upload a file into the table this goes extremely slow (300 KB takes over 3 minutes).
i tried disabling "change tracking" but this didn't help a thing
adding blobs to other tables (without fulltext index on it) still goes fast.
what could be a reason that the uploading goes so slow??
I am having a problem deploying or manually uploading smdl files to reporting services. I can upload anyother type of file without a problem. (dsv, ds, etc.) However, when i try to upload a smdl file, I get
"The permissions granted to user '<me>' are insufficient for performing this operation. (rsAccessDenied)"
I have uploaded a html-page to the Report Manager, the html-page has a img-tag with a src="Picture1.png" in it. The image is then uploaded to the same folder as the html-page. When I browse the html-page the image is not found, red cross, does anyone know why this happens?
I have a report which works fine with visual studio but when i uploaded the same into report server and tries to access it through IE or chrome or anything its dam slow.
Hello, I need to be able to view and save reports using Report Manager. However, I do not want some users the ability to upload files (need to prevent virus or bad files). It appears I need to select manage reports from the role definition in order for a user to save reports. but then i get the upload file link as well. Is there a way to manage reports but prevent upload file link?
I am rewritting our DTS that upload tables in FoxPro to SQL Server using SSIS. I am finding the that SSIS is way slower. My uploads using DTS take just 7 minutes where doing the same thing in SSIS is taking 1 hour 15 minutes.
As I sit here waiting for a test run of the report to complete, I'm forced to wonder why it's taking over 10 minutes... so far.
The query itself, when run through Management Studio takes about 50 seconds, so why would it take over 10 minutes to generate the report? It's the only query being run, and it's not doing anything especially tricky with the data. It's all actually being processed in the query, returning some counts and displaying them in a simple list.
Any thoughts?
EDIT: I should mention that the query itself isn't very simple, so I can understand the query itself being slow... just not the report being 10 times slower than the query in management studio.
I have developed several reports with selectable parameters. When the report is first requested three stored procedures are triggered and return the parameters (+2 min), following parameters being returned the default report is returned (+3 min), this time is unacceptable. Is there anything I can do to speed up the report generation? Any help here is greatly appreciated.
I continue to see this similar post all over the place, but no resolutions.
We have SSRS installed and operational in production. There are reports that get accessed from either an aspx page or from the built in IIS site for SSRS.
First time access is the performance problem. Here are two scenarios:
1) from your browser, pull up the front page to SSRS: http://myserver/reports. This simple operation will take about 2 minutes to come up. Drill to the report in question and it runs fairly well first time through. Throw a different query at it and it runs faster. If you wait a while (maybe 15 minutes +) the whole thing will spin back down and take 2 minutes to come up again. If you exit the website and come back immediately, everything still stays quick.
2) from an aspx page, same thing... if the service is spun down, the end user will typically get tired of waiting or timeout. Once everything is spun up, the process runs fine.
We setup another report that just does some simple statistics and added in a timed subscription for every 15 minutes hoping it would keep the service up and running.... no joy. Still the same.
Also adjusted the app pool to about every option to see if we could keep it running, but no joy.
====
So -- any ideas? Forget about running a report.... just think about pulling the website up. 2 minutes to get it to display in the browser the first time...
Hi all, I've been building a set of traffic based reports on our website and I've run into a strange problem.
The reports are pretty basic, and up till now I've been really impressed with RS overall.
Recently I've added a StartDate and EndDate and since then the performance has gone from ~10 secs to ~10 minutes.
I've taken a really simple query from my reports. Running this query in Management Studio on the same data returns in less than a second. When its run from a test report with nothing else in it it takes ~1 minute. Even stranger when I run the same query with the same values for parameters inside of RS in the data view it takes less than 1 second. ARG!
SELECT COUNT(DISTINCT SessionID) as Occurences FROM WebAppSummary JOIN WebAppLocalizations ON WebAppSummary.ClientIp = WebAppLocalizations.ClientIp where FirstTime BETWEEN @StartDate AND @EndDate
The last line that was just added is this part: where FirstTime BETWEEN @StartDate AND @EndDate
So whats going on here? Is this a really poorly performing query that management studio is optimizing but RS isnt? Is RS messing up the databind and getting a bunch of DSs instead of just one?
Does anyone else have problems with the speed of the design environment for SSRS reports? We are using visual studio to create and manage hundreds of production reports (Oil and Gas).
It literally takes 5 seconds for the design environment to react to each change in the report layout. For instance, a common change is to reposition a text box, change the length, text, font size, font weight etc...:
Grab the text box - 5 seconds until designer responds - then reposition
Grab the edge to change the length - ditto
change text - 5 seconds for designer to "save" the change and allow next action....
blah - blah - blah.... So, performing the simple change above takes at least 30 seconds in addition to whatever time it took to edit the text box.
I've talked to the other developers using SSRS here and they all report that's "just the way it is".
Is this normal or is there an environment issue/setting we are overlooking.
I've searched the forums on this issue, haven't really found the answer.
I have several nifty little sales reports which crunch a ton of data quite efficiently and render in just a few seconds in Report Manager. I've pushed as much of the data processing back to the server as possible, use a stored procedure (with parameters) in a shared datasource, don't return unneccessary data, all that. It works great.
When I first developed the reports, I continued generating my charts (which use the same data as the reports, just grouped differently) in Excel and pasting them in as images. Now I want to stop that nonsense and use the SSRS charts. I fooled around with the charting function and got a reasonable facimile of my Excel charts, two per report, which use their own separate stored procedures and the same shared datasource.
Now, reports that used to render in 5-8 seconds may take 1-5 MINUTES. Help! It's definitely the charts--taking them back out fixes the problem.
I have complete control over the datasources--would it make more sense to use non-shared sources, or to create totally separate shared sources? I saw a post that recommended "making data calls non-synchronous," but I have no idea how to do that.
I have been using the report viewer to render my reports on a webpage. All worked fine for a time and now nothing is working correctly.
I have about ~8 report viewer on one page, all in an individual IFRAME. What happen is, sometimes I'm getting an error from IE (Internet Explorer cannot display the webpage) or the report starts loading (I see the title) but where the chart should be I have an X (broken image) icon.
Sometimes when I click on the image and choose "Display Image" the image will display.
Facts
Reports loads correctly on the report manager site (the Reporting Services webpage) Once those errors starts appearing, the session seems to act funny and I can't even refresh the webpage (F5) I have the latest report viewer patch installed I have the SP2 for SQL Server 2005 installed Running Windows 2000 Server Running IIS 6 The website was developped using IIS 5, but was tested on IIS 6 for about 3 weeks and we started to have problems today. The reports are linked with Analysis Services to get the data from cubes. I'm really out of ideas right now. Maybe I should just restart the IIS server, but the thing is live and I can't do it right now. However, if I need to restart it, will the problem occurs another time? Will it become a solution to restart the server?
I already restarted Reporting Services and nothing has changed.
I have a report in SQL Reporting Services 2005 which calls a stored proc and the report takes a very long time to run and sometimes returns zero records. But when i run the stored proc in query analyzer it takes about 4 seconds!!
I have checked the execution log on the RS using the below sql:
Code Snippet
use ReportServer
Select * from ExecutionLog with (nolock) order by TimeStart DESC
It shows that i have a large amount of time for the dataretrieval (601309ms, about 10mins) and does not return any records most likely because of a query timeout:
The weird thing is that when i run it in query analyzer, i get about 400 records in 4 seconds !!
I dont understand what RS is doing to take up so much time like this to retrieve data.
The report is very simple - it basically returns the records straight out into a table.
The only thing I somewhat suspected was a parameter data type conflict between RS and SQL, specifically dates. I have a start and end date parameter in the report - i tried specifying this as date and string to see if it made any difference but it didn't.
I have been using a licensed copy of Visual Studio 2005 and MS SQLServer 2005 for some time but am only now trying out the Reporting Services functionality.
I have attempted to follow the instructions from url:
However despite confirming that the report services are running and also checking the configuration by following the information in the above web page I still get the following problems.
1. When attempting to create a project via the wizard I get the following error: Exception has been thrown by the target of an invocation. If an attempt is made to add a new data source I am unable to choose the data source type (eg: Microsoft SQL Server). I am not given a choice for the type, in fact the relevant drop down is blank.
2. A project can be created without the wizard but if I right click the Shared Data Source folder I do not see the next Pop up to set the data source parameters.
I assume I am missing something quite fundamental - however so far I cannot see what.
Hi all. The company I work for is looking for a new SQL server. Where can I find information and or a tool for sizing information? By sizing information I mean how big a pile of hardware am I going to need to run MS SQL for x number of connected users with x size database, etc. I've been tooling around the internet and MS' site but can't find any info on this.
i have created a publication whereas i have provided a network path to its snapshop folder e.g ( \serverfolder ) at time of creating. When i try to make a Pull Subscription and follow all steps of wizards, it gives me following error "The initial snapshot for publication '---' is not yet available". can you guide me what are causes of this problem and how may i solve it?
I want get get results in sql that are all written in UPPERCASE but I want to receive them in Initial Case format I know UPPERCASE is UPPER lowercase is lower but what is Initial Case(first letter Capital in a word)
We had a runaway query which built the size of tempdb to 24000mb. Then someone changed the unrestricted file growth property to restricted growth while the size was 24000mb. Now I can not reduce the initial size. I have set the property back to unrestricted file growth. I have shrunk the tempdb and available space is almost 24000mb. I have stopped sqlserver. I even deleted the existing tempdb.mdf & tempdb.ldf files. But when SQL server is restarted, the initial size is set to 24000mb. It will not let me reduce the size. Is there anything short of manipulating the system tables to reduce the size back to 500mb?
I would like to increase the initial size of a SQL 2005 DB from 150 to 250 GB to prevent automatic autogrowth; would this have any impact in production if you do it on the fly?
I need to display the middle initial from a name field that contains the last name, comma, and the middle name or initial.
Example data:
Jane,Smith Ron John,Dow L Mary Jane,Dow Welsh
The result I am looking for is to capture only the first letter of the middle name. In this data example, I would need to display the following on a separate column:
-- I have a first name field that sometimes contains only the first name, -- sometimes contains the first name and the middle initial, and -- sometimes contains the first name, a space, followed by NMI (for no middle initial) -- how do I correctly grab the first letter of the middle initial in all cases? -- I have been playing with patindex but its harder than I thought. guess I need a case -- statement in addition to this. Any idea how I can do this? -- thanks!
I'm not a sql server savvy, so I need assistance on the following two scenarios:
A customer runs a script like this (slightly larger, but I ripped away the meat) --------------------------------------- create database test_database go
USE [test_database] exec sp_changedbowner 'sa'
use master; go sp_grantlogin 'server01CUSTOM_ADMIN'; go
use test_database; go
-- lots of table creations, where one of the tables are TEST_TABLE
sp_addrole 'ADMIN_ROLE'; Go sp_grantdbaccess @loginame = 'server01CUSTOM_ADMIN', @name_in_db = 'USER_ADMIN'; go sp_addrolemember @rolename ='ADMIN_ROLE' , @membername = 'USER_ADMIN'; Go
GRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[TEST_TABLE] TO [ADMIN_ROLE] GO ---------------------------
Now, if a person is added to the server01CUSTOM_ADMIN group, he/she should be able to do the following: (let's say it's a he)
- Create a test.udl-file (win xp). Set a provider to sql server. - On the connection-tab enter hostname of database server in the Data Source-field and use windows NT Integrated security. - When he now test the connection, it should work, since he has access to the database. - Also, using the dropdown "3. Enter the initial catalog to use:", he should see SOME datatables. Not ALL, not none. The ones that he has access to.
So, if TEST_DATABASE is the only access that server01CUSTOM_ADMIN has, that database and only that one should show, right?
In my customers scenario, some databases show (irrelevant ones), but not TEST_DATABASE. In my test, I still get ALL databases. Even after I rip the guy out of the Administrators-group and Users-group. He's only a member of the CUSTOM_ADMIN-group on server01. "Test connection" succeeds, and all the databases on the server shows.
What I hope for is following questions like "He's probably sysadmin, check it" etc, so that I can systematically (using your brains) filter out the reasons for these scenarios to happen.
