Re: File Size - Probably missing something basic...
From: Jimbo (anonymous_at_discussions.microsoft.com)
Date: 09/02/04
- Next message: Kalen Delaney: "Re: how can i get the base tables underlying a given view object ?"
- Previous message: Ron Hinds: "Re: Error 14258"
- In reply to: Rick Sawtell: "Re: File Size - Probably missing something basic..."
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 09:18:56 -0700
Thanks for that.
What I mean by taskpad is if you go to SQL Server, select
the database, then View -> Taskpad it shows the size of
the file.
J
>-----Original Message-----
>I'm not sure what you mean by the taskpad of SQL
Server.. but here goes.
>
>The sysfiles table shows the size of your database is 8k
data pages. So you
>need to multiply that number by 8.
>
>For example: select * from sysfiles (while in my master
database) reveals
>the following two files.
>
>size: 1464
>size: 96
>
>If I multiply those out as: SELECT ((1464 * 8) + (96 *
8)) you get about 12
>MBs
>
>
>Now if I go out to my: \Program Files\Microsoft SQL
Server\MSSQL\Data
>
>My master.mdb file is 11.4 MB
>and the ldf file is .7 MB
>
>That makes just over 12 MB... So these are the same.
>
>If I right-click the database in Enterprise Manager and
choose properties, I
>get just over 12 MB's...
>
>
>So, these are all the same size as far as I can see...
>
>
>HTH
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>
>
>
>
>
>
>
>"Jimbo" <anonymous@discussions.microsoft.com> wrote in
message
>news:4cb201c490f4$f09a23b0$a501280a@phx.gbl...
>> We have one main data file, and I would like to track
how
>> fast it grows.
>>
>> In the Task Pad of SQL Server it gives the file size as
X
>> By running "select * from sysfiles" I get Y,
>> But by looking at the actual file size I get Z.
>>
>> Can anyone tell me whats happening ?
>>
>> J
>
>
>.
>
- Next message: Kalen Delaney: "Re: how can i get the base tables underlying a given view object ?"
- Previous message: Ron Hinds: "Re: Error 14258"
- In reply to: Rick Sawtell: "Re: File Size - Probably missing something basic..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
