01Apr 2008 by Grant Fritchey 1 Comment

Performance Studio

Tools
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…
Read More
01Apr 2008 by Grant Fritchey 4 Comments

SQL Data Generator

Tools
I just received word from Rachel Hawley over at RedGate that SQL Data Generator has been released. I've been using the beta over the last few months and I've found it incredibly useful for setting up tests and playing around with my database designs, seeing how different data loads will be distributed through the indexes, etc. It's quick to use but fairly powerful and flexible and, frankly, pretty inexpensive. I strongly recommend it.
Read More
01Apr 2008 by Grant Fritchey 8 Comments

SCOM Problem

Tools
I'm stuck. I posted this last week on the Microsoft SCOM newsgroup, but I'm not getting any responses. On the off chance that the 5 people a day who read this site might know the answer, here's the question as posted: I'm sure this is something fundamental and simple, but I'm honestly stuck. I'm attempting to capture a new Performance Counter, Plan Cache, Cache Hit Ratio, Object Plans & SQL Plans. When I lay it out to create it, I get the attached error. I'm assuming based on the "Unknown alias" and the fact that I'm in a custom management pack, something is amiss with the Management Pack. What? Any help at all would be appreciated. Date: 3/28/2008 11:29:55 AM Application: System Center Operations Manager 2007 Application Version: 6.0.6246.0 Severity:…
Read More