Look at your LINQ. Is it still mapping the column as ascii text?

The events I suggested aren't just for seeing whether someone ran dropcleanbuffers. If the cause is not so obvious, it's still going to be related to what's running at the...

I'd probably start with sql_batch_completed and rpc_completed and see if I could figure out what statements were being run at the time the problems happen.

SQL 2012 is out of support and has been for over a year. 2014 will be out of support next year. Upgrading to either of them at this point in...

I recommend upgrading to SQL 2017. No reason to upgrade to something almost 2 years old, and 14 has nothing to recommend it against the alternatives (not unstable, it's perfectly...

No, it's a lot more complex than that.

A couple of the threads are waiting on async network io. They have the async network io wait and are counting...

You need to identify the SELECT that is happening before the update on the table named tbl, and why it needs a table-level shared lock.

Async network io is usually waiting for the app to accept the data.

If the app accepts a row, does something with the row, displays it or asks the...

ALTER DATABASE ... MODIFY FILE for both the mdf and the ldf to point then at the new directory.
Then take the DB offline  if you can (don't know whether...

Since I can't exactly run that, please post the resultant trigger that is on your table?