June 24, 2012 at 5:34 am
I am not finding out the same size for tempdb...... like when executing select * from sys.sysaltfiles i am getting the templog size showing 64, but when i see the properties of tempdb it is having 0.50 MB only...
could you please explain me how it is...
June 24, 2012 at 7:24 am
Isn't sysaltfiles in 8kb pages?
64 * 8k = 512k = 0.5Mb
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 26, 2012 at 7:04 am
It is recommended that you start using the new DMV sys.master_files. sys.sysaltfiles was left in the product for backward compatibility only. The recommended replacement is sys.master_files.
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
SELECT CAST((size * 8) / 1024.0 AS DECIMAL(20, 2)) AS size_mb,
*
FROM sys.master_files;
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 4:01 am
for info, sys.master_files is a catalog view not a DMV
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 6:30 am
True, sys.master_files is not technically a DMV. The DMV acronym is pervasive however, so I use it in place of a lot of objects sometimes, even though that is incorrect. For the record though sys.master_files is not a catalog view, it's a System View, i.e. database/catalog context has no effect on the result.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 8:19 am
to be clear this details the types
catalog views
compatibility views
dynamic management views (which also includes functions)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 8:36 am
I make a distinction between a Catalog View and a System View where the documentation does not. Catalog Views are dependent on the Catalog/Database Context. System Views return the same result regardless of the Catalog/Database Context.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 9:13 am
*yawn*
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 9:16 am
ditto
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply