posts - 4238, comments - 3946, trackbacks - 370

My Links


Subscribe Subscribe

image image image

This is my personal weblog. These postings are provided 'AS IS' with no warranties, and confer no rights. The views expressed on this weblog are mine alone and do not necessarily reflect the views of my employer.

Licenza Creative Commons

Tag Cloud


Post Categories

Configuring TempDB for Optimal TFS Performance

Ottimizzare TFS significa soprattutto ottimizzare le tecnologie su cui si basa (AD, Sql, WSS, etc...).

In questo post si parla dell'ottimizzazione del TempDB

So here are some pointers found during our testing:

1. Manually grow TempDB - ... SQL Server reverts back to the original TempDB size upon re-start - thereby you incur the cost again after every restart...

2. Use multiple equal sized data files - if you are using a multi-processor data tier, use N equal sized data files (when N is the # of processors, the sum of all the data files can equal 20% of all your databases)...

Fonte: Configuring TempDB for Optimal TFS Performance

Print | posted on martedì 10 gennaio 2006 23:18 |

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET