SQL Server 2008 and tempDB with SAN

Tedi

unread,

Mar 3, 2010, 5:40:01 AM3/3/10

to

Hi all,

Is it possible to place the tempDB on internal disk and the data on SAN?

Please help....

Many thanks

Geoff N. Hiten

unread,

Mar 3, 2010, 6:49:18 AM3/3/10

to

Not at this time. That is a feature under consideration.

You can vote for it on Connect if you wish. The product team actually takes
into account community feedback when deciding which features to implement.

https://connect.microsoft.com/SQLServer/feedback/details/532759/support-local-disk-location-for-tempdb-in-failover-cluster-installation?wa=wsignin1.0

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Tedi" <Te...@discussions.microsoft.com> wrote in message
news:35966F5F-074F-428D...@microsoft.com...

Tedi

unread,

Mar 3, 2010, 10:14:01 AM3/3/10

to

Hi Geoff,

Thanks for the information

Just for information, we don't cluster the database at this moment.

"Geoff N. Hiten" wrote:

> .
>

Andrew J. Kelly

unread,

Mar 3, 2010, 3:39:33 PM3/3/10

to

You posted in a clustering group so I am sure Geoff assumed it was with
clustering. If you are asking in general with no cluster then the answer is
certainly. You can place tempdb on any local or SAN attached drive you
like.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Tedi" <Te...@discussions.microsoft.com> wrote in message
news:35966F5F-074F-428D...@microsoft.com...

Geoff N. Hiten

unread,

Mar 4, 2010, 8:06:17 AM3/4/10

to

Yes. I did leap to that conclusion.

And Andrew is correct as usual. In a non-clustered environment you can put
SQL data on pretty much any storage.

I have even seen SQL databases put on thumb drives (only for demonstration
purposes).

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Andrew J. Kelly" <sqlmvpn...@shadhawk.com> wrote in message
news:ect3gGxu...@TK2MSFTNGP02.phx.gbl...

RCan

unread,

Mar 6, 2010, 6:08:18 PM3/6/10

to

Hi Geoff,

than for the link - voted 1+

Regards
Ramazan

"Geoff N. Hiten" <SQLCra...@gmail.com> wrote in message
news:ukoM8esu...@TK2MSFTNGP04.phx.gbl...

alen teplitsky

unread,

Mar 10, 2010, 3:16:01 PM3/10/10

to

On Mar 6, 6:08 pm, "RCan" <noos...@arcor.de> wrote:
> Hi Geoff,
>
> than for the link - voted 1+
>
> Regards
> Ramazan
>

> "Geoff N. Hiten" <SQLCrafts...@gmail.com> wrote in messagenews:ukoM8esu...@TK2MSFTNGP04.phx.gbl...

>
>
>
> > Not at this time. That is a feature under consideration.
>
> > You can vote for it on Connect if you wish. The product team actually
> > takes into account community feedback when deciding which features to
> > implement.
>

> >https://connect.microsoft.com/SQLServer/feedback/details/532759/suppo...

>
> > --
> > Geoff N. Hiten
> > Principal SQL Infrastructure Consultant
> > Microsoft SQL Server MVP
>

> > "Tedi" <T...@discussions.microsoft.com> wrote in message

> >news:35966F5F-074F-428D...@microsoft.com...
> >> Hi all,
>
> >> Is it possible to place the tempDB on internal disk and the data on SAN?
>
> >> Please help....
>
> >> Many thanks

we've done it, but it's not advised. you can trick windows and SQL
into thinking that local disk is a clustered resource. i forgot the
details, but i think you create a disk with the same letter on both
nodes, add it to the cluster and then SQL.

the downside is that if you failover you lose any data that is in
tempdb. this means a long running query will lose and data it created
and it won't be a smooth failover.

Geoff N. Hiten

unread,

Mar 10, 2010, 3:17:27 PM3/10/10

to

When SQL Fails over, tempdb gets recreated anyway. No different if it gets
created on new disks.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"alen teplitsky" <alen.tepl...@gmail.com> wrote in message
news:dcff9ba3-02da-4b93...@b7g2000yqd.googlegroups.com...