HI Team,
IN SQL SERVER we have 8 cores, how many tempdb datafiles to be created.
How to create the tempdb datafiles, is it required to maintain seperate disk or we can keep in the data files disk itself.
By default it is in C:\ drive as mdf and LDF.
While creating the datafiles we need to create datafile as MDF or NDF files.
If needed while changing we need to change the default MDF as C:\ to another drive or leave as it is. and change the path for newly created datafiles.
Kindly help on this.
Regards
Narine M