Report Server.

Hi,
We are using a live database, which is growing rapidly.Keeping performance
at acceptable level is critical.
We are considering a second server(mirror of the live data - up to 30
minutes offset is acceptable) - for running costly queries,mainly for
reports.
What are the options we could use to maintain a mirror ?
Any suggestions will be greatly appreciated. The live database is a SQL
Server 2000 Enterprise SP 3a (Clustered) on Windows 2003 Server Enterprise
SP1 (Cluster).
Regards.
SezginTransaction Replication for SQL Server 2000 is probably the best option. Log
shipping or backup/restore don't tend to work well as the database on the
'reporting' server is unavailable when the restore takes place.
Nick Grattan
www.nickgrattan.net
"Sezgin Rafet" wrote:
> Hi,
> We are using a live database, which is growing rapidly.Keeping performance
> at acceptable level is critical.
> We are considering a second server(mirror of the live data - up to 30
> minutes offset is acceptable) - for running costly queries,mainly for
> reports.
> What are the options we could use to maintain a mirror ?
> Any suggestions will be greatly appreciated. The live database is a SQL
> Server 2000 Enterprise SP 3a (Clustered) on Windows 2003 Server Enterprise
> SP1 (Cluster).
> Regards.
> Sezgin
>
>|||Thanks for the reply. Is there any 3rd party software producing the effect
of Transactional Replication, being easy to set up and maintain ?
Any links to good step by step guides for Transactional Replication will
also be appreciated. I suspect it's a difficult job to set up and maintain
Transactional Replication, but I may give it a try.
Regards.
Sezgin
"Nick Grattan" <NickGrattan@.discussions.microsoft.com> wrote in message
news:21B5A6A2-67A7-4EF1-9C19-E631531D8194@.microsoft.com...
> Transaction Replication for SQL Server 2000 is probably the best option.
> Log
> shipping or backup/restore don't tend to work well as the database on the
> 'reporting' server is unavailable when the restore takes place.
>
> --
> Nick Grattan
> www.nickgrattan.net
>
> "Sezgin Rafet" wrote:
>> Hi,
>> We are using a live database, which is growing rapidly.Keeping
>> performance
>> at acceptable level is critical.
>> We are considering a second server(mirror of the live data - up to 30
>> minutes offset is acceptable) - for running costly queries,mainly for
>> reports.
>> What are the options we could use to maintain a mirror ?
>> Any suggestions will be greatly appreciated. The live database is a SQL
>> Server 2000 Enterprise SP 3a (Clustered) on Windows 2003 Server
>> Enterprise
>> SP1 (Cluster).
>> Regards.
>> Sezgin
>>

Report Server Execution Log

Hi
Can enabling the Report Server Execution Log from the Site Settings affect the performance of the reports ?
Thanks
of course, but from what I've see, the act of logging is really invisible as far as a slowdown goes.|||

Also, you have the option to remove logs older than X days

not that it affects the performance really

We also have a SQL job that runs nightly, calling the SSIS package

C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report Samples\Server Management Sample Reports\Execution Log Sample Reports\RSExecutionLog_Update.dtsx

I think it's from the RS template to display the RS Execution Log in graphs