October 8, 2013 at 12:15 pm
In our production server, tempdb is growing suddenly to 400GB (Earlier, it will reach maximum 210GB). There is no changes at server level or database level.
But, It is not happening in another server where the server configuration is same as production server.
Below the more information,
Server is SQL server 2008 R2 and this server always executing some stored procedures (15 sessions simultaneously) which will push data into web server.
Can someone help?
October 8, 2013 at 1:30 pm
A couple of questions:
Is the growth due to the log file or the data file in TempDB?
Are you using Snapshot Isolation?
Have you checked for long running transactions?
What have you done so far to diagnosis the issue?
Once you find the issue you will have to look into a potential VLF issue too.
October 8, 2013 at 11:58 pm
Check for any active transactions which is using Temp db .
Cheers
Shamanth
October 9, 2013 at 6:30 am
index renuild / reorganize job or maintenance done with option (SORT_IN_TEMPDB = ON)
OR
ONLINE = ON
?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 9, 2013 at 6:38 am
There are multiple things to look for. In addition to above you can also check if tempdb is growing at the time of any maintenance?
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply