What is the largest you have ever seen tempdb grow? What is its current
size? Ideally, you would create multiple /identically-sized/ files on
multiple drives. It's hard to answer your question, other than to suggest
observing how much space it has needed, and guess how much more space you
might envision it will need.




"Doug" <Doug@discussions.microsoft.com> wrote in message
news:4ED804AE-1D9A-4C7F-9AE0-571ABA8A0C36@microsoft.com...
> If I split the tempdb mdb to a separate drive on our SAN, which I
> understand is a good practice, how can I determine the amount of space to
> allow on the SAN for this? We don't want to exceed the space of course,
> but
> also wouldn't want to assign more space if it'll never be used. How would
> you go about determining something like this?
>
> Doug