Space (Sybase ASE Performance Analyst)
Go Up to Sybase ASE Performance Analyst Statistics
In addition to a Home page, the Space category of Sybase ASE Performance Analyst includes the following tabbed pages:
Contents
Home
The Space performance category view displays the following vital Sybase ASE space statistics:
Space Analysis Pane
A Sybase ASE Server is broken up into many different databases, each of which has its own level of activity. The Space Analysis section displays a summary of activities that have occurred within each database. It also displays the total number of databases defined on the Sybase ASE server.
The table below describes the database information available on the Space Analysis view:
Column | Description |
---|---|
Database Name |
The name of the Sybase ASE database. |
Total Space (MB) |
The total amount of space allocated to the database expressed in MB. |
Free Space (MB) |
The amount of space currently free expressed in MB. |
Used Space (MB) |
The amount of space currently in use, expressed in MB. |
Percent Free |
The available free space on the database, expressed as a percentage. |
Log Total Space (MB) |
|
Log Free Space (MB) |
|
Log Used Space (MB) |
|
Log Percent Free |
|
Log Percent Used |
Transaction Log Analysis
The following statistics are used on the Performance Analyst for Sybase ASE Space page to succinctly communicate the general overall performance levels of space related metrics:
Transaction Log Analysis
The Transaction Log Analysis view indicates if any transaction log for a database in the Sybase ASE server is approaching low levels of available free space. The table below describes the information available on the Transaction Log Analysis grid:
Axis | Description |
---|---|
Percent Space Used |
The amount of space currently used in the log, expressed as a percentage. |
Databases |
The name of the Sybase ASE database. |
Location |
Sybase ASE Performance Analyst Statistics > Space (DBArtisan - Sybase ASE Performance Analyst) > Home > Space Analysis Pane |
Metrics |
If the transaction log runs out of space, no transactions can take place in the database until you free space in the log. |
Correction |
If a database log consistently approaches its limit on used space, there are a few actions a DBA can take to prevent a database from freezing. A backup (dump) of the log can be taken: If log backups are not required for disaster recovery, the truncate log on checkpoint option can be set for the database. Setting this option deletes any space devoted to transactions in the log that have already completed when a database checkpoint occurs. You can extend the log onto a new device. Or, if space exists on the device on which the database log currently resides, you can allocate more space for the log on the current device. |
Bottleneck Analysis Pane
The following statistics are used on the Performance Analyst for Sybase ASE Space page to succinctly communicate the general overall performance levels of space related metrics:
The following statistics, available on this pane, are duplicates of statistics available on the Bottleneck Analysis Pane of he Home View (Sybase ASE Performance Analyst) page:
Devices low on space
This metric indicates if any device in the Sybase ASE server is approaching low levels of available free space.
Location |
Sybase ASE Performance Analyst Statistics > Space (DBArtisan - Sybase ASE Performance Analyst) > Home > Bottleneck Analysis Pane |
Metrics |
The environment of the particular Sybase ASE server, as well as your work style dictate the metrics you should use to evaluating a device that is running into trouble with space. Many DBAs create devices that parallel a single, corresponding database in size, and therefore, such devices show 100% utilization. Other DBAs create large devices that are not completely utilized. |
Correction |
If a device has become too full, a DBA can begin the process of manually relocating databases from it onto other devices. The process of moving logs is easier and can be accomplished via singular commands (sp_logdevice). |
Device Analysis Pane
The Device Analysis view presents space related details about a selected device located on the Sybase ASE server. The table below describes the information available on the Device Analysis view:
Column | Description |
---|---|
Devices |
Total number of devices configured on the server. |
Device Name |
The name of the device. |
Physical Name |
The name used by the operating system to identify the device. |
Total Space (MB) |
Total space allocated on this device in MB. |
Used Space (MB) |
Total space, in MB, currently in use on the device. |
Free Space (MB) |
Amount of space that has not been allocated on this device. |
Percent Free (MB) |
The available free space on the database, expressed as a percentage. |
Percent Used (MB) |
The amount of space used on the database, expressed as a percentage. |
Location |
Sybase ASE Performance Analyst Statistics > Space (DBArtisan - Sybase ASE Performance Analyst) > Home > Bottleneck Analysis Pane |
Metrics |
The environment of the particular Sybase ASE server as well as your work style dictate the metrics you should use to evaluate a device that is running into trouble with space. Many DBAs create devices that parallel a single, corresponding database in size, and therefore, such devices show 100% utilization. Other DBAs create large devices that are not completely utilized. |
Correction |
If a device has become too full, a DBA can begin the process of manually relocating databases from it onto other devices. The process of moving logs is easier and can be accomplished via singular commands (sp_logdevice). |
Databases tab
The following views are used on the Performance Analyst for Sybase ASE Space drill-down page to succinctly communicate the general overall performance levels of space related metrics:
Database Object Summary
A Sybase ASE server contains many databases, some of which are devoted to system-level activities (the master and tempdb databases, for example) and others that hold user data. The database overview displays details about the space situation for each database in a Sybase ASE server, including the total, used, and free space. The percentage used amount for each database is also shown.
The table below describes the information available on the Database Object Summary detail view:
Column | Description |
---|---|
Database Name |
The name of the database. |
Total DB Space (KB) |
Total amount of space allocated to the database. |
Free DB Space (KB) |
Total amount of space allocated but free on the database. |
Used DB Space (KB) |
Total amount of space currently used by the database. |
Percent DB Free |
The amount of free space expressed as a percentage. |
User Table Count |
The number of user tables in the database. |
Table Reserved (KB) |
The amount of total space reserved (used and free) for tables. |
Table Data (KB) |
The amount of total space used by tables. |
Table Unused (KB) |
The amount of total unused space reserved for tables. |
User Index Count |
The number of user indexes. |
Index Reserved (KB) |
The amount of index space that is reserved. |
Index Data (KB) |
The amount of data stored in indexes. |
Index Unused (KB) |
The amount of index space that is unused. |
Total Log Space (KB) |
The total amount of log space. |
Free Log Space (KB) |
The amount of log space that is allocated but unused. |
Used Log Space (KB) |
The amount of log space that is currently in use. |
Percent Log Free (KB) |
The amount of free log space expressed as a percent. |
Location |
Sybase ASE Performance Analyst Statistics > Space (DBArtisan - Sybase ASE Performance Analyst) > Databases tab |
Metrics |
If a database's used space percent amount goes above 90%, and the database is dynamic in nature (meaning that users are constantly adding and modifying data), then you should take action to ensure that the database does not run out of available free space. |
Correction |
If the percent used amount of a database is approaching problematic levels, there are two ways you can rectify the situation: If the database device that the database currently resides on contains additional free space, you can ALTER the database to consume more available space on that device. If the database device that the database currently resides on does not contain additional free space, you can do one of the following: Create a new device and issue an ALTER for the database to use that device for space in addition to those currently used. Choose another existing device that has free space and ALTER the database to use that device in addition to those currently in use. |
Database Object Detail
Tables and indexes comprise every Sybase ASE database. The Database Object Detail view presents space-related information about tables and indexes. You can choose to view object details by table or index. Or, view objects matching a pattern you specify in the text box.
The table below describes the information available in the Database Object Detail view:
Column | Description |
---|---|
Owner |
The owner of the table or index. |
Table Name |
The name of the table. |
Index Name |
The name of the index. |
Index Type |
The type of index. |
Key Count |
The number of keys. |
Fill Factor |
The percentage value of the how full each index page can be. |
Reserved (KB) |
The amount of space reserved for the object, in KB. |
Index Size (KB) |
The size of the index, in KB. |
Unused (KB) |
The amount of unused space (free space) that the object contains in KB. |
Segment Name |
The name of the segment. |
Extent Estimate |
An estimation as to the number of extents for the object. |
Location |
Sybase ASE Performance Analyst Statistics > Space (DBArtisan - Sybase ASE Performance Analyst) > Databases tab |
Devices tab
The following statistics are used on the Performance Analyst for Sybase ASE Space Drill-down Devices to succinctly communicate the general overall performance levels of space related metrics:
Device Summary
The Device Summary view presents space related details about a selected device located on the Sybase ASE server. The table below describes the information available in the Device Summary detail view:
Column | Description |
---|---|
Device Name |
The logical name of the device. |
Physical Name |
The physical name of the device. |
Total Space (MB) |
Amount of space configured when the device was created. |
Used Space (MB) |
Amount of space available to any database (via the create or alter database commands). |
Free Space (MB) |
The amount of free space left in the device. |
Percent Free |
The amount of free space for the device expressed as a percentage of total space. |
Percent Used |
The amount of used space for the device expressed as a percentage of total space. |
Location |
Sybase ASE Performance Analyst Statistics > Space (DBArtisan - Sybase ASE Performance Analyst) > Devices tab |
Metrics |
If a device's used space percent amount goes above 90%, you should take action to ensure that the device does not run out of available free space. |
Correction |
If the percent used amount of a device is approaching problem levels, there are two ways you can rectify the situation: Create a new device and issue an ALTER for the database(s) to use that device for space in addition to those currently used. Choose another existing device that has free space and ALTER the database(s) to use that device in addition to those currently in use. |
Device Fragment Detail
Space from a device is allocated among one or more databases on a Sybase ASE server. The Device Fragment Detail section presents all databases and their space fragments that reside on a particular device.
The table below describes the information available on the Device Fragment Detail view:
Column | Description |
---|---|
Database Name |
The name of the database. |
Type |
The type of database fragment (data only, log only, data and log). |
Size (MB) |
The size of the fragment in MB. |
Location |
Sybase ASE Performance Analyst Statistics > Space (DBArtisan - Sybase ASE Performance Analyst) > Devices tab |