You got it. It's also designed for UNIX/ORACLE. Not sure about SYBASE.

Unfortunately I have not worked much with the compilation counters so I don't know how to measure good or poor performance. I found three blogs indicating a value of...

Thanks Gail. I do appreciate your help.

I've been running SQL Compilations/sec, but not recompiles. I added it to the trace.

Over a 16 hour period the following values were...

Good to know who he is. Thanks. I'll keep that in mind when I read other blogs/white papers he has authored.

I'll check the compilations. The vendor just...

I agree about the L2 cache. However, he did send an MSDN blog link that does back what he is saying, although who is to say the author is...

32GB of memory.

They have a lot of dynamic code executed from their application servers. If I understand you correctly the dynamic code will cause low cache hits. Correct?

I...

One good thing that came out of our phone call was an executable called cpu-z that reports CPU information, including L2 cache. It's found at http://www.cpuid.com/. He said...

Let's see how you like this one. I just spoke with a technical contact for the vendor regarding various topics and on the subject of enabling AUTO_UPDATE_STATISTICS_ASYNC he said,...

I don't want to say the name. I'm not sure the trouble that could get me or our company in. 🙂

We've traced the deadlocks and provided the vendor with...

That's what I wanted to confirm. They just added this statement to their technical document in January after we started complaining about deadlocks a month or two earlier. ...

That's was a real brain cramp on my part. Must be the -20 freezing my brain this morning.

Unrelated to this post (and I should probably start a new thread),...

I thought he was referring to a different article. The one he referenced in this chain doesn't state that auto grow will disable proportional fill. Regardless I'm still...

What's the name of the Microsoft article that talks about auto grow not using proportional fill? Better yet do you have the link?

Currently we have 8 data files spread...

If this happens to us again I will call Microsoft.

Thanks Grumpy. I already told my manager it will take several weeks to get some proper analysis of the fillfactors currently set by the vendor. The problem is...