Master of the Obvious.
On a heavy OLTP environment, I'd recommend having one tempdb database file for each physical core on the server.
So, if there are eight cores, create an additional seven tempdb database files.
If possible, split out the files across muliple disk groups.
No comments:
Post a Comment