Thanks John,

Yes, part of the problem is the disk always get full, but I still think there other issues also as I'm running the maintenance plan on so many...

My next Maintenance plan is schedule to run in two weeks so I will review the links, articles and scripts you all provided and hopefully come up with a solution...

Hi Brandie,

Thanks for your assistance

The main issue is fixed now as there were missing Indexes, now things are running much better

But just for my knowledge what will...

Thanks Brandie,

I was thinking the same too but the problem is that after adding the Replication this issue is started

If I stop the replication everything completes in few...

Take a look

wait_type waiting_tasks_countwait_time_msmax_wait_time_mssignal_wait_time_ms

PAGEIOLATCH_SH 9333614 ...

Hello, thanks for the reply. please see below

Brandie Tarvin (4/18/2014)

---

What is the specific kind of locks that you are encountering?

(294ms)PAGEIOLATCH_SH:testdb:1(*)

If I do a simple record count on a small table,...

Thanks SSC and all others

I think ETL approach will be the best until MS comes up with a Wizard to solve this

Maybe backup only six month and restore (I...

Please see below my answers:

Do all the tables have the same columns? NO

Do all the tables have a single column for filtering the last quarters? yes there is date...

Thanks all.

I need all the tables, there are close to 480 tables in the db

Thanks for the link

that solved my problem

Thanks all and Gail issue fixed

I changed the Min and Max few times & finally I ended up restarting the server too

& no I didn't used same...

Still working on this issue

I changed the min and max but no effect

Thx for helping with Paging logic

Anything else you can recommend to resolve the issue

Thanks

Dave

======================================================

Locked pages is when the service account has the locked pages in memory privilege. It prevents windows from paging SQL's buffer pool to disk (which would be a rather bad...

Thanks Gail.

I don't know why it was setup as '1' because the person who build the server is gone

What exactly I suppose to do tonight ?

Just downloaded...

Below are the settings:

The Max degree of Parallelism is setup with "1"

Cost Threshold is "5"

Query Wait is "-1"