Varied result with DBC.TableSize & DBC.DiskSpace

Database
Enthusiast

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
Junior Supporter

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.

Enthusiast

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

Thanks Carlos for clearing my Perception!