difference in file size on disk and sysaltfiles

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db - 10 Mar 2008 18:52 GMT

SQL server 2000

When i select size of files using sql server using
"select name,filename,size from sysaltfiles" I get size of files as

File one size: file1.mdf = 4976
File two size: file2.ldf = 2504
File three size file3.mdf = 1360
File four size file4.ldf = 13408

When I see the size of files in the disk using windows explorer I get
different size

File one size: 39804 kb
File two size: 20032 kb
File three size:10,880 kb
File four size: 107,264 KB

Why is that difference in file sizes?

Signature

--
ontario, canada

Reply to this Message

Tibor Karaszi - 10 Mar 2008 19:12 GMT

The unit for sysaltfiles is in pages (one page is 8KB).

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> SQL server 2000
>
[quoted text clipped - 15 lines]
>
> Why is that difference in file sizes?

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 10 Mar 2008 19:14 GMT

Why are you using sysaltfiles?

> SQL server 2000
>
[quoted text clipped - 15 lines]
>
> Why is that difference in file sizes?

Reply to this Message

db - 10 Mar 2008 19:19 GMT

To get the size of all the databases.

Signature

ontario, canada

> Why are you using sysaltfiles?
>
[quoted text clipped - 17 lines]
> >
> > Why is that difference in file sizes?

Reply to this Message

TheSQLGuru - 10 Mar 2008 21:01 GMT

As Tibor mentions, sysaltfiles units are 8K pages. 8192 bytes. Thus:

select 8192*4976/1024.0 --39808.000000 KB

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> SQL server 2000
>
[quoted text clipped - 15 lines]
>
> Why is that difference in file sizes?

Reply to this Message