September 29, 2014 at 12:26 pm
If Report server tempdb logspace used is 93%, Do we need to restart the server?
September 30, 2014 at 7:57 pm
What's the recovery model of the report server tempdb ?
That should point you in the right direction ....
In any case large or full log files are no reason to restart the server
October 2, 2014 at 12:48 pm
ramana3327 (9/29/2014)
If Report server tempdb logspace used is 93%, Do we need to restart the server?
A reboot may temporary fix the problem but you need to find out which query is filling tempdb. As a matter of fact, you need to investigate and confirm if it is your Report Server. If it is sharing the SQL instance with other databases, it could be any other client or query and not Reporting Services.
I use DBCC open tran (if the issue is happening real time) to find the spid of an open transactions that may be filling tempdb.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply