select ceiling(floor(@somevalue) / 5.0) * 5.0

Yep, the link Tommy has provided is the fix for the issue he and I were having.

We have not yet updated to CU4, as we're still seeing issues with...

We may go to CU4, but we're still investigating general performance issues on the 2012 RTM instance.

I have a good amount of data that can be repeatably produced by...

By way of comparison, here's what it was on SP1 without the private fix. Also three days.

As a reminder, this is a 40 physical core, 4 NUMA node, 128 gig...

Er, just noticed I had cut off the X axis markers. That graph represents about 3 days.

Thanks for the detailed information on those trace flags. I also eagerly await the blog post.

In an ideal world I would definitely be running replays on our lab environment to...

My apologies, I have been off the forum for a while and...

We haven't seen much of a problem with foreign memory requests, but it's an interesting idea. We did set up a lab a couple of weeks ago with a premiere...

2012 RTM is definitely better than SP1. No CU's applied, although if you go to 7 it should be OK, apparently this specific problem appeared with SP1.

Having said that, in...

I'm not 100% convinced. We only had one weekday with the hotfix installed, but this graph of timeouts captured on the application servers seems to indicate pretty clearly that RTM...

Haha, likewise. The problem is a version incompatibility between sqlservr.exe and sqlaccess.dll. We've just been sent a link to an updated one, but we had already decided to roll...

For mine, we received a private build, basically a direct copy over the sqlservr.exe and a few dll's. It took us to the following @@version. Tommy, I'd be curious as...

We have been looking at a similar problem, you can find my thread on it here http://www.sqlservercentral.com/Forums/Topic1424826-2799-1.aspx

After working with MS on this for a couple of weeks we...

Yep, we've been working with MS via premier support for the past week, sending gigs worth of text logs. The issue has been escalated to development, but I put CU3...

Thanks Tommy. I've already got collectors running and premier support provided me with some additional tools to help diagnose the issue... I sent about 750 meg worth of log data...