All about Tempdb TempDB Basics TempDB is one of the critical system databases that need to be configured carefully otherwise the performance of your application may suffer. I am not suggesting that the current implem…
Use sys.dm_os_performance_counters to get your Buffer cache hit ratio and Page life expectancy counters