Why is the MS calculation for SQL Server table size not reflect Storage in SSMS

  • Hi Jeff

    Apologies for delaying in replying. Ive been ill with a bad cold .

     

    This is what I see of the the table when i run sp_help 'dbo.SIData_222222_88_20211103_1436'

    Attachments:
    You must be logged in to view attached files.
  • i see that is_read_committed_snapshot_on is set to 0

    Attachments:
    You must be logged in to view attached files.
  • I ran the average page fullness using sys.dm_db_index_physical_stats along with some other columns which are displayed in the attached screenshot

     

     

    Attachments:
    You must be logged in to view attached files.
  • Weegee71 wrote:

    Hi Jeff

    Apologies for delaying in replying. Ive been ill with a bad cold .

    This is what I see of the the table when i run sp_help 'dbo.SIData_222222_88_20211103_1436'

    At least it's "only" a cold. 😀  Hope you feel better soon and can wolf down a good piece of pumpkin pie and a glass of milk tomorrow. 😀

    --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)
    Intro to Tally Tables and Functions

  • Man, I thought we might have had it with the RCSI thing.  You've answered all the other questions with the graphics.  I see absolutely nothing in any of that that could be causing this issue.

    The only thing I could ask now is for you to run the following code and then do the same checks that you did before just to see if it's affected the same way.  If it is, you may have uncovered some whacko bug in SQL Server 2019.

    -- DROP TABLE IF EXISTS dbo.JustaTest;
    CREATE TABLE dbo.JustaTest
    (
    ReadingDateTime DATETIME2(2) NULL
    ,ReadingValue REAL NULL
    ) ON [PRIMARY]
    ;
    GO
    INSERT INTO dbo.JustaTest
    (ReadingDateTime,ReadingValue)
    SELECT TOP 10000000
    GETDATE(),1.0
    FROM sys.all_columns ac1
    CROSS JOIN sys.all_columns ac2
    ;
    GO

    --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)
    Intro to Tally Tables and Functions

Viewing 5 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply