Re: SQL Server Defrag

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Greg Linwood (g_linwoodQhotmail.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 22:56:41 +1000

Hi Sathish.

There is not much point looking at the data from your test machine.

You'll need to post output from your production server for us to be able to
give any meaningful interpretation.

Be aware that tables do not get their own dedicated extents when they are
small. Pages are initially allocated onto shared extents and then later onto
dedicated extents as the table grows. Therefore, the fragmentation
information from small tables is virtually meaningless. Do post the output
from the larger production tables..

Regards,
Greg Linwood
SQL Server MVP

"sathish kumar" <sathishk@catsglobal.co.in> wrote in message
news:e2X8SxNiEHA.3264@tk2msftngp13.phx.gbl...
> Hi,
> Thanks, but this is my test machine, so i dont have big data
> available. But there is a production server which has a like 600+ pages
> of data.
>
> This is from my test machine.
>
> Table: 'JHR' (2025058250); index ID: 1, database ID: 10
> TABLE level scan performed.
> - Pages Scanned................................: 4
> - Extents Scanned..............................: 3
> - Extent Switches..............................: 2
> - Avg. Pages per Extent........................: 1.3
> - Scan Density [Best Count:Actual Count].......: 33.33% [1:3]
> - Logical Scan Fragmentation ..................: 50.00%
> - Extent Scan Fragmentation ...................: 33.33%
> - Avg. Bytes Free per Page.....................: 3825.8
> - Avg. Page Density (full).....................: 52.73%
> DBCC SHOWCONTIG scanning 'JTR' table...
> Table: 'JTR' (2041058307); index ID: 1, database ID: 10
> TABLE level scan performed.
> - Pages Scanned................................: 9
> - Extents Scanned..............................: 3
> - Extent Switches..............................: 2
> - Avg. Pages per Extent........................: 3.0
> - Scan Density [Best Count:Actual Count].......: 66.67% [2:3]
> - Logical Scan Fragmentation ..................: 22.22%
> - Extent Scan Fragmentation ...................: 66.67%
> - Avg. Bytes Free per Page.....................: 1236.0
> - Avg. Page Density (full).....................: 84.73%
>
> Thanks
> Sathish
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Installation instructions for Firefox somewhere?
    ... > happy build a package from it and add it to your production server. ... Currently my experimentation is limited solely to the test machine; ...
    (freebsd-questions)
  • Re: How to mirror a server installation?
    ... I'd like to mirror all the packages installed in a production server with the ... then copy the server.selections file to your test machine and run: ... sudo apt-get dselect-upgrde ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: SQL Server Defrag
    ... Thanks, but this is my test machine, so i dont have big data ... But there is a production server which has a like 600+ pages ... DBCC SHOWCONTIG scanning 'JTR' table... ...
    (microsoft.public.sqlserver.server)