DECLARE @sumdocument int;

WITH Bollore
AS
(
SELECT SEQ_DOC
FROM OPENQUERY([pprod.link.db.bollore-logistics.com], 'SELECT SEQ_DOC FROM LINK.dbo.DOCUMENT')
)
, Bad
AS
(
SELECT SEQ_DOC
FROM OPENQUERY([pprod.link.db.bad-logistics.com], 'SELECT SEQ_DOC FROM LINK.dbo.DOCUMENT')
)
, AllDocs
AS
(
SELECT SEQ_DOC
FROM Bollore D
WHERE EXISTS
(
SELECT 1
FROM Link.dbo.EVT_ATT L
WHERE L.SEQ_DOC =...

max(vid) AS vid, nid

-- Your
CREATE TABLE dbo.PermTable
( Value VARCHAR(100) ) COLLATE DATABASE_DEFAULT

-- Should be
CREATE TABLE dbo.PermTable
( Value VARCHAR(100) COLLATE DATABASE_DEFAULT );

-- or just
CREATE TABLE dbo.PermTable
( Value VARCHAR(100));

I have never done it but I think prior to SQL2022 query store only worked on the primary replica.

https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver16#query-store-for-secondary-replicas

As a matter of interest, what values are returned by the following queries:

--1
SELECT CAST([value] AS int)/1024
FROM sys.configurations
WHERE [name] = 'max server memory (MB)'
ORDER BY [name]
OPTION (RECOMPILE);

--2
SELECT CAST(ROUND(total_physical_memory_kb/1048576.0,...

To be honest, Auto statistics don't work well with indexes with ever-increasing keys. And, even after the improvements they made, I still think that they fall a bit short. Go...

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, 9 months 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, 10 months ago by Ken McKelvey.
• This reply was modified 3 years, 10 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/