Can anyone give me a clue where to start - I have quite a large database
that suffers from performance degradation over a few weeks. A select
statement with 5 joins that runs in 5 seconds can start to take a couple of
minutes.
The only thing that clears it, is to export all the data and objects to a
new database, then its ok but starts degrading again afer a few days.
Obviously, exporting is a pain so I'd rather find out what it is the export
does, and find a better way of doing it.
Any pointers please ?
JaneDo you update statistics regularly?
"Jane Sharpe" <JS51@.hotmail.com> wrote in message
news:bu8rvn$651$1@.hercules.btinternet.com...
quote:
> Hi,
> Can anyone give me a clue where to start - I have quite a large database
> that suffers from performance degradation over a few weeks. A select
> statement with 5 joins that runs in 5 seconds can start to take a couple
of
quote:
> minutes.
> The only thing that clears it, is to export all the data and objects to a
> new database, then its ok but starts degrading again afer a few days.
> Obviously, exporting is a pain so I'd rather find out what it is the
export
quote:|||I'm sorry, I dont know what that means (so I guess the answer is no !)
> does, and find a better way of doing it.
> Any pointers please ?
> Jane
>
Jane
"Quentin Ran" <ab@.who.com> wrote in message
news:#LK1gaE3DHA.3436@.tk2msftngp13.phx.gbl...
quote:|||Look for "update statistics" in BOL and see whether doing that helps.
> Do you update statistics regularly?
> "Jane Sharpe" <JS51@.hotmail.com> wrote in message
> news:bu8rvn$651$1@.hercules.btinternet.com...
> of
a[QUOTE]
> export
>
"Jane Sharpe" <JS51@.hotmail.com> wrote in message
news:bu981q$m92$1@.titan.btinternet.com...
quote:
> I'm sorry, I dont know what that means (so I guess the answer is no !)
> Jane
> "Quentin Ran" <ab@.who.com> wrote in message
> news:#LK1gaE3DHA.3436@.tk2msftngp13.phx.gbl...
database[QUOTE]
couple[QUOTE]
to[QUOTE]
> a
>
No comments:
Post a Comment