Search Results | SQL Server Performance Forums

Performance improvement after detach/attach

Post by: drewm, Sep 2, 2005 in forum: Performance Tuning for DBAs

Exactly same here. Performance picks up from the very moment the DB is attached.

Performance improvement after detach/attach

Post by: drewm, Sep 1, 2005 in forum: Performance Tuning for DBAs

quote:Originally posted by bradmcgehee Have you only tried to update statistics manually after a performance degradation to see if this fixes it?...

Performance improvement after detach/attach

Post by: drewm, Sep 1, 2005 in forum: Performance Tuning for DBAs

quote:Originally posted by joechang my inclination is to think that a detach/attach has the effect of a DROPCLEANBUFFERS and DROPPROCCACHE Thanks...

Performance improvement after detach/attach

Post by: drewm, Aug 30, 2005 in forum: Performance Tuning for DBAs

Both Auto Update Statistics and Auto Create Statistics are enabled. I've not tried updating stats manually - how is this done? The disk was fairly...

Performance improvement after detach/attach

Thread by: drewm, Aug 30, 2005, 27 replies, in forum: Performance Tuning for DBAs

I've got a SQL Server 2000 database serving a classic ASP web application. The performance of the database keeps nosediving and I can't figure out...

Query performance disparity

Post by: drewm, Jul 15, 2005 in forum: Non-Transact SQL Developer Performance Tuning

Thanks satya - I've already been through that page (it's well indexed by Google), and there's no immediate solution I can see. ranjitjain - I don't...

Query performance disparity

Thread by: drewm, Jul 14, 2005, 5 replies, in forum: Non-Transact SQL Developer Performance Tuning

Firstly, apologies if this turns out not to be a SQL Server problem and would be best posted elsewhere. I'm completely baffled and need a starting...