Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    1

    Unanswered: How to calculate db space used in aSE with 2K page size?

    How to calculate db space used in ASE with 2K page size?

    thanks a loooootttttttt


  2. #2
    Join Date
    Jul 2008
    Posts
    4
    select "Server"=convert(char(19),@@servername),
    "DB"= convert(char(20),db_name(dbid)),
    "Total (MB)"= convert(char(15), round((sum(u.size) / 512), 0)) ,
    "Free (MB)"= convert(char(15), round(lct_admin("logsegment_freepages", dbid)/512,0)),
    "Free (%)" = convert(varchar(10),round((lct_admin("logsegment_f reepages", dbid)/512),0) * 100 /
    round((sum(u.size) / 512), 0)) + " %"
    from master.dbo.sysusages u
    where u.segmap in (4,7) and u.dbid not in (3,31513,31514)
    group by dbid
    order by 2
    go

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •