One of the things to try :

if it works fine with maxdop 1,  enable QueryStore if it's not enabled yet,  get fast plan captured in it and force the...

The execution plan stays the same between MaxDop 1 and other settings? Cause overall, I'd say you crossed a threshold on row counts. That's when I've seen things go south....

The Visual Studio query editing environment is largely, but not perfectly, the same as writing it in SSMS. The core behaviors are the same. I'd say that people who work...

Is the database in full recovery mode? Do you have log backups running? How often are the log backups running? The log file is just your transactions, cumulative, so it's...

I really don't know. I think getting the EF code changed is your best bet.

Not one I've run into before, but I think it's the LIKE. I'm not sure why, but it must not be able to parse that type of command. I ran...

Ahhh... I've got to disagree a bit.  Instead of changing to comparability level,  SQL Server 2017 does have the ability to use the old cardinality estimator at at least...

SQL Server 2014 introduced a new cardinality estimation engine. Any migration from a version of SQL Server prior to 2014 to post 2014 has to deal with this issue. In...

It shouldn't matter, but go and get the latest cumulative update. You shouldn't be running RTM at this point.

I'm unsure what the issue is. I do this kind of monitoring...

Look down below in the details. Is there a second tab? I'll bet there is.

Causality tracking won't prevent it from capturing the deadlock graph. I think the issue likely lies in the is_system filter. You're not looking for system issues, you're looking for user...

You can't bypass it. If you really need everything in views (and not seeing your code, I can't support whether that's a good idea or not), then I'd suggest five...

Best to only ask a question once. Most of us look at a lot of forums, so we're likely to see it. Plus, any discussion will take place in more...

Pretty much yes. The index usage stats are just one piece of information. However, it's not dispositive information. It's a part of the whole puzzle. The whole puzzle very much...

The data in the deadlock graph includes the sqlhandle. You can use this against either the DMVs or Query Store (if it's enabled) to retrieve query information. The sqlhandle is...