November 10, 2009 at 5:48 am
Guys I've heard a lot of talk around creating multiple data files to increase performance of such databases as the tempdb. In most of these discussions I always here talk of spreading the files out amongst different physical raid sets. Well I would like to ask do you get any benefit from creating multiple disk files if you don't have multiple luns to spread them over? Thanks in advance
November 10, 2009 at 6:49 am
The whole reason for creating multiple files (in user databases) is to spread the IO load out over multiple drives, usually because the original drive(s) are maxed out. Creating multiple files on the same drive is highly unlikely to give you any form of performance gain, as you're not spreading out the IO load. Also, if the current bottleneck is not IO, then multiple files probably wouldn't help anyway.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply