Basically you install the management pack and you're off & running. But, you'll need to adjust the alert levels, etc., for your system. You'll also want to review the counters...

Jeff Moden (11/30/2010)

---

Changing subjects, have you seen today's featured script? It comes under the category of "Are the featured scripts getting worse"? I try to be tolerant but...

Yes, but how often is that occurring? In production...

Not only is it running on SQL Server, but you can watch the monitoring on the system, live, from here[/url]. Check out how well it operates and see Red Gate's...

You're going to learn different things in different places. Small companies will give you a lot more breadth of knowledge because you won't be able to specialize in any one...

Yeah, I haven't seen corrupt stats, so I'm curious how they evidence as well.

Without the code and structures it's hard to know, but based on what you described, it sure sounds like all you need is a simple join to bring back the...

Unless there's something you're not listing here, there's no reason to go with temp tables in the query you've shown.

Just piling on to this one to reinforce the message.

Exactly! I regularly have to remind our...

Your choices are limited. Add a file to the filegroup that's on another drive, or remove things from the existing file group. That's it.

If you don't have monitoring in place...

Interesting question. I don't think that you can. If you look at the events that capture any form of execution plan, none of them allow for the duration column, so...

Unless you get incredibly sophisticated with your search algorithms, possibly using CLR or something, to determine if the string you're looking at is contained within a comment, of either type,...

I agree, more often than not cursors are the wrong approach to take when dealing with data.

Just so you can figure out what's happening though, elminate the cursor from the...

No, there's no real way to link TSQL and Management Studio. Management Studio uses TSQL, it's not used by TSQL, so statements issued in TSQL won't affect SSMS. To modify...

There are several queries in this MSDN entry that might help you figure out exactly what you need.