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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment