Reports only render sometimes

I am experiencening the folowing problem with RS SP2. My reports do not
render all of the time, sometimes they run fine in a few seconds other times
they simply do not run. These are small reports with only a few hundred
records in the dataset.
They are using store procedures to generate the data and the stored
procedures always finish, so i am assuming it is at the rendering stages
where i am experiencing this intermittent problem.
Has anyone any idea where to start looking or diagnosing. I can see no
logic or pattern that is causing the reports to fail only sometimes.
I would be the most grateful man in the world if somebody could help.
--
Gerry ConnollyCheck the Reporting Services error logs and see if you see an "Assert" error
in there. If you do then it could be related to the AMD Cool N' Quiet
technology.
Add the following line to your boot.ini after your other boot switches and
see if that works.
switch: /usepmtimer
More information about this can be found here:
http://support.microsoft.com/kb/895980/en-us
--
SQL Server Developer Support Engineer
"GerryC" wrote:
> I am experiencening the folowing problem with RS SP2. My reports do not
> render all of the time, sometimes they run fine in a few seconds other times
> they simply do not run. These are small reports with only a few hundred
> records in the dataset.
> They are using store procedures to generate the data and the stored
> procedures always finish, so i am assuming it is at the rendering stages
> where i am experiencing this intermittent problem.
> Has anyone any idea where to start looking or diagnosing. I can see no
> logic or pattern that is causing the reports to fail only sometimes.
> I would be the most grateful man in the world if somebody could help.
> --
> Gerry Connolly