0

Getting PAGELATCH_UP:tempdb:1(PFS) with so many waiting queue. What can be solution?

We have two hexacore processors. Ideally how much tempdb can we create to handle this issue?

0

1 Answer 1

3

Kendra Little writes in How to Tell if You Need More Tempdb Files:

First of all, if you just have one tempdb file, consider adding more files as preventive medicine. Don’t go crazy with this. The formula recommended by Microsoft in KB 2154845 to use one tempdb data file for each logical processor up to 8 processors is a good place to start.

and:

Remember: this only applies to tempdb data files. You only need one tempdb log file.

Also remember that the tempdb data files will be used proportionally with their size. This means that you should keep the files equally sized.

Read the full article to learn more.

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