May 6, 2008 at 8:12 am
last weekend we had an upgrade, my data retrieval time from the replication server is extremely slow. a report that previously took maybe 15 seconds to return data is taking 5 minutes now. I have made no changes to the query.
running on sql server 2005
replication is working fine
can any one tell me what might be the problem
May 9, 2008 at 1:23 pm
Nicole (5/6/2008)
last weekend we had an upgrade, my data retrieval time from the replication server is extremely slow. a report that previously took maybe 15 seconds to return data is taking 5 minutes now. I have made no changes to the query.running on sql server 2005
replication is working fine
can any one tell me what might be the problem
WHAT was upgraded? Software? Hardware? Security? IF SQL Server software was upgraded, was maintenance run on your database - perhaps to update statistics, clean up indexes, etc.? Are you a developer or DBA type?
May 9, 2008 at 1:25 pm
we upgraded software
May 9, 2008 at 1:34 pm
operating system?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply