could be Yes, see index means physical ordering of the leaf level records on clustered index key, with maintaining fillfactor, that way if you have very few records with small...

http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!177.entry

Check replication sites...

HTH

Vin

what is the output of this.

select * FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, 'detailed')

Have you ristrict the growth of tempdb. check property of data and log files.

I have recently hosted ESXi 3.5 in a server with 6GB memory, 2 Intel Xeon 5400 series quad core processors in HP Proliant DL 380 G5 server. I have two...

http://support.microsoft.com/kb/224453

Express Edition is good only for Subsriber.

http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx

HTH

Vin

Hi,

Somehow the replication features of our production sql2005 cluster have become problematic.

Publications and subscriptions seem to appear in parts of the system, and I'm finding it difficult to remove them...

Do you know what is trace #

close/drop that trace it is still running with the following command and then try.

select * from ::fn_trace_getinfo(1) -- to see is trace...

Not tried... but MS says yes:

http://msdn.microsoft.com/en-us/library/aa237112(SQL.80).aspx

http://www.sqlteam.com/article/replicating-sql-server-2000-across-heterogeneous-databases

HTH

Vin

http://blog.csdn.net/longrujun/archive/2006/06/09/783357.aspx

HTH

Vin

why you started snapshot agent....

What error are you getting?

what is failing in your replication, is sql server is working good. Disk drives are accessable.

Just try to restart the log reader...

Deadlock is something like suppose you have 2 sessions running. one session started and working on some tables(a,b,c,...) and other session(s) is also started and running DML on same tables...

For Deadlock you have to enable the Trace

http://msdn.microsoft.com/en-us/library/ms178104(SQL.90).aspx

And for trubleshooting:

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/05/617960.aspx

HTH

Vinay

For Deadlock you have to enable the Trace

http://msdn.microsoft.com/en-us/library/ms178104(SQL.90).aspx

And for trubleshooting:

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/05/617960.aspx

My opinion:

1. change the schedule for distributor so as to run could be after 1hr(if possible)

2. as you said its a...