Varied result with DBC.TableSize & DBC.DiskSpace

Database

Varied result with DBC.TableSize & DBC.DiskSpace

I was going through TableSize and Diskspace views

 

Using the following queries : 

 

 

SELECT MAX(CurrentPerm),SUM(CurrentPerm)

FROM DBC.TableSize

where DatabaseName='financial';

O/P : 4,564,992.00 11,787,264.00

SELECT MAX(CurrentPerm),SUM(CurrentPerm)

FROM DBC.DiskSpace

WHERE DatabaseName = 'financial' ;

O/P : 6,035,968.00 11,787,264.00

I know that TableSize  should be used for Table Level details and Diskspace  for DB level. But ideally this should return the same result and indeed the CurrentPerm value is same.

Wanted to know the reason behind this.


2 REPLIES

Re: Varied result with DBC.TableSize & DBC.DiskSpace

You are comparing apples and oranges.

1: the max currentperm for an amp for a table in the database 'financial'

2: the max currentperm for an amp for the database 'financial'.

HTH.

Cheers.

Carlos.

Re: Varied result with DBC.TableSize & DBC.DiskSpace

Thanks Carlos for clearing my Perception!