I have the same large database on two different machines. Tables are
identical and data is almost the same (one is slighly more up-to-date,
'sp_spaceused' shows a size difference of less than 10%). On one server (DEL
L
Poweredge server) the data files are 15.7 GB (.ldf) and 9 GB (.mdf), while o
n
the other (DELL Dimension workstation) the files are only 8.2 BG and 2 GB.
Can hardware make such an important difference? Or am I possibly missing
something? (Both machines run Win2k SP4 with NTFS)Hi Ken Abe,
Check data 'file growth' under database properties if it is by percent or by
mega bytes (Right Click On DB Name-->Properties-->Data Files - Trasnactions
Log --> File Growth).
Also, you might try to 'shrink' the database on DELL Poweredge server(the
bigger one) and remove spaces from the file (fast way to shrink the db, Righ
t
Click On DB Name-->All Tasks --> Shrink Database).
Mario Aoun
"Ken Abe" wrote:
> I have the same large database on two different machines. Tables are
> identical and data is almost the same (one is slighly more up-to-date,
> 'sp_spaceused' shows a size difference of less than 10%). On one server (D
ELL
> Poweredge server) the data files are 15.7 GB (.ldf) and 9 GB (.mdf), while
on
> the other (DELL Dimension workstation) the files are only 8.2 BG and 2 GB.
> Can hardware make such an important difference? Or am I possibly missing
> something? (Both machines run Win2k SP4 with NTFS)
>|||Hi
Hardware does not make a difference. The Databases might have grown some
time in the past becuase a large batch operation was done.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ken Abe" wrote:
> I have the same large database on two different machines. Tables are
> identical and data is almost the same (one is slighly more up-to-date,
> 'sp_spaceused' shows a size difference of less than 10%). On one server (D
ELL
> Poweredge server) the data files are 15.7 GB (.ldf) and 9 GB (.mdf), while
on
> the other (DELL Dimension workstation) the files are only 8.2 BG and 2 GB.
> Can hardware make such an important difference? Or am I possibly missing
> something? (Both machines run Win2k SP4 with NTFS)
>|||Thank you Gentlemen. Shrinking worked.
"Ken Abe" wrote:
> I have the same large database on two different machines. Tables are
> identical and data is almost the same (one is slighly more up-to-date,
> 'sp_spaceused' shows a size difference of less than 10%). On one server (D
ELL
> Poweredge server) the data files are 15.7 GB (.ldf) and 9 GB (.mdf), while
on
> the other (DELL Dimension workstation) the files are only 8.2 BG and 2 GB.
> Can hardware make such an important difference? Or am I possibly missing
> something? (Both machines run Win2k SP4 with NTFS)
>
没有评论:
发表评论