We recently stood up a production SQL Server 2014 Enterprise on a two-node Windows Failover cluster (Active/Passive). We had some SSD's laying around and decided to use them for the tempdb for one of the two instances hosted on this cluster. The thought was local storage plus SSD = win.
We did run Dsksp, SQLIO, etc to test this setup before going into production and everything checked out ok. However, once we got went live, we started to see significant I/O wait issues during (and only during) our nightly DB integrity check.
After trying a few things in an attempt to resolve the issue, we decided to move the tempdb off to our SAN storage--which cleared up the I/O wait issues.
We now want to remove the SSD from each node. Before we do so, I want to make sure I understand the process correctly.
These were local disks so they were not assigned as a cluster resource.
From what it appears, now that the tempDB has been moved, we simply need to remove the logical drive from the OS (i.e. take offline/delete), then delete the virtual disk from the RAID controller.
Is it this simple or do is there something more that needs to be in SQL or in the cluster configuration?
I have seen articles about removing shared storage, but nothing touching on local and since this is our first cluster, I want to make sure there isn't anything hidden that will cause down time or otherwise ruin our day.