dbTalk Databases Forums  

cluster and tempdb on c:\

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering cluster and tempdb on c:\

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss cluster and tempdb on c:\ in the microsoft.public.sqlserver.clustering forum.



Reply
Page 10 of 10 < 1 2 3 4 5 6 7 8 9 10
 
Thread Tools Display Modes
  #91  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: cluster and tempdb on c:\ - 03-30-2008 , 01:54 PM





Hank,

I am not sure why you posted this to the clustering group. Is this a
cluster? If so then it must be on one of the cluster resources which I would
assume to be D: & E:. But since I rarely see D: as a drive in a cluster I
am not sure which way you have it. In any case how many disks are there in
the Raid 10 and how much activity do you have in the user dbs and tempdb?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Hank Arnold (MVP)" <rasilon (AT) aol (DOT) com> wrote

Quote:
Tom Moreau wrote:
It is a good idea to have tempdb on a separate disk from your data.
However, in a clustered system, any data or log files *must* be on a
clustered drive - not a local one.

I have a SQL server with 3 RAID drives:

C: (Boot) 36GB RAID 1
D: (Log files) 36GB RAID 1
E: (Databases) 146 GB RAID 10

All drives are 15K RPM SCSI. Which would be best to store TempDb?

--

Regards,
Hank Arnold
Microsoft MVP
Windows Server - Directory Services


Reply With Quote
Reply
Page 10 of 10 < 1 2 3 4 5 6 7 8 9 10

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top