Sample Header Ad - 728x90

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