Hi all,

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

Please help....

Many thanks

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/SQLSer...?wa=wsignin1.0


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


"Tedi" <Tedi (AT) discussions (DOT) microsoft.com> wrote

Hi Geoff,

Thanks for the information

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


"Geoff N. Hiten" wrote:

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" <Tedi (AT) discussions (DOT) microsoft.com> wrote

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" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Hi Geoff,

than for the link - voted 1+

Regards
Ramazan

"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote

On Mar 6, 6:08*pm, "RCan" <noos... (AT) arcor (DOT) de> wrote:
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.

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.teplitsky.dba (AT) gmail (DOT) com> wrote

On Mar 6, 6:08 pm, "RCan" <noos... (AT) arcor (DOT) de> wrote:
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.