9GB log file generated

Hi
The reporting services is generating large log files of 9GB daily and using
all the virtual memory that all applications on my win2003 server stop
running. Application is running on sql server 2000 and Microsoft Report
Server SP1.
How do I go about trouble-shooting this?
--
Regards PatsyWhich report server log is getting up to 9GB?
Is it the ReportServerTempDB log or ReportServer log? (it better not be the
ReportServer log...)
Or do you mean the actual LOG files in the reportserver directory? (these
are text files)
One thing you can check quickly, make sure the ReportServerTempDB database
is set to simple recovery mode.
=-Chris
"Patsy" <Patsy@.discussions.microsoft.com> wrote in message
news:12B3FCC9-60A3-4F48-B1F0-385B5C2DA7D4@.microsoft.com...
> Hi
> The reporting services is generating large log files of 9GB daily and
> using
> all the virtual memory that all applications on my win2003 server stop
> running. Application is running on sql server 2000 and Microsoft Report
> Server SP1.
> How do I go about trouble-shooting this?
> --
> Regards Patsy|||This is a known issue. You could search this group for -- log hotfix.
One reply from MS said:
Ask product support for the fix associated with KB 885286.
I believe this is fixed in sp2
Patsy wrote:
> Hi
> The reporting services is generating large log files of 9GB daily and using
> all the virtual memory that all applications on my win2003 server stop
> running. Application is running on sql server 2000 and Microsoft Report
> Server SP1.
> How do I go about trouble-shooting this?
> --
> Regards Patsy

64-Bits Failover Cluster with two instances

We have xSeries 460(x3950-8878) IBM Machine , mounted at win2003 and sql 2005
64-bits.
At future processes, this machine will take over all distributed database
with many application.
The failover clauster is configured with Active/Active node and I read about
reconfigure processor and I/O Affinity and memory at sp_configure procedure
to measure up or , perhaps take a base line to avoid series problems about
performance.
so, any help, article or step-by-step to guide our future away.
Thanks.
Kris
Message posted via http://www.droptable.com
More Information:
Both machine have 128GB Ram and 32 processor (dual core).
Krisnamourt wrote:
>We have xSeries 460(x3950-8878) IBM Machine , mounted at win2003 and sql 2005
>64-bits.
>At future processes, this machine will take over all distributed database
>with many application.
>The failover clauster is configured with Active/Active node and I read about
>reconfigure processor and I/O Affinity and memory at sp_configure procedure
>to measure up or , perhaps take a base line to avoid series problems about
>performance.
>so, any help, article or step-by-step to guide our future away.
>Thanks.
>Kris
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-clustering/200707/1