18Dec 2008 by Grant Fritchey 15 Comments

Profiler Research

SQL Server
A question came up on SQL Server Central as to why or how Profiler could bring down the production server.  I was aware of the fact that Profiler caused problems and that's why you should always use a server-side trace on production systems. Duh! Of course.... But why? I didn't have an answer. I just "knew" what everyone told me. So I set out to do some research. Initially I hit my favorite source of information on SQL Server (and it should be yours too) the Books Online. Here is what I was reading on the architecture of Profiler. Good, but not enough. I still want more information, so I've gone out a'wanderin' through the interwebs. First, Linchi Shea has this great set of tests comparing Profiler to server side…
Read More
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