Differences in file sizes sys.database_files and sys.master

Differences in file sizes sys.database_files and sys.master_files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 04 Mar 2008 23:21 GMT

Hello,
We are seeing a differince in size column for the same files between
sys.database_files and sys.master_files. sys.master_files inidcates smaller
sizes so I think that rules out deferred drop operations. Any ideas? this
is for Tempdb files.

TIA,

Reply to this Message

jason - 05 Mar 2008 01:44 GMT

All you need is /3GB. Don't worry about /PAE or AWE with 4GB of ram. You can
verify with just taskmgr. However, the RAM will not be commited until it is
needed. You can also look at the SQL memory manager:target server memory
perfmon counter.
/3GB is ok in this configuration most of the time but I would just use it
when it is needed. Sometimes it causes problem for the OS.

Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio

> Hello,
> We are seeing a differince in size column for the same files between
[quoted text clipped - 5 lines]
>
> TIA,

Reply to this Message

Tibor Karaszi - 05 Mar 2008 08:27 GMT

Tempdb is special. Sys.master_files holds the size etc to make the tempdb size at startup (remember
that tempdb is re-created each time you start SQL Server). Sys.database_files inside the database
holds the actual values.

Signature

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

> Hello,
> We are seeing a differince in size column for the same files between
[quoted text clipped - 3 lines]
>
> TIA,

Reply to this Message

Joe - 05 Mar 2008 13:20 GMT

Wow,
Super answer makes a lot of sense.
Thank you very much,

Joe

> Tempdb is special. Sys.master_files holds the size etc to make the tempdb size at startup (remember
> that tempdb is re-created each time you start SQL Server). Sys.database_files inside the database
[quoted text clipped - 7 lines]
> >
> > TIA,

Reply to this Message

Tibor Karaszi - 05 Mar 2008 16:14 GMT

Glad you found it helpful. :-)

Signature

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

> Wow,
> Super answer makes a lot of sense.
[quoted text clipped - 14 lines]
>> >
>> > TIA,

Reply to this Message

TheSQLGuru - 05 Mar 2008 17:40 GMT

TIBOR ROCKS!! :-))

Signature

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

> Wow,
> Super answer makes a lot of sense.
[quoted text clipped - 17 lines]
>> >
>> > TIA,

Reply to this Message