asked on

SQL growth measurement

If i do the following:
SELECT
A.NAME, B.*, C.SIZE, C.GROWTH, C.NAME, C.FILENAME, C.MAXSIZE FROM MASTER.DBO.SYSDATABASES A
INNER JOIN SYSFILES B
ON B.FILEID = 1
INNER JOIN MASTER.dbo.sysaltfiles C
ON C.DBID = A.DBID AND C.FILEID = 1
WHERE A.NAME = DB_NAME()

In the growth how would i determine if it is a % or a fixed MG amount
I get 10 and 6400 coming out where i know that 10% and a 6400 mg value

SOLUTION

cpunate9

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Sirees

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TRACEYMARY

ASKER

i read that in the on line book but did not know what to do with it with regards to the 0x000000

I have the following: (They have same Logical File Names) but Location different.

DEVUFCP (M40BARE_Data)
Growth 12800 Status 0 GrowthInPercent 0 (but in EM actually 100mg for data)

Then i have
CONSULCP (M40BARE_Data)
Growth 10 Status 32770 GrowthInPercent 0 (but in EM is 10%)

GrowthInPercent both coming out as 0

some in sysaltfiles status = 3

confused how to add the growth % mg to data size.

TRACEYMARY

ASKER

I ran that script Sirees got errors on it.

TRACEYMARY

ASKER

I got it running.............was not on master.
I play with that i think i got it.

Cheers

TRACEYMARY

ASKER

Can you confirm something...If i used that calculation.

If i have
data sizemg calculation growth (%)
28500 222.65625 10

If i use that calculation
(10 * 8192)/(1024 * 1024) MB = 222 MG

I was under the impression that i have
28500 * 10 % = 2850 MG

That a lot of difference.