Hey All,
I setup a log shipped server so we could have a warm
backup but the only way I could make the business case to
spend the money was to use it as a reporting server as
well. Needless to say, people are not that happy about
getting kicked out all the time when the data is loading.
Is there anyway to mask the fact that the data source is
unavailable and just get reporting services to wait until
the load is done and resubmit the query when the
connection is available again.
Thanks,
BryanHave you looked into using execution snapshots. You could set the data to
only be refreshed when the data source is known to be available.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"bmurtha" <anonymous@.discussions.microsoft.com> wrote in message
news:7ce501c47735$e821d580$a301280a@.phx.gbl...
> Hey All,
> I setup a log shipped server so we could have a warm
> backup but the only way I could make the business case to
> spend the money was to use it as a reporting server as
> well. Needless to say, people are not that happy about
> getting kicked out all the time when the data is loading.
> Is there anyway to mask the fact that the data source is
> unavailable and just get reporting services to wait until
> the load is done and resubmit the query when the
> connection is available again.
> Thanks,
> Bryan
Showing posts with label setup. Show all posts
Showing posts with label setup. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Reporting services 2005 extremely slow performance
I have installed Reporting 2005 as a part of SQL Server 2005 setup ( SQL
Server got upgraded from 2000 to 2005)
The general web interface is completely unresponsive!
It takes 5-10 seconds just to move between the tabs, not talking about
running reports.
I have dual Xeon 2.8Ghz machine with 3Gb of memory available - it should
respond momentarily.
Anyone with the same problem? Any ideas?
TIA.I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
a different port). SPS 2003 is very fast, but I need to wait 30s when I
click on a folder (just browse). My server is a HP 360 with 2 CPU +
4Go, I really don't understand :-(|||The first time RS starts up after a lag you will get a long pause like that.
This is an IIS thing. You can set timeout on the IIS application pools.
Go to IIS Manager, under Applocation Pools node, right click
"DefaultAppPool" in which the Reporting Server work process is running,
select properties. On "Performace" tag, you will see, by default, the app
pool will shut down if > being idle for 20 min. You can extend this time to
8x60min 480min, so that the app pool will not shut down for a regular
working day. However, the first report reader of the day, will hit the
delay. You may schedule a dummy report at beginning of a work day for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<pascal.brel@.gmail.com> wrote in message
news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
> a different port). SPS 2003 is very fast, but I need to wait 30s when I
> click on a folder (just browse). My server is a HP 360 with 2 CPU +
> 4Go, I really don't understand :-(
>|||That is not the case.
I tried everything - so far no luck.
Yes, it takes a while to load the CLR for the first time.
But the reposnse after that is still slow.
I can see a message on status bar - "downloading picture ..." of a really
small gif file for a few seconds and that is in a local mode!
Any other ideas?
Thanks.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
> The first time RS starts up after a lag you will get a long pause like
> that. This is an IIS thing. You can set timeout on the IIS application
> pools.
> Go to IIS Manager, under Applocation Pools node, right click
> "DefaultAppPool" in which the Reporting Server work process is running,
> select properties. On "Performace" tag, you will see, by default, the app
> pool will shut down if > being idle for 20 min. You can extend this time
> to 8x60min 480min, so that the app pool will not shut down for a regular
> working day. However, the first report reader of the day, will hit the
> delay. You may schedule a dummy report at beginning of a work day for
> this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <pascal.brel@.gmail.com> wrote in message
> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>|||OK, two different people on this thread. For Pascal I think it is the IIS
issue.
Oleg, is it only reports with an image? If so, where is the image stored
(database or external)? Also, initially you said just seeing the reports,
not running them. Once RS is spun up you should see the report listing
pretty instantaneously on your configuration. RS 2005 is faster than RS
2000, both for displaying report list and running the reports.
Just to make sure, this is from Report Manager, not from your own app?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
> That is not the case.
> I tried everything - so far no luck.
> Yes, it takes a while to load the CLR for the first time.
> But the reposnse after that is still slow.
> I can see a message on status bar - "downloading picture ..." of a really
> small gif file for a few seconds and that is in a local mode!
> Any other ideas?
> Thanks.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is running,
>> select properties. On "Performace" tag, you will see, by default, the
>> app pool will shut down if > being idle for 20 min. You can extend this
>> time to 8x60min 480min, so that the app pool will not shut down for a
>> regular working day. However, the first report reader of the day, will
>> hit the delay. You may schedule a dummy report at beginning of a work day
>> for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>|||My issue is the same as Pascal's one - slow Report Manager performance.
As mentioned before - the Report manager is slow. I'm not running any
reports yet.
It is very, very slow, when moving between pages within Report Manager
interface.
Even Report Manager's own small image files are loading extremely slow,
until they are cached.
I suspect it is an IIS issue. There are a lot of other web applications
running on the same IIS server, but they are fast.
The only problem is RS 2005.
Thanks.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
> OK, two different people on this thread. For Pascal I think it is the IIS
> issue.
> Oleg, is it only reports with an image? If so, where is the image stored
> (database or external)? Also, initially you said just seeing the reports,
> not running them. Once RS is spun up you should see the report listing
> pretty instantaneously on your configuration. RS 2005 is faster than RS
> 2000, both for displaying report list and running the reports.
> Just to make sure, this is from Report Manager, not from your own app?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is running,
>> select properties. On "Performace" tag, you will see, by default, the
>> app pool will shut down if > being idle for 20 min. You can extend this
>> time to 8x60min 480min, so that the app pool will not shut down for a
>> regular working day. However, the first report reader of the day, will
>> hit the delay. You may schedule a dummy report at beginning of a work
>> day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>|||It should be subsecond. Is this the only 2.0 framework app on your web
server?
The other possibility might be authentication. Still, you would think that
would only be right when you first connect.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
> My issue is the same as Pascal's one - slow Report Manager performance.
> As mentioned before - the Report manager is slow. I'm not running any
> reports yet.
> It is very, very slow, when moving between pages within Report Manager
> interface.
> Even Report Manager's own small image files are loading extremely slow,
> until they are cached.
> I suspect it is an IIS issue. There are a lot of other web applications
> running on the same IIS server, but they are fast.
> The only problem is RS 2005.
> Thanks.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the IIS
>> issue.
>> Oleg, is it only reports with an image? If so, where is the image stored
>> (database or external)? Also, initially you said just seeing the reports,
>> not running them. Once RS is spun up you should see the report listing
>> pretty instantaneously on your configuration. RS 2005 is faster than RS
>> 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is
>> running, select properties. On "Performace" tag, you will see, by
>> default, the app pool will shut down if > being idle for 20 min. You
>> can extend this time to 8x60min 480min, so that the app pool will not
>> shut down for a regular working day. However, the first report reader
>> of the day, will hit the delay. You may schedule a dummy report at
>> beginning of a work day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>> (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when
>> I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>>
>|||Posted initially in a wrong thread.
That is the only 2.0 app in the system yet.
Uninstalled SQL Server 2005, reinstalled it completely from scratch - same
problem.
In addition to the problem description I'd like to list some verbose logs of
simply changing pages within a Report manager
w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetProperties"
w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties('/')
w3wp!library!1!02/27/2006-11:55:26:: i INFO: Catalog SQL Server Edition =Enterprise
w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties
completed.
w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetSystemPermissions"
w3wp!library!1!02/27/2006-11:59:34:: i INFO: Call to GetSystemPermissions
As you see:
11:55:24 - SoapAction...
11:55:26:: v VERBOSE: Call to GetProperties('/')
took two seconds to execute
11:55:26:: v VERBOSE: Call to GetProperties completed.
11:59:34:: v VERBOSE: User map'<Users>.....
8 seconds beween calls.
from another log file:
w3wp!runningrequests!1!02/27/2006-11:59:28:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListSecureMethods"
w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetPolicies"
SoapAction ... -- took 7 seconds to execute
Seems like any SoapAction calls take a long time to execute in a local mode
on a very powerfull machine.
Question is why?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uTjABy9OGHA.1132@.TK2MSFTNGP10.phx.gbl...
> It should be subsecond. Is this the only 2.0 framework app on your web
> server?
> The other possibility might be authentication. Still, you would think that
> would only be right when you first connect.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
> news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
>> My issue is the same as Pascal's one - slow Report Manager performance.
>> As mentioned before - the Report manager is slow. I'm not running any
>> reports yet.
>> It is very, very slow, when moving between pages within Report Manager
>> interface.
>> Even Report Manager's own small image files are loading extremely slow,
>> until they are cached.
>> I suspect it is an IIS issue. There are a lot of other web applications
>> running on the same IIS server, but they are fast.
>> The only problem is RS 2005.
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the
>> IIS issue.
>> Oleg, is it only reports with an image? If so, where is the image stored
>> (database or external)? Also, initially you said just seeing the
>> reports, not running them. Once RS is spun up you should see the report
>> listing pretty instantaneously on your configuration. RS 2005 is faster
>> than RS 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is
>> running, select properties. On "Performace" tag, you will see, by
>> default, the app pool will shut down if > being idle for 20 min. You
>> can extend this time to 8x60min 480min, so that the app pool will not
>> shut down for a regular working day. However, the first report reader
>> of the day, will hit the delay. You may schedule a dummy report at
>> beginning of a work day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>> (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when
>> I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>>
>>
>|||Finally found a problem after looking into the System Event log. It was full
of complains about NETWORKSERVICE insufficient permissions.
Added Local Launch and Local Activation permissions of netman in DCOM config
screen to the NETWORKSERVICE account and it started to respond momentarily.
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:uc6exzkPGHA.2704@.TK2MSFTNGP15.phx.gbl...
> Posted initially in a wrong thread.
> That is the only 2.0 app in the system yet.
> Uninstalled SQL Server 2005, reinstalled it completely from scratch - same
> problem.
>
> In addition to the problem description I'd like to list some verbose logs
> of simply changing pages within a Report manager
> w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetProperties"
> w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties('/')
> w3wp!library!1!02/27/2006-11:55:26:: i INFO: Catalog SQL Server Edition => Enterprise
> w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties
> completed.
> w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetSystemPermissions"
> w3wp!library!1!02/27/2006-11:59:34:: i INFO: Call to GetSystemPermissions
> As you see:
> 11:55:24 - SoapAction...
> 11:55:26:: v VERBOSE: Call to GetProperties('/')
> took two seconds to execute
> 11:55:26:: v VERBOSE: Call to GetProperties completed.
> 11:59:34:: v VERBOSE: User map'<Users>.....
> 8 seconds beween calls.
> from another log file:
> w3wp!runningrequests!1!02/27/2006-11:59:28:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListSecureMethods"
> w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetPolicies"
> SoapAction ... -- took 7 seconds to execute
> Seems like any SoapAction calls take a long time to execute in a local
> mode on a very powerfull machine.
> Question is why?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uTjABy9OGHA.1132@.TK2MSFTNGP10.phx.gbl...
>> It should be subsecond. Is this the only 2.0 framework app on your web
>> server?
>> The other possibility might be authentication. Still, you would think
>> that would only be right when you first connect.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
>> My issue is the same as Pascal's one - slow Report Manager performance.
>> As mentioned before - the Report manager is slow. I'm not running any
>> reports yet.
>> It is very, very slow, when moving between pages within Report Manager
>> interface.
>> Even Report Manager's own small image files are loading extremely slow,
>> until they are cached.
>> I suspect it is an IIS issue. There are a lot of other web applications
>> running on the same IIS server, but they are fast.
>> The only problem is RS 2005.
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the
>> IIS issue.
>> Oleg, is it only reports with an image? If so, where is the image
>> stored (database or external)? Also, initially you said just seeing the
>> reports, not running them. Once RS is spun up you should see the report
>> listing pretty instantaneously on your configuration. RS 2005 is faster
>> than RS 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause
>> like that. This is an IIS thing. You can set timeout on the IIS
>> application pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is
>> running, select properties. On "Performace" tag, you will see, by
>> default, the app pool will shut down if > being idle for 20 min. You
>> can extend this time to 8x60min 480min, so that the app pool will
>> not shut down for a regular working day. However, the first report
>> reader of the day, will hit the delay. You may schedule a dummy
>> report at beginning of a work day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>>> (on
>>> a different port). SPS 2003 is very fast, but I need to wait 30s
>>> when I
>>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>>> 4Go, I really don't understand :-(
>>>
>>
>>
>>
>>
>>
>
Server got upgraded from 2000 to 2005)
The general web interface is completely unresponsive!
It takes 5-10 seconds just to move between the tabs, not talking about
running reports.
I have dual Xeon 2.8Ghz machine with 3Gb of memory available - it should
respond momentarily.
Anyone with the same problem? Any ideas?
TIA.I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
a different port). SPS 2003 is very fast, but I need to wait 30s when I
click on a folder (just browse). My server is a HP 360 with 2 CPU +
4Go, I really don't understand :-(|||The first time RS starts up after a lag you will get a long pause like that.
This is an IIS thing. You can set timeout on the IIS application pools.
Go to IIS Manager, under Applocation Pools node, right click
"DefaultAppPool" in which the Reporting Server work process is running,
select properties. On "Performace" tag, you will see, by default, the app
pool will shut down if > being idle for 20 min. You can extend this time to
8x60min 480min, so that the app pool will not shut down for a regular
working day. However, the first report reader of the day, will hit the
delay. You may schedule a dummy report at beginning of a work day for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<pascal.brel@.gmail.com> wrote in message
news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
> a different port). SPS 2003 is very fast, but I need to wait 30s when I
> click on a folder (just browse). My server is a HP 360 with 2 CPU +
> 4Go, I really don't understand :-(
>|||That is not the case.
I tried everything - so far no luck.
Yes, it takes a while to load the CLR for the first time.
But the reposnse after that is still slow.
I can see a message on status bar - "downloading picture ..." of a really
small gif file for a few seconds and that is in a local mode!
Any other ideas?
Thanks.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
> The first time RS starts up after a lag you will get a long pause like
> that. This is an IIS thing. You can set timeout on the IIS application
> pools.
> Go to IIS Manager, under Applocation Pools node, right click
> "DefaultAppPool" in which the Reporting Server work process is running,
> select properties. On "Performace" tag, you will see, by default, the app
> pool will shut down if > being idle for 20 min. You can extend this time
> to 8x60min 480min, so that the app pool will not shut down for a regular
> working day. However, the first report reader of the day, will hit the
> delay. You may schedule a dummy report at beginning of a work day for
> this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <pascal.brel@.gmail.com> wrote in message
> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>|||OK, two different people on this thread. For Pascal I think it is the IIS
issue.
Oleg, is it only reports with an image? If so, where is the image stored
(database or external)? Also, initially you said just seeing the reports,
not running them. Once RS is spun up you should see the report listing
pretty instantaneously on your configuration. RS 2005 is faster than RS
2000, both for displaying report list and running the reports.
Just to make sure, this is from Report Manager, not from your own app?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
> That is not the case.
> I tried everything - so far no luck.
> Yes, it takes a while to load the CLR for the first time.
> But the reposnse after that is still slow.
> I can see a message on status bar - "downloading picture ..." of a really
> small gif file for a few seconds and that is in a local mode!
> Any other ideas?
> Thanks.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is running,
>> select properties. On "Performace" tag, you will see, by default, the
>> app pool will shut down if > being idle for 20 min. You can extend this
>> time to 8x60min 480min, so that the app pool will not shut down for a
>> regular working day. However, the first report reader of the day, will
>> hit the delay. You may schedule a dummy report at beginning of a work day
>> for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>|||My issue is the same as Pascal's one - slow Report Manager performance.
As mentioned before - the Report manager is slow. I'm not running any
reports yet.
It is very, very slow, when moving between pages within Report Manager
interface.
Even Report Manager's own small image files are loading extremely slow,
until they are cached.
I suspect it is an IIS issue. There are a lot of other web applications
running on the same IIS server, but they are fast.
The only problem is RS 2005.
Thanks.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
> OK, two different people on this thread. For Pascal I think it is the IIS
> issue.
> Oleg, is it only reports with an image? If so, where is the image stored
> (database or external)? Also, initially you said just seeing the reports,
> not running them. Once RS is spun up you should see the report listing
> pretty instantaneously on your configuration. RS 2005 is faster than RS
> 2000, both for displaying report list and running the reports.
> Just to make sure, this is from Report Manager, not from your own app?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is running,
>> select properties. On "Performace" tag, you will see, by default, the
>> app pool will shut down if > being idle for 20 min. You can extend this
>> time to 8x60min 480min, so that the app pool will not shut down for a
>> regular working day. However, the first report reader of the day, will
>> hit the delay. You may schedule a dummy report at beginning of a work
>> day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>|||It should be subsecond. Is this the only 2.0 framework app on your web
server?
The other possibility might be authentication. Still, you would think that
would only be right when you first connect.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
> My issue is the same as Pascal's one - slow Report Manager performance.
> As mentioned before - the Report manager is slow. I'm not running any
> reports yet.
> It is very, very slow, when moving between pages within Report Manager
> interface.
> Even Report Manager's own small image files are loading extremely slow,
> until they are cached.
> I suspect it is an IIS issue. There are a lot of other web applications
> running on the same IIS server, but they are fast.
> The only problem is RS 2005.
> Thanks.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the IIS
>> issue.
>> Oleg, is it only reports with an image? If so, where is the image stored
>> (database or external)? Also, initially you said just seeing the reports,
>> not running them. Once RS is spun up you should see the report listing
>> pretty instantaneously on your configuration. RS 2005 is faster than RS
>> 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is
>> running, select properties. On "Performace" tag, you will see, by
>> default, the app pool will shut down if > being idle for 20 min. You
>> can extend this time to 8x60min 480min, so that the app pool will not
>> shut down for a regular working day. However, the first report reader
>> of the day, will hit the delay. You may schedule a dummy report at
>> beginning of a work day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>> (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when
>> I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>>
>|||Posted initially in a wrong thread.
That is the only 2.0 app in the system yet.
Uninstalled SQL Server 2005, reinstalled it completely from scratch - same
problem.
In addition to the problem description I'd like to list some verbose logs of
simply changing pages within a Report manager
w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetProperties"
w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties('/')
w3wp!library!1!02/27/2006-11:55:26:: i INFO: Catalog SQL Server Edition =Enterprise
w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties
completed.
w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetSystemPermissions"
w3wp!library!1!02/27/2006-11:59:34:: i INFO: Call to GetSystemPermissions
As you see:
11:55:24 - SoapAction...
11:55:26:: v VERBOSE: Call to GetProperties('/')
took two seconds to execute
11:55:26:: v VERBOSE: Call to GetProperties completed.
11:59:34:: v VERBOSE: User map'<Users>.....
8 seconds beween calls.
from another log file:
w3wp!runningrequests!1!02/27/2006-11:59:28:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListSecureMethods"
w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetPolicies"
SoapAction ... -- took 7 seconds to execute
Seems like any SoapAction calls take a long time to execute in a local mode
on a very powerfull machine.
Question is why?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uTjABy9OGHA.1132@.TK2MSFTNGP10.phx.gbl...
> It should be subsecond. Is this the only 2.0 framework app on your web
> server?
> The other possibility might be authentication. Still, you would think that
> would only be right when you first connect.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
> news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
>> My issue is the same as Pascal's one - slow Report Manager performance.
>> As mentioned before - the Report manager is slow. I'm not running any
>> reports yet.
>> It is very, very slow, when moving between pages within Report Manager
>> interface.
>> Even Report Manager's own small image files are loading extremely slow,
>> until they are cached.
>> I suspect it is an IIS issue. There are a lot of other web applications
>> running on the same IIS server, but they are fast.
>> The only problem is RS 2005.
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the
>> IIS issue.
>> Oleg, is it only reports with an image? If so, where is the image stored
>> (database or external)? Also, initially you said just seeing the
>> reports, not running them. Once RS is spun up you should see the report
>> listing pretty instantaneously on your configuration. RS 2005 is faster
>> than RS 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is
>> running, select properties. On "Performace" tag, you will see, by
>> default, the app pool will shut down if > being idle for 20 min. You
>> can extend this time to 8x60min 480min, so that the app pool will not
>> shut down for a regular working day. However, the first report reader
>> of the day, will hit the delay. You may schedule a dummy report at
>> beginning of a work day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>> (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when
>> I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>>
>>
>|||Finally found a problem after looking into the System Event log. It was full
of complains about NETWORKSERVICE insufficient permissions.
Added Local Launch and Local Activation permissions of netman in DCOM config
screen to the NETWORKSERVICE account and it started to respond momentarily.
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:uc6exzkPGHA.2704@.TK2MSFTNGP15.phx.gbl...
> Posted initially in a wrong thread.
> That is the only 2.0 app in the system yet.
> Uninstalled SQL Server 2005, reinstalled it completely from scratch - same
> problem.
>
> In addition to the problem description I'd like to list some verbose logs
> of simply changing pages within a Report manager
> w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetProperties"
> w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties('/')
> w3wp!library!1!02/27/2006-11:55:26:: i INFO: Catalog SQL Server Edition => Enterprise
> w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties
> completed.
> w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetSystemPermissions"
> w3wp!library!1!02/27/2006-11:59:34:: i INFO: Call to GetSystemPermissions
> As you see:
> 11:55:24 - SoapAction...
> 11:55:26:: v VERBOSE: Call to GetProperties('/')
> took two seconds to execute
> 11:55:26:: v VERBOSE: Call to GetProperties completed.
> 11:59:34:: v VERBOSE: User map'<Users>.....
> 8 seconds beween calls.
> from another log file:
> w3wp!runningrequests!1!02/27/2006-11:59:28:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListSecureMethods"
> w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetPolicies"
> SoapAction ... -- took 7 seconds to execute
> Seems like any SoapAction calls take a long time to execute in a local
> mode on a very powerfull machine.
> Question is why?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uTjABy9OGHA.1132@.TK2MSFTNGP10.phx.gbl...
>> It should be subsecond. Is this the only 2.0 framework app on your web
>> server?
>> The other possibility might be authentication. Still, you would think
>> that would only be right when you first connect.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
>> My issue is the same as Pascal's one - slow Report Manager performance.
>> As mentioned before - the Report manager is slow. I'm not running any
>> reports yet.
>> It is very, very slow, when moving between pages within Report Manager
>> interface.
>> Even Report Manager's own small image files are loading extremely slow,
>> until they are cached.
>> I suspect it is an IIS issue. There are a lot of other web applications
>> running on the same IIS server, but they are fast.
>> The only problem is RS 2005.
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the
>> IIS issue.
>> Oleg, is it only reports with an image? If so, where is the image
>> stored (database or external)? Also, initially you said just seeing the
>> reports, not running them. Once RS is spun up you should see the report
>> listing pretty instantaneously on your configuration. RS 2005 is faster
>> than RS 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause
>> like that. This is an IIS thing. You can set timeout on the IIS
>> application pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is
>> running, select properties. On "Performace" tag, you will see, by
>> default, the app pool will shut down if > being idle for 20 min. You
>> can extend this time to 8x60min 480min, so that the app pool will
>> not shut down for a regular working day. However, the first report
>> reader of the day, will hit the delay. You may schedule a dummy
>> report at beginning of a work day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>>> (on
>>> a different port). SPS 2003 is very fast, but I need to wait 30s
>>> when I
>>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>>> 4Go, I really don't understand :-(
>>>
>>
>>
>>
>>
>>
>
Friday, March 23, 2012
Reporting Services : Where is it?
I've installed Reporting Services. No shortcuts were setup so what do I do to get into it? Should it show up in Microsoft SQL Server Management Studio Express or should I be using something else?
I'm not 100% sure what you're looking for. Are you just trying to verify it was installed so you can create a project with it? You should be able to do that by going in to Visual Studio, selecting Help >> About Microsoft VS and it should show up in your list of installed products.
If you're looking to create a new project, simply choose File >> New Project and select Business Intelligence Projects from the project types. Hmm, I might be way off on what you're looking for - I too am quite new to Reporting Services. There is an excellent video on this site I would suggest watching: http://www.asp.net/learn/videos/view.aspx?tabid=63&id=112
Rubes
|||To verify that you have reporting services properly configured try accessing report manager from internet explorer by typing the following URL if your using sql express with advanced services.
http://ComputerNameHere/reports$SQLEXPRESS
You may need to replace SQLEXPRESS with your sql instance name.
The url above show launch report manager from where you can browse folders and reports hosted on the report server.
Wednesday, March 7, 2012
Reporting Server vs. Database Server
Hi everyone,
After reading through countless Microsoft pages I'm still very
confused about how to setup a correct datasource connection. I have a
database server where all the data is kept, and a reports server that
I would like to use only to generate and deploy reports to. I have
Visual Studio 2005 installed on my client computer, and I DO NOT want
to create a data source that connects directly to the database
server.
Theoretically, there is a way to load VS and connect to the database
server through the reports server. I don't want any of my client
computers directly touching the database server, but they have to be
able to generate reports from that data. How can I accomplish this?
Anyone who can solve this conundrum gets a batch of my wife's home-
made cookies!Not possible. The computer that is running VS 2005 has to have a datasource
to the data being reported off of. All the users do not need to connect to
the database server but any developer using the report designer has to have
a data source created to hit the server.
I use mixed mode on the database server, create a readonly login that I use
for reporting.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<nlandis22@.gmail.com> wrote in message
news:1177429176.362218.226390@.t38g2000prd.googlegroups.com...
> Hi everyone,
> After reading through countless Microsoft pages I'm still very
> confused about how to setup a correct datasource connection. I have a
> database server where all the data is kept, and a reports server that
> I would like to use only to generate and deploy reports to. I have
> Visual Studio 2005 installed on my client computer, and I DO NOT want
> to create a data source that connects directly to the database
> server.
> Theoretically, there is a way to load VS and connect to the database
> server through the reports server. I don't want any of my client
> computers directly touching the database server, but they have to be
> able to generate reports from that data. How can I accomplish this?
> Anyone who can solve this conundrum gets a batch of my wife's home-
> made cookies!
>|||On Apr 24, 12:38 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Not possible. The computer that is running VS 2005 has to have a datasource
> to the data being reported off of. All the users do not need to connect to
> the database server but any developer using the report designer has to have
> a data source created to hit the server.
> I use mixed mode on the database server, create a readonly login that I use
> for reporting.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <nlandi...@.gmail.com> wrote in message
> news:1177429176.362218.226390@.t38g2000prd.googlegroups.com...
>
> > Hi everyone,
> > After reading through countless Microsoft pages I'm still very
> > confused about how to setup a correct datasource connection. I have a
> > database server where all the data is kept, and a reports server that
> > I would like to use only to generate and deploy reports to. I have
> > Visual Studio 2005 installed on my client computer, and I DO NOT want
> > to create a data source that connects directly to the database
> > server.
> > Theoretically, there is a way to load VS and connect to the database
> > server through the reports server. I don't want any of my client
> > computers directly touching the database server, but they have to be
> > able to generate reports from that data. How can I accomplish this?
> > Anyone who can solve this conundrum gets a batch of my wife's home-
> > made cookies!- Hide quoted text -
> - Show quoted text -
That's for the help. I think having a read-only login is probably a
safe way to go. The only reason I asked was because of this article
that I found earlier. I don't quite understand Report Server Model's
yet... but I get the feeling it's something for Report Builder, and
not for Report Designer (VS).
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/2aef6082da0ab4a4/8db0b06920500fc2?lnk=gst&q=data+source&rnum=6#8db0b06920500fc2
After reading through countless Microsoft pages I'm still very
confused about how to setup a correct datasource connection. I have a
database server where all the data is kept, and a reports server that
I would like to use only to generate and deploy reports to. I have
Visual Studio 2005 installed on my client computer, and I DO NOT want
to create a data source that connects directly to the database
server.
Theoretically, there is a way to load VS and connect to the database
server through the reports server. I don't want any of my client
computers directly touching the database server, but they have to be
able to generate reports from that data. How can I accomplish this?
Anyone who can solve this conundrum gets a batch of my wife's home-
made cookies!Not possible. The computer that is running VS 2005 has to have a datasource
to the data being reported off of. All the users do not need to connect to
the database server but any developer using the report designer has to have
a data source created to hit the server.
I use mixed mode on the database server, create a readonly login that I use
for reporting.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<nlandis22@.gmail.com> wrote in message
news:1177429176.362218.226390@.t38g2000prd.googlegroups.com...
> Hi everyone,
> After reading through countless Microsoft pages I'm still very
> confused about how to setup a correct datasource connection. I have a
> database server where all the data is kept, and a reports server that
> I would like to use only to generate and deploy reports to. I have
> Visual Studio 2005 installed on my client computer, and I DO NOT want
> to create a data source that connects directly to the database
> server.
> Theoretically, there is a way to load VS and connect to the database
> server through the reports server. I don't want any of my client
> computers directly touching the database server, but they have to be
> able to generate reports from that data. How can I accomplish this?
> Anyone who can solve this conundrum gets a batch of my wife's home-
> made cookies!
>|||On Apr 24, 12:38 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Not possible. The computer that is running VS 2005 has to have a datasource
> to the data being reported off of. All the users do not need to connect to
> the database server but any developer using the report designer has to have
> a data source created to hit the server.
> I use mixed mode on the database server, create a readonly login that I use
> for reporting.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <nlandi...@.gmail.com> wrote in message
> news:1177429176.362218.226390@.t38g2000prd.googlegroups.com...
>
> > Hi everyone,
> > After reading through countless Microsoft pages I'm still very
> > confused about how to setup a correct datasource connection. I have a
> > database server where all the data is kept, and a reports server that
> > I would like to use only to generate and deploy reports to. I have
> > Visual Studio 2005 installed on my client computer, and I DO NOT want
> > to create a data source that connects directly to the database
> > server.
> > Theoretically, there is a way to load VS and connect to the database
> > server through the reports server. I don't want any of my client
> > computers directly touching the database server, but they have to be
> > able to generate reports from that data. How can I accomplish this?
> > Anyone who can solve this conundrum gets a batch of my wife's home-
> > made cookies!- Hide quoted text -
> - Show quoted text -
That's for the help. I think having a read-only login is probably a
safe way to go. The only reason I asked was because of this article
that I found earlier. I don't quite understand Report Server Model's
yet... but I get the feeling it's something for Report Builder, and
not for Report Designer (VS).
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/2aef6082da0ab4a4/8db0b06920500fc2?lnk=gst&q=data+source&rnum=6#8db0b06920500fc2
Saturday, February 25, 2012
reporting server failing....System outof memory exception
Hi :
We have a setup reporting services for reporting...and our reports are working fine for 100-200 thousand records which is basically 1 year worth of data.
The reporting server fails when it starts processing beyond 200 thousand records...when I check the reporting log I see System outof memory exception. The reporting server has 8GB of ram and its a blade server. I dont know how to solve this issue.
Please let me know where I am doing wrong....
Thanks,
Pramod
Are you sure that SQL Server has not been restricted in how much memory is available for it to use?
Also as a general rule, I try to return as little data in the dataset for RS to process as possible. So it's better to do some GROUP BY clases in your query rather than returning all records and letting RS do the Sums.
|||You'll want to make sure SQL Server is actually "seeing" all 8 gig of ram ... I've seen a lot of admins forget to configure AWE.|||Yep sql server is made available all 7 gb of 8 gb ram...by setting /7gb in boot.ini.|||Yes adam...the RS is after group by of all fields....other wise i would get a million records without group by....
Subscribe to:
Posts (Atom)