Using local ssd for tempdb cant add files

Question

Using local ssd for tempdb cant add files

tcronin 95651

SSCertifiable

Points: 6735
More actions
April 15, 2016 at 6:27 am

#326447

Installed sql 2012 ent edition on new cluster. Have local SSD in each physical node for tempdb. All went well cluster is up. Needed to add more files to tempdb (have 16 core) and I discover that when drive selection for tempdb comes up the local drive (T in this case) does not show up as a choice to add file. ANyone who has done the local ssd for tempdb run into this?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

since this is on a cluster, pretty sure you cannot use local disks to each box, regardless of whether they are SSD's or not ; only drives that are shared across the cluster, right?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

tcronin 95651 SSCertifiable Points: 6735 More actions · Answer 2

tcronin 95651

SSCertifiable

Points: 6735

April 15, 2016 at 7:13 am

#1872338

no this is new feature of 2012

Michael L John One Orange Chip Points: 27065 More actions · Answer 3

Lowell (4/15/2016)
since this is on a cluster, pretty sure you cannot use local disks to each box, regardless of whether they are SSD's or not ; only drives that are shared across the cluster, right?

Not true.

We have a local drive on a three node cluster for tempdb.

Each of the physical servers have a local T: drive, which contains folders for each instance.

It appears that the local drive has not been added to the cluster.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

tcronin 95651 SSCertifiable Points: 6735 More actions · Answer 4

The tempdb is actually there and working I just wanted to add another file to tempdb. So at the cluster level tempdb on the local storage is working, just can add extra files

Michael L John One Orange Chip Points: 27065 More actions · Answer 5

What error are you getting? Does the service account have the correct permissions to the drive / folder?

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

tcronin 95651 SSCertifiable Points: 6735 More actions · Answer 6

it is not an error but when you go to file properties in tempdb and choose add a file and select the elipse it does not show the T drive which has the current tempdb files now. No error just no drive. Going to try command line later