MHilsher, I love your parable.

Feodor, I am aware of this issue of the script, but it not really that important for two reasons. First, most tempdb databases are smaller than 4 GB. And two,...

Matt Guthrie (6/6/2011)

---

Am I the only one who noticed that the write latency for TEMPDB was measured in *seconds*, not ms?

I would think 3.5 sec is a lot more worrisome...

currym (6/6/2011)

---

Brad,

I appreciate your work! I do have a question though.

With respect to monitoring SAN activity via an OS source (perfmon/sysmon), a while back I was discouraged from relying on...

Yes, this is the last of the series.

Peter Trast (5/11/2011)

---

I have never seen or heard of a best practice for separating system and user objects, although your explanation sounds good on the first read. Is this your...

jcrawf02 (5/11/2011)

---

Brad, re: the 8 TempDB files, I have no direct info here, but yesterday's SSC newsletter had a link to a blog by Eric Stephani (http://ericstephani.com/?p=166) where he was...

tgarland (5/11/2011)

---

Is there any possibility with having different collations across the databases that you could run into issues when running queries that cross databases especially involving joins? What about...

Fred Williams-487170 (4/13/2011)

---

Thanks for the article but can you supply some performance measurements to quantify the benefits of making those changes?

Otherwise statements like this:

" Just think of the resource...

Just recently, as I was speaking at SQLBits, I spoke to a DBA who said that about 5-6 years ago he went to work for a bank that had over...

JJ B (4/1/2011)

---

Thanks for taking the time to reply!

I think you have already answered this next question, but in case you have more to say, I'll go ahead and ask...

JJ B (3/31/2011)

---

QUESTION:

Maintenance of our server has been a discipline that has grown in fits and starts over the years. After reading your book, I realized that we are...

Steven O (3/9/2011)

---

I realize you wanted us to focus on settings we can see from the monitoring tool, but I am curious about instant file initialization, ad-hoc optimization, asynchronous update...

tgarland (3/7/2011)

---

Besides the obvious filegrowth setting issues mentioned previously, one thing I found was there was not much use of filegroups. One of the things I like to do...

GlennBerry (3/7/2011)

---

The main interesting thing I saw is that you are on Build 2714, which is fairly old (SP1 CU2). I would want to get SP2 CU2, Build 4272...