those counters can be accessed through TSQL Queries. There is no set-up required. The Windows OS is maintaining that data for you all the time. Running the query simply accesses...

You're running into the basic problems with table variables. They don't have statistics. So, while coding in them looks very neat and clean, performance is a total bear. You're doing...

There are differences between the systems already identified. I suspect if you dig you'll find more. You can't have differences, especially as big as different service packs, and still expect...

Congratulations, and no you don't.

That is a weird one. Sorry I couldn't help.

I would pick up a copy of Louis Davidson's and Tim Ford's book. That will give you a bunch of the standard DMOs and how to use them.

Basically, if the compatibility level is set to a lower value than the current value of the server, you will have reduced functionality in that database.

First thing to compare between the three servers is the execution plan. If it's identical on all three, then you need to look at server settings. If it's different, first...

An execution plan isn't going to tell you that tempdb is 97% of usage. It's giong to tell you that you have index scans instead of seeks or a loop...

Kiara (6/9/2011)

---

Tom.Thomson (6/9/2011)

---

Kit G (6/8/2011)

---

Wearing boots with a kilt isn't a problem (as long as we have socks). But sandals and a kilt? Perhaps... maybe... in a Roman...

Some of the posts seem... less than original.

GilaMonster (6/9/2011)

---

Stefan Krzywicki (6/8/2011)

---

Kit G (6/8/2011)

---

Wearing boots with a kilt isn't a problem (as long as we have socks). But sandals and a kilt? Perhaps... maybe... in a...

Stefan Krzywicki (6/8/2011)

---

Kit G (6/8/2011)

---

Grant Fritchey (6/8/2011)

---

Finished my 3 mile contribution gotta go log it.

I hate to tell you this, but I wear sandals, sneakers & boots with kilts, but...

andykr-773587 (6/8/2011)

---

Sounds like I need to do some more digging here.

Thanks for the input though, I will report back if I find anything.

(When will you be out our way again?...

Itzik's books are some of the first I recommend. After that, get a copy of Kalen Delaney's book SQL Server Internals. Since you're just getting going, you might want to...