March 5, 2009 at 7:22 pm
I have tempdb files(4) in 2 drives mdf,ldf files in a drive where sql server is installed and ndf,second ldf file in another drive with good disk space.
I would like to know how sql server uses these files. we run really huge transactions which run for more than 12 hrs. IF such transaction run in the tempdb files where sql server is installed which has less disk that will be problem but if transaction run in the other drive which has enough disk space i am safe.
I want to understand how multiple files are used by tempdb.
thanks
March 5, 2009 at 7:47 pm
According to my knowledge, Sql server logs the transactions files where there is enough space. So according to me you are safe.
-Michael
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
March 6, 2009 at 6:31 am
Are you sure tempdb will log transactions in the file which they have enough space, no matter how many files we have.
Experts, please comment on this.
thanks
March 6, 2009 at 6:52 am
As long as you have space on any 1 mdf and any 1 ldf file(or the drive where they are residing if max size restriction is not there) then you need not worry.
MJ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply