You can use Whoisactive and sp_BlitzFirst both supports Azure, Also try to look query store and extended events.

If the DB is small, yes you can configure again.

How to fix the LSN issue:...

Check the error log , could be where you have apply a log backup in the sequence.

AVAILABILITY_REPLICA - wait means SQL Server is waiting to send log data to one of your AG group. Better check AG dashboard with selected columns, you can understand where it...

Is the AG been configured across the DC or same. Did you see any latency and what is the mode sync or async? As long as the pair replica getting...

It is my understanding that in order to use Availability Groups then each database to be included must be configured as full recovery model. The environment I'm dealing with...

Hello together,

We have about 50 databases that are not in full recovery mode and not in always on included.

Do you know what the fastest way is to add these...

You can have look on this as well - https://www.sqlserverblogforum.com/dba/how-to-use-configure-ola-hallengren-sql-server-maintenance-script/

Hi All ,

I have a problem with big database that occupies some space in a drive , This drive is running out of space so I want to add...

• This reply was modified 5 years, 1 month ago by  muthukkumaran Kaliyamoorthy.

Yes - its 30 days by default - SET @CleanupDate = DATEADD(dd,-30,GETDATE())

You can change this to any day by changing the number.

Ex: 4 Days - SET @CleanupDate = DATEADD(dd,-4,GETDATE())

Everyone has seen this, new DBA at new company has 3rd party EMR product that we have AG setup for read only node.  Week one on board users screaming. ...

You have to configure perfmon counter and collect some week data of both nodes when on their active and compare it. You can get some idea.

This may help:

Error 5 is access is denied.  My first step would be to check what user the SQL Server service is running under and make sure that account has permissions.

If...

Not sure, what do you mean by PC. I hope it is a test case and learning.

It is like a migration - You need SQL service in your new machine...