All right, but is possible i have low a fragmentation? ex: 5,55555 or 3,3333 using reorganize or similar?

Microsoft recommends:

If avg_fragmentation_in_percent > 5% and < 30%, then use ALTER INDEX REORGANIZE:...

I understood.

So, it's normally i've 11,1111 when i use REORGANIZE so? is not possible my fragmentation is lower?

maybe not..

I did it, but I can not find to error =\ may a because networking... fibre..

You are using Transactional replication..is that correct ?

also...

What is failing at midnight ?

Transactional replication and Snapshot replication.

Is it the distribution agent or the snapshot agent ?

dont understand.

Can you tell me...

Are you saying that you have transactional replication configured so that the snapshot agent runs every night ??

no, this error happenned always at midnight... but during the day, never happenned..

...

So you've set up your replication and you now see replication jobs within the agent..is that correct ?

I've been this error may a 3 months ago...

I'm guessing you will have...

So the Snapshot is failing..is that correct ??

I've snapshot and transactional. The snapshot is SQLJOB/SYSADMIN(too) and 'I Guess' to be correct... this error always happened only midnight..

Are you running...

How many tables in the publication?

43

What type of replication ?

Transactional

What accounts are you using for your agents ?

sqljob / sysadmin

Any server configuration that is specific to your company ??

I...

Dear,

Thank you, but the memory is 50%, thus, may a good...

and about the deadlock, I think is difficult, just because the instance of database is not much accessed... and...

SELECT TOP 100 qs.total_elapsed_time / qs.execution_count / 1000000.0 AS average_seconds,

qs.total_elapsed_time / 1000000.0 AS total_seconds, qs.execution_count,

SUBSTRING (qt.text,qs.statement_start_offset/2,...