Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  merge replication - partition view

Author  Topic  NT Starting Member 1 Post Posted - 2002-07-08 : 12:35:09 If have some problems with slow merge replication. If have read the complete white paper 'Diagnosing and TroubleShooting Slow partitioned Merge Processes. So, I have come to the point that I am looking at the partitioned views that have been created and how to determine which of them run slow. Here is an example of such an partitioned view : SELECT * FROM dbo.ReportUser alias_05EFD3B2FE284E46964221C3A62F509D WHERE (ROWGUIDCOL IN (SELECT [ReportUser]. ROWGUIDCOL FROM [dbo].[ReportUser] [ReportUser], [ITOmniCRMMerge_Report_VIEW] [Report] WHERE (Report.ReportId = ReportUser.ReportId))) AND (IS_SRVROLEMEMBER('sysadmin') = 1) OR (ROWGUIDCOL IN (SELECT [ReportUser]. ROWGUIDCOL FROM [dbo].[ReportUser] [ReportUser], [ITOmniCRMMerge_Report_VIEW] [Report] WHERE (Report.ReportId = ReportUser.ReportId))) AND (IS_MEMBER('db_owner') = 1) OR (ROWGUIDCOL IN (SELECT [ReportUser]. ROWGUIDCOL FROM [dbo].[ReportUser] [ReportUser], [ITOmniCRMMerge_Report_VIEW] [Report] WHERE (Report.ReportId = ReportUser.ReportId))) AND (sessionproperty('replication_agent') = 1) My questio here is : Why all the OR statements. From my point of view it should only include 1 where statement. Why the checkings like IS_SRVROLEMEMBER('sysadmin')=1 and IS_MEMBER etc statements are added ? How can I prevent this ? May I adjust these views ? Thanks in advance