SQL Server MVP Deep Dives, Volume 2
by Brad McGehee, Louis Davidson, Greg Low, Kimberly Tripp, Paul S. Randal, Kalen Delaney, Paul Nielsen
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access