Performance pointer and export...

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
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...
> 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
> 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 ?
> Jane
>|||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...
> Do you update statistics regularly?
> "Jane Sharpe" <JS51@.hotmail.com> wrote in message
> news:bu8rvn$651$1@.hercules.btinternet.com...
> > 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
> > 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 ?
> >
> > Jane
> >
> >
>|||Look for "update statistics" in BOL and see whether doing that helps.
"Jane Sharpe" <JS51@.hotmail.com> wrote in message
news:bu981q$m92$1@.titan.btinternet.com...
> 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...
> > Do you update statistics regularly?
> >
> > "Jane Sharpe" <JS51@.hotmail.com> wrote in message
> > news:bu8rvn$651$1@.hercules.btinternet.com...
> > > 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
> > > 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 ?
> > >
> > > Jane
> > >
> > >
> >
> >
>