Have you actually had the hardware checked?

A hardware fault is the most likely cause of your problems and it could mean your server is about the fail completely.

Slow disk errors in the log suggest some sort of hardware problem.

I would get your sysadmin to look for failing RAID disks, problems with a SAN, bad network connections etc....

You may be better off asking questions on SQLWATCH.IO here:

https://meta.sqlwatch.io/

There may also be clues with this Linux Perfmon type solution which uses Grafana for the dashboard:

https://docs.microsoft.com/en-gb/archive/blogs/sqlcat/how-the-sqlcat-customer-lab-is-monitoring-sql-on-linux

https://github.com/microsoft/mssql-monitoring

WITH P2Ns
AS
(
    SELECT IDR, ID, AMOUNT, BALANCE
        ,CASE
         ...

• This reply was modified 3 years, 1 month ago by Ken McKelvey.

This series of articles shows a number of ways to track schema changes. Looking in the log or the log backups might help you if nothing is setup. Extended Events...

If you are using query store the following might help:

https://matthewmcgiffen.com/2019/07/31/find-queries-with-high-memory-grants-using-query-store/

>>I have tried a merge replication/Users won't mind using one database as master and do all the updates in that one.

I would have thought that transactional replication would make more...

• This reply was modified 3 years, 2 months ago by Ken McKelvey.
• This reply was modified 3 years, 2 months ago by Ken McKelvey.

>>If you look at EmpId 129 Rafael Nadal he left at the time Jeff Bezos was Chairman but I am not sure how to write the SQL for this?

Obviously you you not have...

https://www.brentozar.com/blitzcache/long-running-queries/

http://whoisactive.com/

>>Statement 'Restore Database' is not supported in this version of SQL Server

The error message tells you all you need to know. Azure SQL Database does not support native backup and...

• This reply was modified 3 years, 3 months ago by Ken McKelvey.

https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver16

https://blog.netwrix.com/2020/10/16/guide-to-sql-server-permissions/

This should be straight forward Powershell.  There are plenty of search results like:

https://social.msdn.microsoft.com/Forums/en-US/df73b5a3-d27b-45ee-b440-c1bed99f9b4e/how-to-automate-bak-delete-from-azure-blob?forum=sqlnetfx

ps. If you have not used Azure Automation before there is an outline tutorial if you keep following the next steps link in the following:

https://docs.microsoft.com/en-us/azure/automation/overview

• This reply was modified 3 years, 3 months ago by Ken McKelvey.

Using the Ola scripts the "@CleanupTime" parameter is not allowed !

This is a limitation of the SQL Server BACKUP TO URL and not specifically to do with Ola's scripts.

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url?view=sql-server-ver16

I...

ps In some situations the following may be worth looking at:

https://www.sqlshack.com/introduction-to-sql-server-filtered-indexes/