My site is currently down. When users try to view a report they get
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Could not allocate space for object 'ChunkData' in database
'ReportServerTempDB' because the 'PRIMARY' filegroup is full.
It was working fine until I loaded a new report a few days ago the
ReportServerTempDB when from a mere 400MB to 2.5GB. How can I fix this
please? I can't seem to find any info on this.
ThanksThis is a multi-part message in MIME format.
--=_NextPart_000_000B_01C71267.EA8848C0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Seems like your temp db is full. Try doing a transaction log backup with =truncate to shrink it.
Not quite sure what would cause the temp db to fill up like that, =though. Shrink it first, then you could run SQL Profiler against that db =do see what sort of statements that increases it so much over time.
Some of these articles might be usefull to you:
How to stop the transaction log of a SQL Server database from growing =unexpectedly
http://support.microsoft.com/kb/873235
Planning for Scalability and Performance with Reporting Services
http://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.mspx
How to Performance Tune the Microsoft SQL Server tempdb Database
http://www.sql-server-performance.com/tempdb.asp
Kaisa M. Lindahl Lervik
"Chris" <Chris@.discussions.microsoft.com> wrote in message =news:9A24D6A4-E0E3-4540-8906-94C26EB7E6A2@.microsoft.com...
> Hi,
> My site is currently down. When users try to view a report they get
> > An internal error occurred on the report server. See the error log for =more > details. (rsInternalError) Get Online Help
> Could not allocate space for object 'ChunkData' in database > 'ReportServerTempDB' because the 'PRIMARY' filegroup is full. > > It was working fine until I loaded a new report a few days ago the > ReportServerTempDB when from a mere 400MB to 2.5GB. How can I fix this =
> please? I can't seem to find any info on this.
> > Thanks
--=_NextPart_000_000B_01C71267.EA8848C0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Seems like your temp db is full. Try =doing a transaction log backup with truncate to shrink it.
Not quite sure what would cause the =temp db to fill up like that, though. Shrink it first, then you could run SQL Profiler =against that db do see what sort of statements that increases it so much over time.
Some of these articles might be usefull =to you:
How to stop the =transaction log of a SQL Server database from growing unexpectedly
http://support.microsoft.com/kb/873235
Planning for Scalability and Performance =with Reporting Services
http://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.m=spx
How to =Performance Tune the Microsoft SQL Server tempdb Database
Kaisa M. Lindahl Lervik
"Chris"
--=_NextPart_000_000B_01C71267.EA8848C0--
No comments:
Post a Comment