Figured this out by running:

-- SQL Server NUMA node and cpu_id information
SELECT parent_node_id, scheduler_id, cpu_id, status
FROM sys.dm_os_schedulers WITH (NOLOCK)
WHERE [status] IN (N'VISIBLE ONLINE', N'VISIBLE OFFLINE')
ORDER BY parent_node_id,...

i don't know if my post needs for info for an answer but i tried running the following. I would have thought the section where it says CPU = 0...

I don't believe it is

when i run

select * from sys.dm_os_buffer_pool_extension_configuration

it is showing as Disabled

Yeah, that is what I thought but I can't seem to see anything related to blocking - only CPU thresholds, IO alerts and few others. Looks like we will have...

Thanks Sue.

So, confusingly, you have to set the option for schema changes to be disabled - then they get copied over in the fresh snapshot? Ok I will...

Yes - I was talking about the option you set in SQL server network properties in Config Manager.
Your thoughts actually reflect what I initially said when this was proposed,...

Have you considered Transactional Replication? If you know the tables you need to report from, you can just choose those tables to be involved in the replication.Any changes to the...

Hi
Thanks to everyone for their help and suggestions. I have managed to fix the issue. I simply moved the tempdb files (6 files plus the log) to a newly...