Moving tempdb

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.
SkcYou 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|||there is an example in BOL, under "ALTER DATABASE", look for "Move the tempdb
database".
AMB
"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|||As I replied within .setup:
The steps are described within this KB article:
http://support.microsoft.com/?id=224071
--
Keith
"Skc" <Skc@.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.
> Skcsql