Monday 20 June 2011

How to check database, tablespace sizes in SAP ?




This article answers the following queries :


How to check the database size ?

How to check in SAP, the number of tables and indexes in database and their sizes ?

How to check  the users that are present in database at SAP level ?

How to check various tablespaces in SAP and their sizes ?


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



How to check the database size ?



Goto transaction DB02  and navigate to Space -> Space overview to view

  • Database name

  • Database system

  • Size

  • Free size

  • Used percentage

  • Number of database users

  • Number of tablespaces

  • Number of tables and size

  • Number of indexes and size











In DB02, navigate to Space -> Space overview to find all the above mentioned details













    How to check  the users that are present in database at SAP level ?
    In DB02, navigate to Space -> Users -> Overview as below
              How to check various tablespaces in SAP and their sizes ?
              In DB02, navigate to Space -> Table spaces -> Overview to view tablespaces details as below.




                    0 comments:

                    Post a Comment