Jason Strate has a great example that shows the effects of NOLOCK.

But, one little thing, just on the side, why write code where you put NOLOCK everywhere. If you're really...

While you can use trace, extended events might be a better way to go. The filtering on trace events occurs after the event is captures while the filtering on extended...

SQLRNNR (6/5/2014)

---

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was...

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was I), but I...

Those times are in milliseconds.

Usually, the way I measure performance for a query is to SET STATISTICS IO ON and SET STATISTICS TIME ON for the query window I'm operating...

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....