File sizes in system tables
-
I am querying
select * from sys.master_filesin order to know the file sizes of my database files. I wonder what is their metrics of measurement? I mean Byte, KB, MB or GB?
Thanks for your time!
-
It's in 8KB pages, so multiply the number in the Size column by 8 and you'll have the size in KB.
See the documentation for that info and more: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-master-files-transact-sql?view=sql-server-2016 - elea.grig - Thursday, August 23, 2018 6:48 AMI am querying
select * from sys.master_filesin order to know the file sizes of my database files. I wonder what is their metrics of measurement? I mean Byte, KB, MB or GB?
Thanks for your time!The size is in 8 K pages - they use that in other size specifications as well. You can usually find what they are using for things like that in the documentation.
sys.master_files (Transact-SQL)Sue
- elea.grig - Thursday, August 23, 2018 6:48 AMI am querying
select * from sys.master_filesin order to know the file sizes of my database files. I wonder what is their metrics of measurement? I mean Byte, KB, MB or GB?
Thanks for your time!This link has the answer to that question.
http://bfy.tw/JXnf--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply