Hello Hi Grant Fritchey,

I run sys.dm_os_wait_stats and out put as follows

wait_type --> waiting_task_count --> wait_time_ms --> max_wait_time_ms ...

Hi Grant Fritchey,

I checked all configurations in both servers. But I didn't notice any differences.

What data do I need to trace under wait stat commends.

Thanks.

Hi friends,

In my problem I found following data.

select count(*) from msmerge_contents with(tablockx)

select count(*) from MSmerge_genhistory with(tablockx)

msmerge_contents returns 745 562 rows

MSmerge_genhistory returns 3459 365 rows

That means...

Yes Phil all servers are identical. There are three servers in three different locations. One is publisher and other two are subscribers. OS is windows 2012 and SQL is 2012...

Hi spaghettidba,

Thanks for your reply.

Ok I got your point.

But I have two servers with same environment.

This problem occurs only a database of one server other one is ok

One server...

Thanks for your quick reply Mr. Phil

I know triggers slow the update query.

But in my problem You know when we create a merge replication on a table it adds three...

yes

This is not working for 2012

Do you know any sp for 2012

Thanks for quick response.

This table already dropped from the publication

I think this table did not dropped clearly.

Thanks Divine Flame,

I did everything.

Restart the Agent and test the operator using SP_NOTIFY_OPERATOR it returns the test mail thats means email acc is ok. that is the only operator.

Thanks.

thanks for ur link 🙂

replication has removed. but the table hang on with replication trigers so i cant remove the table

There is a trigger and it update another table.

the error given by that table.

Thank you guys.

I solved the porblem.

:-D:-D

same table same server

This is the table DDL

USE [EPAS]

GO

/****** Object: Table [dbo].[Users] Script Date: 05/08/2012 15:43:22 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Users](

[UserID] [int]...