This SQL box has 6 GB of total memory.

Mininum memory is 0 and maximum memory is 2147483647 MB which is default.

Should I change maximum memory to 6000 MB and what...

It's a 64 bit Enterprise Edition of sql server and I believe sql serer is paging out to disk. I am not changing the memory but creating two Page File...

Thanks guys,

Yes, it's 64 bit machine.

I am thinking of creating two virtual files. One will be the default on c drive and other will be on D drive and the...

I think I solved the issue. I am tyring to shink in a smaller chunks, like 50 MB and it's working.

DBCC SHRINKFILE (DataFil1, 25000)

go

DBCC SHRINKFILE (DataFil1, 25950)

go

DBCC SHRINKFILE (DataFil1, 25900)

go

...and...

I already ran sp_who2 and there is not blocking except self blocking of that process.

This shrinking process is blocking by itself. there is no other blocking going on.

I am thinking...

Transac is a view which is based on two partitioned tables. We access transac view for insert,delete and update.

Create view Transac

as

select * from transac_archive

union all

select * from transac_live

Yes, Transac is a view based on two partitioned tables archive and live. It's really weird that sometime it is working slow and sometime works just fine. Long time back,...

Actually, It's not a zip file. I just rename the extension to zip so that I can upload into this website.

You just need to change from .zip file to...

are you renaming the zip file into sqlplan extention. ?

I sent it again.

Sorry about that. Here is the attached sqlplan file.

I rename to zip file because this website does not upload sqlplan file. please rename back to sqlplan extention so that you...

Thanks for your reply, I have attached the query plan. May be it will help.

Mike.. Great it's working.

Thanks

Yes, You are correct Jack.

Thanks a lot.

I think I figured out the issue. It's a design issue at our part. Data gets loaded into temp table first and then from temp table to real table.

I think...