January 16, 2008 at 9:17 am
Hi Experts,
I have a job which is scheduled at midnight and am getting this Error from 1week everyday when use Dbcc Sqlperf i dont see any issue with the log file in tempdb usually its 16 17% but when i run this job in afternoon it succedds.And i been using this job from past 5 6 months and never had a issue like this..So can you guys please help me out to figure out what i am missing or whats wrong because i tried a lot and am not able to figure out whats going wrong
Thanks
Step ID1
Sql Severity17
Sql Message ID9002
Message
The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases [SQLSTATE 42000] (Error 9002) The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases [SQLSTATE 42000] (Error 9002). The step failed.
January 16, 2008 at 9:40 am
Are you actually out of disk where the temp log file lives?
January 16, 2008 at 7:13 pm
How long after the message do you run the DBCC SQLPERF and with which option(s)? Also how is your tempdb setup? What is the growth factor, and the space availability on the drive? What other processes are running at the same time?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply