Question of the day : Multiple tempdb data files will gain performance?


Do splitting tempdb data files according to the number of processors will gain performance improvement? I am more interested to hear about this.

Advertisements

2 thoughts on “Question of the day : Multiple tempdb data files will gain performance?

  1. The optimal solution is yes,but it depends on your work load(Too many TempDB data files (like one per core on an 80-core system).
    #datafiles=No.of cores/2

    Note:SQL Server recommends that you create as many files as there are COREs or CPUs to minimize allocation bottlenecks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s