You should indeed figure out if implementing the suggested missing index makes sense ( chances are ).

Maybe even add an index on your dbo.PLNewData table ( I've just put the...

Test the given catch-all options ! YMMV ( I'm on the "option (recompile) should be a last choice"  side)

after database restore, you need to double check and setup SSB again !

check https://www.mssqltips.com/sqlservertip/5365/steps-to-restore-service-broker-enabled-database-on-new-sql-server-instance/

What I wanted to point to is that a given UniqueClaimID e.g. 10929_6155... is being counted 5 times as there are 5 ProvOrgNm using it, on a total of 134865...

No offense intended at all, nor questioning any level of knowledge.

So you're talking DNS aliasses, wright?

You could connect using "MyInstanceName\MyInstanceName" , no port number needed and SQLBrowser will resolve the...

• This reply was modified 3 years, 10 months ago by Johan Bijnens.

If you're using SQLuser accounts, be sure to copy them up front

Easyiest using DBATOOLS powershell module

$SourceSQL = 'Server\instanceA'
$TargetSQL = 'Server\instanceA'
Copy-DbaLogin -Source $SourceSQL -Destination $TargetSQL -ExcludeSystemLogins

you can even...

Well, some instances may not use port 1433 !

You'll actually need to double check that the instance you are trying to address is actually the one listening at that port...

-- was to quick --

How about:

If you are able to extract the 4-part-named object usage

create a schema e.g. [work], generate and execute a

'select * into work.[4-part-named-object] from 4-part-named-object where 0...

• This reply was modified 3 years, 10 months ago by Johan Bijnens.
• This reply was modified 3 years, 10 months ago by Johan Bijnens.

I don't use automatic seeding, because I want to have control over the full process.

You can indeed restore the db on the new AG-member-to-be including the log restores ( with...

-- try
SELECT [UniqueClaimID], count(distinct ProvOrgNm) nProvOrgNm, count(*) nRows
FROM [phm_db].[dbo].[PCP2Final]
group by [UniqueClaimID]
having count(*) > 1
order by nRows desc
;

Please also read the follow up article "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

Another enhancement to avoid the downsides of notification service queues

Question should be: why doesn't the name resolving work ?

did you check this?

How to troubleshoot the "Cannot generate SSPI context" error message

If it's on the D-drive of the azure vm and 15 seconds timeout reached, I would open a case with Azure support !

on top of the other replies:

Only a log backup marks the log file entries to be overwritten except for open transactions.

DO NOT SHRINK LOG FILES ! ( unless you performed...