Wednesday, October 20, 2010

Microsoft Sql Server - How big should your tempdb be?

For those who wonder how big their tempdb should be or maybe just wondering why their indexes stay fragmented after running some rebuild/reorganisation scripts.

The tempdb needs to be larger than the largest index.

There's also a technique called Instant data file initialization that helps the tempdb expand more rapidly.

So if you have any rules / examples about this let us know.

No comments: