Re: Slower Query from Morning to Afternoon
From: hdsjunk (anonymous_at_discussions.microsoft.com)
Date: 07/28/04
- Next message: Gert E.R. Drapers: "Re: WMI for SQL on WIndows XP"
- Previous message: Pablo: "RE: Partitioning"
- In reply to: Kalen Delaney: "Re: Slower Query from Morning to Afternoon"
- 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"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 12:44:06 -0700
sorry...I didn't know the appropriate place to ask
You could have helped instead of being so negative about 2
of the same posts existing.
>-----Original Message-----
>You have asked this question on several different
newsgroups and you now
>have several threads of responses to follow.
>Please do not multi-post as it makes it hard for everyone
to keep track of
>what has already been answered.
>
>--
>HTH
>----------------
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>
>"hdsjunk" <anonymous@discussions.microsoft.com> wrote in
message
>news:5cee01c474be$98582be0$a301280a@phx.gbl...
>> 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: Gert E.R. Drapers: "Re: WMI for SQL on WIndows XP"
- Previous message: Pablo: "RE: Partitioning"
- In reply to: Kalen Delaney: "Re: Slower Query from Morning to Afternoon"
- 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"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
