Good gosh, don't do option 1. That will put additional stress on your production system, removing memory, fighting for CPU and disk access. No. Option 2 is pretty much the...

Yes. You're going to want to have that date value as a date. Otherwise, you'll have to parse that string and it will prevent index and statistics use leading to...

Glad to hear the solution. I was also going to suggest looking into bad parameter sniffing, but it's probably just the stats.

Don't do it.

Instead, give them permissions to create extended events[/url]. It's much more lightweight and much less fear of bringing down a production system.

No, I'm pretty sure that's a code issue. They're not cleanly disconnecting.

Run a query against sys.dm_os_wait_stats before and after running the query. It'll give you a pretty good idea what the query is waiting on.

Also, when you're running queries against sys.dm_exec_requests...

You need to check the condition of the server when you're getting the timeouts. Are there lots of connections, or only a few. Of those connections, are any blocked or...

It depends on how your virtual environment is set up and managed. Many of them use physical storage, not virtual storage. In fact, a pretty hefty percentage are set up...

Alvin Ramard (12/10/2014)

---

Koen Verbeeck (12/10/2014)

---

Grant Fritchey (12/10/2014)

---

Weirdest thing, my subscription to The Thread got turned off. I just figured after a couple of weeks you guys had finally given up...

OK. That certainly makes more sense now. Yeah, I'd go with a derived table of some kind (doesn't have to be a CTE, but no reason not to) to get...

Other than to allow for the use of the MAX field, why are you grouping this data anyway? From the example, you're running no other aggregations.

Without seeing the plans, I'm speculating. But, if the data sets are radically different between the two servers, that might explain it. If the cost threshold for parallelism is different....

JoshDBGuy (12/10/2014)

---

Grant Fritchey (12/10/2014)

---

Small company or not, I strongly recommend putting process for getting stuff out to production into place and following it religiously. The last thing you want are...

Weirdest thing, my subscription to The Thread got turned off. I just figured after a couple of weeks you guys had finally given up on this thing.

Yep. Tell them to stop. Unless of course they're also responsible for running the restores. In which case, check to see if they're running differentials and log backups and have...