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
    Is 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. Nov 10 '17 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
    – Sajid
    Nov 14 '17 at 10:32

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.