O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required