george sibbald (6/5/2014)

---

I have an app where the vendor recommends (nay insists) setting maxdop to 1 and cost threshold to 15, go figure.........

Is Dynamics AX a microsoft product, they have...

You're seeing no CXPACKET waits at all? That's a little abnormal in itself. Some of those waits are sure to bubble up in most systems. They're not any kind of...

They could be coming from anywhere that can call the system with appropriate permissions. To know who made the call you'd need to set up extended events to monitor queries...

Regardless of the source, those are still just queries coming into the system. If you're capturing query metrics using any of the common approaches such as querying the cache through...

Connection timeouts can be tough to monitor for since you're usually monitoring for activity and this is the failure to generate any activity at all. By and large I would...

And your reads/writes ratio is based on pages or just the number of times referenced? If the latter, I'm not sure I'd care. If the former... again, still not sure...

You have to remember that SQL Server Database Tools (SSDT) is an overloaded term within Visual Studio & SQL Server. There are actually two distinct tool sets that define SSDT....

How often is the read query called? Did that cause blocking or contention with other resources while running? yes, there are always added writes when creating an index, but how...

Yep, percent complete is an incomplete figure. There's really no options for the position you're in. You need to wait it out in order to run the restore of a...

Fast recovery applies to crash recovery and failovers as part of mirroring. This is not applicable to a restore operation. There is no special setting you get for the restore....

Security is just the start. I'd suggest modifying the cost threshold for parallelism. I'm just learning about modifying the system_health extended events session to only write to file and not...

Enjoy it. See you when you get...

I've checked in with the powers that be. I suspect pretty strongly that you're misinterpreting that statement, but someone should get back on this, soon I hope.

Since you have more than one date value, that's returning multiple rows in a place that can only have one. Instead of using MAX date, use TOP 1 with an...

You need to do two things. Look into all the common code smells of T-SQL, like this:

Isnull(functionalunit, '') <> ''

That's a function on a column which will lead to...