That doesn't tell much, does it ?

Maybe the SQLSkills blog and refs can give you a clue for the reason you just have to wait until it finishes ...

SQLSkills...

DBCC Shrinkfile is indeed a slow operation !

Things that make it even worse:

• heaps
• (n)text / immage
• off row nvarchar(max) / varchar(max) / varbinary(max)

What's the result of this query ?

if you are using the Copy_Only parameter with your backup command, that should not be an issue.

In all other cases: Bingo

in your query you are using column [Int] instead of [Inte] !!

Indeed.

I'm now monitoring for XE qds.query_store_db_settings_changed

please follow:

How to post code problems

How to Post Performance Problems 

Can you post the ddl of your table tbl ?

Also keep in mind you may need to cast / convert columns to a varchar data type !

            
November 9, 2023 at 9:27 am
            
#4324337

            
            
                                                
        

My bad. I left some ambiguity in my question.

I'm talking about the primary database of a mirrored set, not about the recoverying version of it.

btw: In the mean time I...

What is actually the question ?

Why are inserts failing ? ( trace it if it's not available in the application logs )

no

• Keep in mind that creating the backups is only a first step !

  You should also perform restores on a regular basis to see of your backups still meet your...

If SQLServer detects the new definition to be the same as the current definition, it will not act.

However, if there are data type storage alterations, it will have to rebuild...

Keep in mind, to retrieve data in a certain order, you need to add an order by clause to your select statement !

Check the connection objects used by your application

My worst nightmare has come true.  We upgraded to 2022 and stuff is crawling now.  We turned off Query Store and went back to the old cardinality estimator and...