thanks Matt, i will get the waitstats as you recommended i am sure i will have questions soon. thank you.

thank you!

thank you!

thank you, i will definetely try all your advise, i do have the

DBCC TRACEON (3604)

DBCC TRACEON (1204)

but i do not see any deadlocks in the sql log...

thank you for your answer can this lead for any memory issues?

thanks i did'nt know about these limitations... can you update stats online in enterprise?

thank you all for your opinions.

thank you for your answer, to answer your questions:

yes my log files are not in the same drive as my data files.

my database has 3 filegroups in different...

thank you this is a great code, only one question, why does it keep saying i have open transactions when i run dbcc opentran it keeps saying i don't.

thank you so much for your clarification. 🙂

thank you!

okay, but the only way to see that is happening at the moment it is , is to run the profiler with the lock escalation event correct?

when i was running...

yes, but the "job" should be in the publisher or the subscriber??. I have it in the publisher and in the job history it says for all my tables...

Hi so you need to do both dtexec and change the properties of the ssis package?

can you tell me how this cmd would change if i have the ssis package stored in Integration services, ssis store?