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, Volume 2 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.