Post reply

Stored procedure

  • October 28, 2008 at 11:29 pm

    #200605

    hi,

    the following are the outputs of sp_spaceused and sp_tempdbspace

    sp_spaceused

    ------------

    database size unallocated size

    tempdb77752.95 MB28026.99 MB

    sp_tempdbspace

    -------------

    database size spaceused

    tempdb77752.9453121.007812

    the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb

    cany any one explain about this output and why its giving different results.

  • October 29, 2008 at 12:06 am

    #891052

    I think sp_tempdbspace is a user created stored procedure. I could not find it.

  • October 29, 2008 at 3:07 am

    #891077

    when i run dbcc sqlperf(logspace) it is the output

    log size(MB) %used

    tempdb49724.8831.3959780

    only 1% of spaeused in log.

    when i run sp_spaceused command it is giving this result

    Db size unallocated

    tempdb77752.95 MB26094.32 MB

    as per the above results then the unallocated space should be more than 48 GB like that.

    Pls suresh clarify me this.

    thanks ....

  • October 29, 2008 at 5:24 am

    #891113

    DBCC SQLPERF() provides transaction log space usage statistics for all databases (BOL).

    The "unallocated space" returned by SP_SPACEUSED is "space in the database that has not been reserved for database objects (BOL).

    Please run SP_HELPDB and see the size of database and log files.

Viewing 4 posts - 1 through 3 (of 3 total)

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