SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Tempdb on a nonclustered resource in the SAN


Tempdb on a nonclustered resource in the SAN

Author
Message
Jan-1080019
Jan-1080019
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 22
Hi,

We are running a database on a stretched cluster with a SAN. The tempdb is on a clustered disk and is replicated to the other site. This seems completely wasted to me, since when after failover the database restarts on the other site and recreates the tempdb.

When I search this forum, I find that it wouldn't be possible and that someone had a message like this:

Only formatted files on which the
cluster resource of the server has a dependency can be used.
Server: Msg 5184, Level 16, State 1, Line 2

And of course a dependency is only possible on clustered resources.

Is there somebody who has found a solution for this? We are using SQL 2005 on Windows 2008.

thanks,
Jan
DNA_DBA
DNA_DBA
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3158 Visits: 2770
SQL Server can only use the disk resources defined in the cluster so I think you're stuck with putting tempdb on a clustered drive
happycat59
happycat59
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4773 Visits: 3222
Cluster Resources are used to define everything required for the service to work correctly. The clustering software monitors the availability of everything in the cluster resource and when something become unavailable, a failover to a standby node in the cluster can be initiated.

If you were able to create TEMPDB on a device that is not a cluster resource, it is possible for the resource to fail and since it is not managed within the cluster, when the service is initiated on the standby node, you will not be able to start it. This kinda defeats the purpose of the cluster. This will probably result in another failover back to the first node and on it goes.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search