Query Slow after Replication

microsoft.public.sqlserver.tools

12 Jun 2006 11:57 AM

wwhiteford

We am fairly new to replication and we have suddenly encountered a
problem with our databases after replication is configured. A standard
query we have always used normally takes 5 sec to run. Once
replication is configured this same query takes 15sec. I have ruled
out the server, the code, or the network as I had a copy of each
database on the same server and actually ended up just running this
query in query analyzer. Times are consistent. From my research, the
best I can figure is that it possibly has something to do with the
GUID, but I am not for sure of that.

If anyone has any ideas or suggestions for us, we would greatly
appreciate it! Thanks in advance.