<sigh>

So I post a comment over at DBA Stack Exchange, because I know what I'm posting isn't an answer. I get dinged for it because it almost reads like an...

You get one row per batch if you collect batch_completed. You get one row per procedure call if you collect rpc_completed. You get one row per statement if you collect...

Further to what Brian says, that TOP might even hurt performance. So, yeah, ditch it. It's not adding functionality for you.

The only thing I can spot right now without an...

Not even a little bit. A recompile is simply the...

I don't think there are a standard set of canned reports that someone can simply hand you. There are too many variables at play. Personally, I've usually used a 3rd...

You are collecting every single statement. Of course it's a lot. I'd suggest changing that to batch & rpc completed. You'll still get a ton, but not as much as...

Not really. If you want less detailed usage, and you're on 2016+, you can use Query Store. If you want detailed usage, there are two real choices, Extended Events and...

Every single query is using some CPU. Depending on what the queries are doing, sorts, etc., more CPU is necessary to figure things out. Parallelism causes CPU because a given...

You can't really track user behavior through the logs. Without specialized tools, you can't view the information in the logs. That's really not what the logs are for. It's all...

Redgate has grown to be a very successful company with a declared profit of 9.7M GBP in 2019 Fin Year....so it's not like they couldn't afford to sort...

Without seeing what you're talking about specifically, the session you have defined, I can't say what you're seeing or why.

Yes, Extended Events captures this information. In fact, unknown to most,...

@Grant, I am having same issue. Execution plan "Output List' says 3 columns, col1, 2 and 3 above that Object" is 'PK_id'.

I understand if you add those columns to...

So, my personal and heartfelt request as a member of "the community that was", I'd love it if you and JLS (another recent revisitor) and a host of...

How big are those indexes? Small ones simply can't be defragmented.

BTW, common practice now is to kind of ignore fragmentation. It's just not that big a deal. In fact, constantly...

Total agreement that the system_health Extended Event session is the way to go. Here's a sample query that shows how to pull deadlock information out. You can also use...