sql server reporting services: Performance Reporting Services 2000 -- sql server reporting services

Performance Reporting Services 2000

Robert Bernheim
11/15/2006 9:38:54 AM

sql server reporting services:

We are currently looking into to the performance of a system that utilizes
Reporting Services 2000. Can anyone point me to how to reduce response time
in generating reports? We generate 5 tabs of reports one for each business
unit and corp can see all of them. Is there any way to cache in 2000 based
on roles? The data is updated in the middle of the month and reviewed the
last week of the month. Is there a way to prime or execute these reports at
the beginning of the day with a scheduled type of job. Any help with

Re: Performance Reporting Services 2000

aaron.kempf NO[at]SPAM gmail.com
11/15/2006 9:52:34 AM

instead of all of this bullshit caching talk; you should just be using
Analysis Services

much, much, much simpler architecture

-Aaron

[quoted text, click to view]

RE: Performance Reporting Services 2000

William
11/15/2006 2:10:03 PM

In report manageer, under execution, set your report to generate from a
snapshot. and then set the snapshot schedule as needed, possibly monthly on
day 16. After updating make sure to click on Apply button at bottom of
execution screen. Also if you want an initial snapshot, check option <Create
a snapshot of the report when the apply button is selected>, apply changes
and you are done.

History snapshots can also be created manually by clicking on a report's
history tab at top of page and choosing <New Snapshot>.

Hope this helps.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.