The problem with a lot of the perfmon counters and a recommended value is that so much of it depends on the system where you're running them. For example, I/O...

Piling on a little bit, I think Steve sells himself a little short. Basically, if I wanted to learn something in or around SQL Server, he lists the three sources...

CirquedeSQLeil (10/5/2010)

---

Grant Fritchey (10/5/2010)

---

I carve time out of my day, at work, to make sure I'm learning stuff. I read a bit, test a bit, write a bit, at work,...

That's because we can see...

Steve Jones - SSC Editor (10/5/2010)

---

I see this a lot, even with authors. People think you are following along with them, or they don't realize they're skipping steps to...

I wouldn't try it that. Instead, script out the 2008 database to a script or set of scripts. Then you can run those on the 2005 instance, fixing what you...

Men want to stop playing these games and just do the job.

Will that day ever come?

Exactly what Gail says. You can use the list she provided earlier as the basis for your server side trace.

tt-615680 (10/5/2010)

---

Yes, I know there are many queries or sysyem sp's that cannot be used...

Then all you've got to do is run a search through Google or Bing. Here's one. First thing listed is, again, Microsoft training. Going to the source never hurts.

tt-615680 (10/5/2010)

---

GilaMonster (9/29/2010)

---

The default trace does...

I don't know that there's any one place to get advanced training online (meaning for free). But there are several places you can go. Microsoft has a number of courses...

I carve time out of my day, at work, to make sure I'm learning stuff. I read a bit, test a bit, write a bit, at work, so that I'm...

Welcome to the party. Keep your hands and feet inside the vehicle at all times.

Yeah, the ability to run a search engine should probably be one of the most introductory...

I'm still of the opinion that you are either not connecting to the correct database, or your security doesn't allow you to see those procs. It's also possible that they're...