October 15, 2002 at 2:11 pm
Greetings,
I have a customer that set up replication badly...he didn't follow our suggested process. This resulted in a GUID column being created for every table, which broke the application that was accessing the database. We removed the GUID columns from all the tables, and the application is functioning again, but now it has performance problems that didn't exist before. I checked their server, and there are no replication objects left in Enterprise Manager.
Can anyone offer any suggestions to get rid of these performance problems? I'm thinking that maybe replication wasn't fully removed...I wonder if anyone out there has encountered this same issue?
October 15, 2002 at 2:24 pm
I'll look at statistics, sp_recompile, Profiler, query plans, dbbc indexdefrag, etc.
October 16, 2002 at 7:22 am
Have you stopped it from being a publisher. If not you will still have the triggers on the tables.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply