TempDB is one of the most important system databases of SQL Server.
There are many database operations in TempDB like GROUP BY, ORDER BY, UNION, online re-indexing, multiple active record sets, user-created temporary objects, internal temporary objects and version stores.
So if the tempdb is located on slow disk like sas or sata, these operations will be very slow.
If TempDB is located on fast disk like SSD or Flash, you will see extra SQL Server Performance.
You can change TempDB file location like following query.
USE master GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'E:\TEMP\tempdb.mdf') GO
Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.
1,897 views last month, 1 views today
Thank you a lot for providing individuals with an extraordinarily marvellous chance to read in detail from this blog. It is usually so superb and stuffed with fun for me personally and my office acquaintances to visit your site at least thrice weekly to see the fresh secrets you have. And definitely, I am always fascinated with all the unbelievable suggestions served by you. Certain 3 points in this article are certainly the simplest we’ve ever had.