I read that articiles thanks for your advice.

How much do you want for it?

Yes i need some analyis about this trace what can i do avoid this deadlocks or anythink.....

Sorry for ittt

I found reason but i want your comments about that db sql server performance

Trace is here

Trace is here......

Oke I will try your comments

if i make it my ldf file size is very big

If I lost my Db I have only one hour i data lost and my recovery model is simple

I think you can look at the query parralesim parameter in the server.

I think you can use READPAST or WITHNOLOCK hint in the query.

I think if you can change to query to stored procedure and use this procedure in LINQ to...Maybe it can be progresss.....

My rebuild index taken about 5 hours and my diffrantial backup runs about per one hour about that time

diff backup starting to grow up i think maybe i can write...

Hi;

In your cursor try to use this hint FAST_FORWARD

DECLARE XXXCURSORXXX CURSOR LOCAL FAST_FORWARD FOR

Esat Erkec