We have configured AlwaysOn Availability Group with 3 node in Sync mode. The primary server got 16 core while the replicas have 10 core each. We have tempdb contention issue, just wondering if we can have different number of tempdb data files on nodes in Availability Group or do we have to have same number on each node. It is SQL Server 2016 Enterprise Edition. Thanks in advance for help.
2
-
2Is it a TempDb contention issue or a TempDb performance issue? It would be surprising to have a TempDb contention issue on SQL 2016 with 10 TempDb files.– David Browne - MicrosoftCommented Nov 10, 2017 at 16:31
-
No we have not got 10 tempdb files but 4 on each replica, was planning to increase it to 8 on each. Thanks– SajidCommented Nov 14, 2017 at 10:32
Add a comment
|
1 Answer
There is not a problem with having different numbers of tempdb files on each machine, you just need to be aware that should you failover to one of the machines with fewer files that you will run into the contention problem that you worked to alleviate on the new server.
