I just found out about some new functionality coming out in SQL Server 2008 called Performance Studio. It’s actually largely a framework around which you can build performance monitoring routines for an entire enterprise. This sounds terrific. I’m going to dig into a bit and make it my presentation for the Heroes {Community} Launch event at SNESSUG next week. Here’s a Technet webcast on the topic. Here’s a very nice blog entry over at SQLTeam (I suppose I should ad them to my blog roll) discussing the function of the Data Collector, the foundation for this new framework. Performance Studio only works with 2008 systems though, so that’s something to take into account. Although I see an interview with Brad McGehee that says it’s not enterprise ready. Another something to take into account.
Thanks for the nice comment about my data collector post. A bit more refined post for my SQLMag “EssentialBI” column can be found at http://www.sqlmag.com/Article/ArticleID/99420/SQL_Server_2008_Enter_the_Data_Collector.html
also a second great blog post can be found at http://www.ssas-info.com/VidasMatelisBlog/55_sql-server-2008-management-data-warehouse
Cheers
Derek Comingore