Chapter 12. Build your own SQL Server 2008 performance dashboard

Pawel Potasinski

Have you ever seen any of the fantastic applications for monitoring performance of database systems? How wonderful your life as a DBA would be if you could sit in your chair, looking at a big screen full of information showing how your server and databases are performing and, what’s even more important, how to react when an issue occurs. This is why powerful tools for monitoring SQL Server databases are popular and worth their price.

But what if the budget doesn’t allow you to buy any additional software and you have to rely only on the information that SQL Server itself gives you? The purpose of this chapter is to give you some ideas on how to use SQL Server ...

Get SQL Server MVP Deep Dives Vol. 2 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.