any expert comments ?

table is a partitiontable and is having outgoing replication .

Allow_partition_switch was set to 0  . This has beenchanged to 1 ....

Query :

 

WITH DBIO

July 5, 2017 at 2:11 am

#1949408

4 processors 2.6 ghz ... 16gb ram ... its a mini system hosting only one db 🙂

many a times  %Privilieged time is more than 30% and as per an article from Pinal Dave - https://logicalread.com/troubleshoot-high-cpu-sql-server-pd01/#.WVat4y_rtiA
"This can be seen via Performance...

Command(s) completed successfully.

without any error message when i run : DBCC CHECKDB (equip_event_tracking) WITH ALL_ERRORMSGS, NO_INFOMSGS

its been running since quite sometime now ... i am waiting for checkdb to complete .., will post in a while

yes your idea is correct . this is causing high tempdb consumption

select article
into #list
from XYZ.ABC.RT_Main 
where tracked_out_datetime<getdate()-90

delete from XYZ.ABC.RT_Main
where article in (select article from #list)

delete from XYZ.ABC.RT_Flags
where article in (select article from...

Do you have more than one instance entries in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server ?

No
Is the SSMS version the output of

SELECT...

that doesn't answer my question . I want to know the use of file server when I have a quorum already ?

also when I run