Re: database maintenance for companies that run 24/7

From: Dan (ddonahue_at_archermalmo.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 11:19:07 -0500

Ken and Andrew,

So, even though INDEXDEFRAG isn't as efficient as DBREINDEX, I guess it is
sufficient. Isn't there fragmentation that also happens to the data on the
disk as well as to the indexes? How would you handle that kind of
fragmentation?

Dan

"Andrew J. Kelly" <sqlmvpnoooospam@shadhawk.com> wrote in message
news:%23Qh%23aDbPEHA.4036@TK2MSFTNGP12.phx.gbl...
> They do what they have to based on their specific requirements. Almost
no
> one that is in a 24 x 7 will be doing any shrinking of files and it should
> rarely be done anyway. If it's truly 24 x 7 then DBREINDEX may not be an
> option and INDEDXDEFRAG might be the way to go. It is impossableto go
into
> enough detail of how to maintain a 24 x 7 operation in a newsgroup. If you
> have this type of requirement and are asking these questions I would
highly
> recommend you hire a qualified consultant.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Dan" <ddonahue@archermalmo.com> wrote in message
> news:%23T1z%23uaPEHA.252@TK2MSFTNGP10.phx.gbl...
> > For a company like an airline that runs 24/7 and the database is always
> > being accessed and they can't shut down, how do they do maintenance on
> their
> > databases? How do they do things like defrag or rebuild indexes or
shrink
> > files?
> >
> > Do they have two databases and they switch back and forth?
> >
> > Thanks,
> >
> > Dan
> >
> >
>
>

Relevant Pages

  • Re: Another Exchange Defrag argument
    ... Anyone running big databases on DAS deserves everything they get. ... fact that the fragmentation you see doesn't match reality very closely ... asked of it in every bit as efficient a way as Windows box will. ... a "You will/will not do a file level defrag on a drive with a store on ...
    (microsoft.public.exchange.admin)
  • Re: Another Exchange Defrag argument
    ... Anyone running big databases on DAS deserves everything they get. ... fact that the fragmentation you see doesn't match reality very closely ... a "You will/will not do a file level defrag on a drive with a store on ... Those arent bucks. ...
    (microsoft.public.exchange.admin)
  • Re: index fragmentation
    ... > Andrew - can you provide a link to Tibor's ... > 2) shrink has run and totally reversed the fragmentation status - to be the ... >>>>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Disk Fragmentation question to Paul Randal
    ... our databases. ... What I had in mind is the DISK fragmentation, ... Will the SQL server running on ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Disk Fragmentation question to Paul Randal
    ... Just to add to what Andrew's said, if you're talking about fragmentation ... > the restore will not in any way affect that. ... >> If databases on a physical drive are fragmented, ... >> extended by adding more hard drives to the array, ...
    (microsoft.public.sqlserver.server)
Loading