it just started 3days back and happens intermittently after an hour of job runs. It basically updates and inserts the data from one db to otehr db in same server

Backup is too slow. Am doing backup to a single file with compression enabled at server level for backups on a separate backup drive than db file drive and is...

Source db is 2Tb and destination table is also on same server but each dbs are on different drives.

Yes I checked at page level and see no difference in compression before and after.

Also the second query you sent resulted with lob_reserved_gb and total_gb are almost the same.

Sorry removed it since posted twice.

...

Eric I have ran the query you have given and dont see any change before and after compression results.

Eirikur it is not the archival data.

as XML datatype

Do you have any solution here since the DB has only 1 Data file and is around 2Tb. There is one table of largest size occupying 70% of the...

Is listing a stored procedure in all the text files. But what could be the problem with stored proc.

Does this monitor % full of the data files since my each of 12 tempdb datafiles are set to fixed initial size 25gb and autogrowth none.

I need based on % full of the fixed file size.

i have given the value as 251658240kb(240gb). where 240 is 80% (25x8 = 300gb)

Yeah i did that its not working that way. So the case here is that the initial file is set to 25gb for each of 12 files and autogrowth to...

Yes the DB is exact copy daily morning from source to destination. I see MAXDOP different one is 4 other is 8.