Re: database maintenance for companies that run 24/7

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: index maintenance for big tables
    ... databases based on logical fragmentation. ... What really matters is page density / fill factor as this has a significant impact on how efficiently SQL Server uses its cache. ... Hence, it's FAR more meaningful to rebuild indexes based on page density / fill factor than on fragmentation & even then, this is about improving cache / memory performance than fragmentation specifically. ...
    (microsoft.public.sqlserver.server)
  • Re: index maintenance for big tables
    ... databases based on logical fragmentation. ... relatively well cached system) will access most data via the cache, ... it's FAR more meaningful to rebuild indexes based on page density / fill ...
    (microsoft.public.sqlserver.server)
  • 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: 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: 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)