Would like to move the tempdb to another drive. What size should I make this
drive to accomodate for my SQL server? I am unsure how many databases we will
have and their sizes. I segregated logs from data files and would do the same
for tempdb.

Hello,

Tempdb needs to be big enough to handle the following processes for every
SQL Server:.
That depends up on the data usage and the below considerations:-

1. Worktables for merge joins
2. Worktables that are created for distinct, group by, and order by, and
subqueries
3. Temporary tables (those created with "#" as the first character of their
names)
4. Indexes on temporary tables
5. Regular user tables in tempdb

Please make sure that you create a Tempdb with sufficient space. Auto growth
during online will affect performance

Thanks
Hari

"George" <George@discussions.microsoft.com> wrote in message
news:4FE0A24F-8D6D-4AEF-8150-BE58DCEE8B55@microsoft.com...
> Would like to move the tempdb to another drive. What size should I make
> this
> drive to accomodate for my SQL server? I am unsure how many databases we
> will
> have and their sizes. I segregated logs from data files and would do the
> same
> for tempdb.

Thanks Hari. But can you just sugest the size as I don't have any of that
info? What is usualy size of tempdb for lets say 50GB database?

"Hari Prasad" wrote:

> Hello,
>
> Tempdb needs to be big enough to handle the following processes for every
> SQL Server:.
> That depends up on the data usage and the below considerations:-
>
> 1. Worktables for merge joins
> 2. Worktables that are created for distinct, group by, and order by, and
> subqueries
> 3. Temporary tables (those created with "#" as the first character of their
> names)
> 4. Indexes on temporary tables
> 5. Regular user tables in tempdb
>
> Please make sure that you create a Tempdb with sufficient space. Auto growth
> during online will affect performance
>
> Thanks
> Hari
>
> "George" <George@discussions.microsoft.com> wrote in message
> news:4FE0A24F-8D6D-4AEF-8150-BE58DCEE8B55@microsoft.com...
> > Would like to move the tempdb to another drive. What size should I make
> > this
> > drive to accomodate for my SQL server? I am unsure how many databases we
> > will
> > have and their sizes. I segregated logs from data files and would do the
> > same
> > for tempdb.
>
>
>

Hello,

It is very difficult to suggest a size blindly. So probably you can size
the tempDB to 4 GB MDF and 4 GB LDF files.
Instead of creating a single file create files based on ur CPU availability.
If yours is 4 CPU machine then create 4 data file
which is 1 GB each. LDF file can be a single file.

Thanks
Hari



"George" <George@discussions.microsoft.com> wrote in message
newsE900894-4BF1-4C26-B03F-90A850B4CC37@microsoft.com...
> Thanks Hari. But can you just sugest the size as I don't have any of that
> info? What is usualy size of tempdb for lets say 50GB database?
>
> "Hari Prasad" wrote:
>
>> Hello,
>>
>> Tempdb needs to be big enough to handle the following processes for every
>> SQL Server:.
>> That depends up on the data usage and the below considerations:-
>>
>> 1. Worktables for merge joins
>> 2. Worktables that are created for distinct, group by, and order by, and
>> subqueries
>> 3. Temporary tables (those created with "#" as the first character of
>> their
>> names)
>> 4. Indexes on temporary tables
>> 5. Regular user tables in tempdb
>>
>> Please make sure that you create a Tempdb with sufficient space. Auto
>> growth
>> during online will affect performance
>>
>> Thanks
>> Hari
>>
>> "George" <George@discussions.microsoft.com> wrote in message
>> news:4FE0A24F-8D6D-4AEF-8150-BE58DCEE8B55@microsoft.com...
>> > Would like to move the tempdb to another drive. What size should I make
>> > this
>> > drive to accomodate for my SQL server? I am unsure how many databases
>> > we
>> > will
>> > have and their sizes. I segregated logs from data files and would do
>> > the
>> > same
>> > for tempdb.
>>
>>
>>