Re: Running Defrag on a SQL server with RAID

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Leythos (void_at_nowhere.lan)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 21:28:20 GMT

In article <Oamt5ge7EHA.2572@tk2msftngp13.phx.gbl>,
ghayesntloader@raxco.com says...
> Actually, Microsoft's defrag APIs full support defragmenting SQL database
> devices without first having to stop SQL services. Whether a particular
> defragmenter takes advantage of this ability is a different story.

I have 7 Windows 2000 / SQL 2000 servers in our development center, and
when growing/shrinking the databases, or adding new ones, in my
experience, windows defrag utility on 2000 server does not defrag ANY
files that are in-use. The MS SQL database files, as long as SQL Server
is running, are always in use. The same is true for the Exchange
2000/2003 server database files.

Unless you are going to write a custom app to make use of the API, then
there is no point in discussing the API - Diskeeper does a great job of
packing the free space and doing defrags once you stop the service.

Putting your reply at the bottom of a usenet post would be proper and
allow us to maintain the thread readability. 

-- 
-- 
spamfree999@rrohio.com
(Remove 999 to reply to me)

Relevant Pages

  • Re: Best Practice for SBS 2008
    ... The one thing both of your cited examples have in common is SQL. ... If you index properly and occasionally defrag the database then you are actually reducing the number of PAGES that have to be read. ... And it should be noted that a SQL database does not need to be on a separate partition to be cleaned up. ... , SQL database showing 58,000+ fragments of the MDF ...
    (microsoft.public.windows.server.sbs)
  • Re: RAID5 performance + defragmentation
    ... We have HW RAID5 volume for user data on our SBS box, ... We have a massive 12 drive RAID-5 system that holds SQL Database files ... Schedule a Sunday night automated defrag of Drive..... ... mapped drives, lots of daily use... ...
    (microsoft.public.windows.server.sbs)
  • Re: RAID5 performance + defragmentation
    ... Increase SQL database size to expected 2 year growth size - don't ... Schedule a Sunday night automated defrag of Drive..... ... mapped drives, lots of daily use... ... Defrag is needed on a BUSY server. ...
    (microsoft.public.windows.server.sbs)
  • Re: defragging SQL Database files
    ... were you ever able to get the disk to defrag? ... > the SQL Database files? ...
    (microsoft.public.sqlserver.datamining)
  • Re: Defragmentation software for Windows XP?
    ... "The MoveFile API implements a set of rules for moving files while ... system files decreases the effectiveness of de-fragmentation ... defrag system files which XP built-in defrag utility can not. ...
    (microsoft.public.windowsxp.general)