"Skc" wrote:

> Hi,
>
> We have a Dell PowerEdge with 12GB assigned to C.  We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
>
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
>
> Can you please tell me how we do this.  Maybe links on the web with step by
> step instructions would be useful.
>
> Skc

"Alejandro Mesa" wrote:

> You will find it in BOL, look for "Moving tempdb".
>
>
> AMB
>
>
> "Skc" wrote:
>
> > Hi,
> >
> > We have a Dell PowerEdge with 12GB assigned to C.  We have noticed that
> > Tempdb is around 5GB or 7GB in size and is killing performance.
> >
> > We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> > free) so that we do not cause any problems on C:\.
> >
> > Can you please tell me how we do this.  Maybe links on the web with step by
> > step instructions would be useful.
> >
> > Skc

"Skc" <S**@discussions.microsoft.com> wrote in message
news:3DA1E004-3A30-4524-BCE9-539F3EBF1123@microsoft.com...
> Hi,
>
> We have a Dell PowerEdge with 12GB assigned to C.  We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
>
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
>
> Can you please tell me how we do this.  Maybe links on the web with step
by
> step instructions would be useful.
>
> Skc