SQL Foundations

FOUNDATION is a 32-bit Windows® program that was created from the ground up using Microsoft SQL Server. SQL Server is a sophisticated relational database designed to give you maximum data management, security and reporting power.

1
Posts

95
Members

15
Followers

Topic menu

Stream CLIPP Knowledge

Emily White

Nov 9, 2017

Wanted to know if we need to have multiple files for tempdb, one for each cpu. Is that right?

Jeff Rathjen Nov 9, 2017

Not necessarily. It is not a blanket thing where it is true in every case. In fact, generally speaking, it is NOT true. The reason to go with multiple data files is if the number of latches for tempdb rise and become a source of contention. Otherwise, I wouldn't add multiple files, it can actually hurt performance.

ExpertConnect - Mentoring & Discussions

SQL Foundations

FOUNDATION is a 32-bit Windows® program that was created from the ground up using Microsoft SQL Server. SQL Server is a sophisticated relational database designed to give you maximum data management, security and reporting power.

Hidden Gallery