Increasing tempdb data files on 2 node Availability Group
0
votes
1
answer
351
views
I am planning to create additional tempdb files for 2 nodes in a SQL 2012 Availability Group. Unfortunately we do not have Instant File Initialisation turned on so the growth of the tempdb data files will be subject to PREEMPTIVE_OS_WRITEFILEGATHER waits for up to 30 minutes (based on testing).
I am concerned that these waits will affect the application/user experience so here is my proposal.
- Make the change on Node B
- Disable synchronisation
- Failover to Node B on successful completion
- Make the change on Node A
- Fail back to Node A on successful completion
- Enable synchronisation.
Does anyone see any issues with this ?
Thanks
Asked by zapcon
(73 rep)
Apr 29, 2018, 03:39 PM
Last activity: Feb 15, 2025, 02:10 PM
Last activity: Feb 15, 2025, 02:10 PM