Thank you for your reply. I know that the main reason is row by row processing but we cant change the erp system substructure. Because it was not written by...

Computer management>Services>Sql server> Log On as Local system account

I do this for both nodes.

we have. 2 cluster nodes. Both are HP 580 G7. Same machine same configuration.

We have change the sql server startup user from domain account to local system and it works much better now. I couldnt find the problem about domain user but it...

Thank you for your reply. I want to learn that does it need any maintance after the compressing. For example we are rebuilding indexes periodically because they are demaging by...

Yep you are great. I didnt care that the server names are different. I changed the erpmerkez580 to new server and i works. Thank you for your atention:)

i have alrady tried the scripting job below but i got the error like,

"Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137

Cannot insert the value NULL into column 'owner_sid',...