title: How to add the tempdb data files automatically depending on the number of CPU core count available
body: <p>If there are less number of data files in the tempdb then we would have noticed that there could be issue in performance and queries will go for pagelatch_up waitType.<br />
  And we need to manually add the data files by checking the number of cores available. Instead of adding manually I found automatic the scirpt completely will help everyone so I came with some script which might help everyone with less knowledge on SQL server database alter commands.</p>