Sue, thanks for the reply.  I'll take a look at that article.

Chris, thanks for the info.  Just to clarify, I'm fairly certain the log file always seems to grow...

That would be my guess - in fact, having a DB in an availability group that is offline could actually prevent an automatic fail over from occurring because the secondary...

next update:

if i watch the CPU in taskmanager, after i openend processes in activity monitor, the vCPUs goes from 10 % to 30%. So it seems that the...

If the log drive goes offline - or the data drive for that matter - then yes, the database will go offline and will not come back online automatically.

When and...

I did not see anyone mention compressing the table - have you looked at those options to see if either row or page compression reduces the size of the table(s)...

ISNUMERIC() doesn't do what you think it does. I think you'd be surprised by what all SQL Server considers "numeric".

SELECT 
cv.char_val,
is_numeric = ISNUMERIC(cv.char_val),
is_int = TRY_CONVERT(INT, cv.char_val),
is_decimal...

The OP wants to setup a read-only secondary for 'reporting' and extracts.  I would not recommend allowing any external users access to a production system to perform data extracts.

In this...

Hi Jeffrey,

i noticed the same with SSMS 18.4 and MSSQL 2014.

But the funny thing is, if you execute the query "WITH profiled_sessions as (SELECT DISTINCT session_id profiled_session_id from sys.dm_exec_query_profiles...

Can you try putting in TOP (1) to insure you only get a single value?  Also, can you provide the execution plans for both ASC and DESC versions - it...

First - you really need to identify the process that is causing the problem and fix that process so you don't get these invalid entries.  Second - some of these...

How you address this issue will depend on how that database is accessed.  If there are a lot of queries that join to tables in the other database - then...

Have you tried rebuilding the table?

How is this other DB not a part of the upgrade?  Does it reside on a separate system now - and if so, how does the application access that database...

Secondary Replica 2 (same location Sync mode for fail over) There should be no blocking, unless you have some really bad queries as the secondaries are read-only.  Why...

On the disk usage report - where is it showing the space being used?  If the tables have LOB data - the space could be allocated for the LOB's but...