Re: Slower Query from Morning to Afternoon
From: Steve Kass (skass_at_drew.edu)
Date: 07/28/04
- Next message: Aaron [SQL Server MVP]: "Re: Using TOP to page through query results"
- Previous message: Will Harmon: "Re: Using TOP to page through query results"
- In reply to: hdsjunk: "Slower Query from Morning to Afternoon"
- Next in thread: hdsjunk: "Re: Slower Query from Morning to Afternoon"
- Reply: hdsjunk: "Re: Slower Query from Morning to Afternoon"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 14:26:10 -0400
You say "same query against the same data" and also say "they can make
updates". Can you clarify, and can you also give examples of the kinds
of query that this happens to, and show the table structures and
indexes? There are various reasons this could happen. Also, does it
ever happen that the query they ran yesterday afternoon is slow this
morning, or is it always morning - afternoon?
Steve Kass
Drew University
hdsjunk wrote:
>I sure hope this is a common question with a common
>answer...
>
>I have a SQL database that the users interact with using a
>VB application. They are able to build and run their own
>queries all day. We have noticed that a query they may
>run in the morning returns in seconds, but the same query
>against the same data ran in the afternoon hangs up or
>returns in minutes.
>Does anyone have any thoughts about this?
>
>They can also make updates, and the auto-update/create
>statistics is enabled on the server. I'm not a hardware
>person, but according to the Network Administrator, there
>are no issues regarding traffic or hardware.
>
>I hope someone can help, I'm desperate...
>
>Thank you!
>
>
- Next message: Aaron [SQL Server MVP]: "Re: Using TOP to page through query results"
- Previous message: Will Harmon: "Re: Using TOP to page through query results"
- In reply to: hdsjunk: "Slower Query from Morning to Afternoon"
- Next in thread: hdsjunk: "Re: Slower Query from Morning to Afternoon"
- Reply: hdsjunk: "Re: Slower Query from Morning to Afternoon"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
