Re: Physical Disk Fragmentation

anonymous_at_discussions.microsoft.com
Date: 04/08/04 

Date: Thu, 8 Apr 2004 09:44:34 -0700

Thanks I will try the raid 1 for the log files, but why do
I need to take sql offline to defrag? And I do have all
the regular maintenance jobs scheduled, defrags happen
once a week, most of my scan density readings are about
95%.

>-----Original Message-----
>first of all make sure you have the right RAID
configuration. Usually on a
>typical SQL server RAID 1 is setup for log files and temp
DB, RAID 5 is
>setup for data files. If you have only RAID 5 for both
log files and data
>files then you mostly will have bottle neck at hard
drive. For the
>fragmentation do you have a maintenence job for your DB?
If you cap the
>size of a DB leaving it with tiny unused space it may
hurt performance when
>things happen such as split page, index defrag, etc., If
you want to
>physically defrag the disk you must take SQL off-line.
>
>hth,
>
>
>
>"Gary Abbott" <anonymous@discussions.microsoft.com> wrote
in message
>news:1a0e101c41d7a$7ea8e4f0$a301280a@phx.gbl...
>> All,
>>
>> SQL 2000, Server 2000
>>
>> I installed a new server the other week, the disk
>> fragmentation was nill, and it was very fast. Now my
users
>> are starting to complain how much slower it is. I
checked
>> and sure enough the disks are heavily fragmented. I have
>> ample room in every one of my data files, so there
>> shouldn't be any growth outside of the sizes that I had
>> set up. I'm curious, if I should routinely defrag, and
if
>> it does degrade the server speeds? The disks are all
raid
>> 5, I have at least 4 physical disks to each logical. The
>> db is 350gb in size.
>>
>> Thanks in advance,
>>
>> Gary Abbott
>
>
>.
>

Relevant Pages

  • Re: SQL 2000 recomended drive configuration
    ... If the number of drives is fixed, then I would put SQL and the log files on the RAID 1 array. ... Put SLQ and the log files on the RAID 1 and the databases on RAID 10. ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing SQL Server 2005 on Windows 2003 Server (RAID 5) - need advice
    ... available disks and set up I can put the data files on D: ... on RAID 5 which has a greater read performance ... and put the .ldf files (Log files, by their nature, are mostly written ...
    (microsoft.public.sqlserver.setup)
  • Re: Questions about ESEUTIL
    ... Backups don't force log files to be committed. ... > Exchange into the databases. ... >> days a week (Evault online backup with the Exchange agent) and there are ... >> 5) Does the defrag keep or get rid of deleted Deleted Items? ...
    (microsoft.public.exchange.admin)
  • Re: Questions about ESEUTIL
    ... Backups don't force log files to be committed. ... backup will purge all log files that have already been committed by Exchange ... Defrag does nothing with Deleted Items Retention. ...
    (microsoft.public.exchange.admin)
  • Re: RAID Configuration
    ... performance) for the transaction log files to be on the RAID 1 set (which ... has faster write speeds than RAID 5) and the data files to be on the RAID 5 ... > one can occur you want the tran logs to operate as smoothly as possible. ...
    (microsoft.public.sqlserver.setup)