Gossamer Forum: General: Databases and SQL: Re: [Alex] Extremely Poor Performance - Identical DBs Different Performance: Edit Log

Gossamer Threads

Home : General : Databases and SQL :

General: Databases and SQL: Re: [Alex] Extremely Poor Performance - Identical DBs Different Performance: Edit Log

Here is the list of edits for this post

Jun 23, 2006, 6:24 AM

AFTIadmin

Novice (6 posts)

Jun 23, 2006, 6:24 AM

Re: [Alex] Extremely Poor Performance - Identical DBs Different Performance

Hi Alex,

I tried what you have suggested and restarted the sql server on dev and ran the query, and it still ran very fast. So its not a cache issue. Would it be usefull to post the query? I don't think so, because both queries (and dbs) are the exact same on both servers.

I've been useing perfmon to monitor any unusual activity. But I've had no luck finding anything. Generally % Processor Time stays below 5%, when executing a query it only rises to about 25%. Avg Queue length also stays very low as well as pages/sec. Do you have any suggestions on what counters I should be listening to?

Thanks for ur help, any more ideas?

Brian

Last edited by:

AFTIadmin: Jun 23, 2006, 6:25 AM

Edit Log:

Post edited by AFTIadmin Post edited by AFTIadmin (Novice) on Jun 23, 2006, 6:25 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676