Slower Query from Morning to Afternoon
From: hdsjunk (anonymous_at_discussions.microsoft.com)
Date: 07/28/04
- Next message: Adam Machanic: "Re: One Record Where True, Many Where False"
- Previous message: Mike Perry: "Re: SQL Server 2000 Dynamic SQL and Temp Tables"
- Next in thread: Steve Kass: "Re: Slower Query from Morning to Afternoon"
- Reply: Steve Kass: "Re: Slower Query from Morning to Afternoon"
- Reply: Kalen Delaney: "Re: Slower Query from Morning to Afternoon"
- Reply: ZorpiedoMan: "Re: Slower Query from Morning to Afternoon"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 09:19:02 -0700
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: Adam Machanic: "Re: One Record Where True, Many Where False"
- Previous message: Mike Perry: "Re: SQL Server 2000 Dynamic SQL and Temp Tables"
- Next in thread: Steve Kass: "Re: Slower Query from Morning to Afternoon"
- Reply: Steve Kass: "Re: Slower Query from Morning to Afternoon"
- Reply: Kalen Delaney: "Re: Slower Query from Morning to Afternoon"
- Reply: ZorpiedoMan: "Re: Slower Query from Morning to Afternoon"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
