Reinventing the SQL Monitor

SQL Server MVP Deep Dives 2, Chapter 12

Build your own SQL Server 2008 performance dashboard – by Pawel Potasinski (Blog|Twitter)

For this chapter Pawel Potasinski has done exactly what the title suggests. He lays out the steps to create a simple performance dashboard for SQL Server. He specified the version in his chapter title, but he clarifies that these steps can be “implemented on SQL Server 2005 and later (where CLR, DMV’s and SSRS are available).” That one sentence sort of gives away his whole strategy. He shows how to use a Common Language Runtime (CLR) function to get at operating system performance counters. He then combines this with SQL Server Performance counters from the dm_os_perfornamce_coutners DMV and uses a SSRS report to display them both.

Continue reading

Advertisements

Business Intelligence 201

SQL Server MVP Deep Dives 2, Chapter 60

BI Solution Development Design Considerations– by Siddharth Mehta (B|T)

This is the first chapter in Deep Dives V2 that I read which felt like I was reading a textbook. I really wanted this chapter to be something I could hand to a manager, DBA, or developer who hadn’t worked on a Business Intelligence project and they would come away with a good understanding of what it was and all of the pieces needed to build it. Essentially I wanted something the me from 3 years ago could have read and not have to learn everything on the job.

Figure 1 Typical BI design for an OLTP-to-dashboard solution from Chapter 60 of SQL Server MVP Deep Dives V2

Continue reading