Monitoring performance of TempDB database
We know that the TempDB database is one of the system databases in SQL Server and SQL Server heavily depends on TempDB for its normal functioning. Therefore, monitoring performance-related statistics of TempDB database is very important. Quite a few times, we see that people just don't care about TempDB database and tend to ignore looking after its performance. This is not a good idea because the reasons for SQL Server's inefficient performance may be hiding behind the suboptimal performance of TempDB database. That's why you should consider monitoring TempDB database time-to-time.
You should know that SQL Server uses TempDB database while performing certain kinds of operations on a large data. Some of ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
