That I am not 100% certain on, but in my opinion - I would buy some sort of SQL monitoring tool.  It will let you know when a deadlock occurs...

My opinion - this is likely not a database issue, but possible a configuration issue.

BUT to rule out database, I would do a dbcc checkdb to make sure nothing is...

The other bit of "fun" with that, on top of what ZZartin siad, is that the TLOG may be in use by other queries that could be inserting, updating, or...

Yep - you see that greyed out "script" button?  Click on a checkbox then click on the script button then cancel out of that window.

That script button will tell you...

I am not certain what you mean by "access the checkbox" in TSQL code, but I am 99% sure that all configuration options within SQL Server for all available features...

Personally - I would not do this on the SQL side.  The ONLY way I can think of to do this would be with dynamic SQL and to me that...

My opinion - every time I've seen an "unable to delete" error, or unable to copy, move, archive, etc, it has been due to disk failure.  I would run a...

• This reply was modified 4 years ago by Mr. Brian Gale.

I wish my disk latency was down as low as 8ms... my lowest read stall is 11ms and the highest is 265869 ms; mind you that DMV is showing you...

I think it depends on your source.  I am assuming this is still the TAR source, in which case you would just need to treat it like a bunch of...

• This reply was modified 4 years ago by Mr. Brian Gale.

What command are you using for tar?  If you are using the native tar built into windows 10, then you would run:

tar -tf <archive name>

which will give you the contents...

Have you tried unpausing it?

Personally, I am not a big fan of activity monitor.  It shows information in one nice dashboard, but even some Microsoft employees recommends against - https://redmondmag.com/articles/2021/08/25/activity-monitor-sql-server-performance.aspx.

I...

I had some "fun" last night trying to get into my playstation account with 2FA turned on.  Enter username and password, next it tells me it sent a text to...

Maybe I'm a bit out to lunch here, but those read stalls look pretty small.  1000 ms is 1 second, so your read stalls on the primary and secondary average...

One other thought - is the folder a network share?  If so, you will need to use the FQDN path to the location (ie //server.domain.com/share/path) rather than the letter (ie...

NOTE - the below is based on my understanding of your code and doing a quick translation into C# as I know C# a bit better than the language you...