<div>
What is 99% idle ? Processor ? How about excessive disk I/O ?
</div>


What is 99% idle ? Processor ? How about excessive disk I/O ?

<div>
... and which server is 99% idle ? The Report Server Instance or the instance that is actually holds the data ? Or is it all on the same instance ?<br />

</div>


... and which server is 99% idle ? The Report Server Instance or the instance that is actually holds the data ? Or is it all on the same instance ?


<div>
processor is idle, so is disk. The report server is also the database server, all one instance.
</div>


processor is idle, so is disk. The report server is also the database server, all one instance.

<div>
how do you measure the 1/2 hour?<br />
how is the report delivered?
</div>


how do you measure the 1/2 hour?
how is the report delivered?

<div>
I am &nbsp;running the reports through the default report manager website &quot;<a href="http://theserver/Reports" rel="ugc">http://theserver/Reports</a>&quot;<br />
<br />
measuring time elapsed by leaving IE running having noted down the start time for a report. Reports are timestamped 
</div>


I am  running the reports through the default report manager website "http://theserver/Reports [http://theserver/Reports]"

measuring time elapsed by leaving IE running having noted down the start time for a report. Reports are timestamped

<div>
machine was not patched/rebooted/etc ?<br />

</div>


<div>
it was rebooted due to becoming unresponsive
</div>


it was rebooted due to becoming unresponsive

<div>
<div class="content wysiwyg-content">
Im using SSRS 2005 and have trouble with how long it is taking to run reports.<br />
<br />
Up until yesterday each report would take 10-15 sec to run. Today however, the reports now take 1/2hr each. If I look at the task manager on the server when a report is 99% idle. The same server is used for SQL 2005 and SSRS and the database is local.<br />
<br />
Any help appreciated.<br />
<br />

</div>
</div>


Im using SSRS 2005 and have trouble with how long it is taking to run reports.

Up until yesterday each report would take 10-15 sec to run. Today however, the reports now take 1/2hr each. If I look at the task manager on the server when a report is 99% idle. The same server is used for SQL 2005 and SSRS and the database is local.

Any help appreciated.



SQL 2005 problem

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.