We help IT Professionals succeed at work.
Research Question

add Windows cluster disk to Windows cluster and change tempdb files to new cluster disk

28 Views
Last Modified: 2020-10-19
hi,

we trying to add new SAN disk to the existing windows cluster 2016 and move SQL server 2016 standard edition FCI tempdb files to this new SAN disk, any procedure for it?

The change of tempdB file we just ALTER the tempdb path?

any concern on doing this on SQL server 2016 STANDARD edition FCI ?
Comment
Watch Question

Retired
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
marrowyungSenior Technical architecture (Data)

Author

Commented:
any way in SQL server to see easily if the disk exists and can be used by SQL 2016 standard FCI ?
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Not sure I understand your question' you can use icacls to check permissions onthe existing SQL disk resource and make sure the sqlserver group security is reflected on the new resource.

Usually if you use GUI, you can do a backup of a db, and you will see the disk resources local to the system. Though it might be able to distinguish between SQL San resource and a local node resource.
marrowyungSenior Technical architecture (Data)

Author

Commented:
Not sure I understand your question' you can use icacls to check permissions onthe existing SQL disk resource and make sure the sqlserver group security is reflected on the new resource.

should I say as long as the cluster disk can be see in the primary nodes in OS level then SQL server can surely use the disk ?

CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
As long as the disk resource is part of the application cluster group, it should follow from node to node.
I usually test the resource as it is not unusual to err during a setup on the SAN. Depending on how resources, hosts are managed.
Depending on the SAN and whether GROUPs are available to which hosts are added and to which LUNs are allocated.
To mitigate impact of Murphy's Law. I confirm the resource moves with the application cluster before relying on it.

Not sure if it was you, but there was an SQL cluster discussion on EE in which I participated that the person had a cluster where the transition used different storage resource......
marrowyungSenior Technical architecture (Data)

Author

Commented:
Depending on the SAN and whether GROUPs are available to which hosts are added and to which LUNs are allocated.


you mean which node is the owner of the new added clustered disk? once it is owned by current node the node can see in File explorer ?

Not sure if it was you, but there was an SQL cluster discussion on EE in which I participated that the person had a cluster where the transition used different storage resource......
you can share you EE discussion here.

CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
marrowyungSenior Technical architecture (Data)

Author

Commented:
If two hosts access the same LUN at the same time, neighter is aware of the changes the other is making. This is what can lead to corruption. I.e. Both write data to the same location.

so only one nodes can access it per unit time !

CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Usually for a SAN, yes.
marrowyungSenior Technical architecture (Data)

Author

Commented:
tks all. might be back if there is some detail I need

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions