SQL Server TempDB files on server with NUMA processors
Posted on 2012-08-16
We are setting up a new server for SQL Server 2008 R2. The server has 128 GB RAM. When I look in Task Manager, it shows 80 processors. I looked in resource monitor and it shows 4 NUMA sockets with 19 nodes in each socket.
So my question is, how many TempDB files should we configure? Currently we have it at 4 but I'm not sure how to configure with this many / type of CPU. I've not worked with a machine with this type processors before. Since MS basically recommends 1 tempdb file per core, how many should be use? What is the definition of a core in this scenario?
Let me know if you need more information.