I thought of doing another session for Sybase ASE DBA interview Questions and Answers inline with SQL Server DBA interview Questions and Answers and share with you. These questions are of expert levels and check your overall understanding as well as troubleshooting of SAP Sybase ASE database and approach towards solving issues. Interview typically lasts …
Important 15 Sybase ASE DBA Interview Questions and Answers Read More »
I am sure you would have seen this warning in your SAP Sybase ASE Errorlog once in a while at Production environment when log backup is enabled and you are taking them periodically basis business requirement. Let’s see one of the most frequent root cause of this and also if there is any way to …
Maintenance job basically comprises of two aspects – one is to deal with space management and remove fragmented space and second is to update the statistics with data change so that histogram reflects the latest data and plan selection could be optimized. Lets understand the first type of maintenance job which starts with reorg, as …
Understanding SAP Sybase ASE Maintenance Jobs & When To Schedule Read More »
In real world scenario, we have come across many situations wherein table will have more than 254 columns and when you try to create the same in Sybase ASE, you would face an error as below: Number of variable length columns exceeds limit of 254 for allpage locked tables. CREATE TABLE for ‘table_name’ failed. By …
Lets cover the loading mechanism to Sybase ASE database. Before loading the dump into the database, we need to ensure that there is no active connection to this database as loading requires to have exclusive access. If exclusive access is not granted, loading process will fail with below error message: Msg 3101, Level 16, State …
If you want to improve performance of reports or End of Day by 20-40% without changing query or introducing any new index or anything at all, let’s figure out the parameter which will help us. The parameter is “enable literal autoparam“. Whether this parameter is enabled in our environment or not can be checked by …
Improve Performance of Report/EOD(End of Day) 20-40% Read More »
As mentioned in the previous post on saving storage by using compression Backup compression – save storage 85%(up to) without compromising duration, we shall go into depth of compression levels and their impact on duration as well as size at disk. As you know, Sybase ASE supports compression level from 1 to 9, 1 is …
We have covered dump database to a single file and multiple files in the post Improve performance of DB Backup timing by more than 50% and also witnessed how we can save storage by more than 85% in the post Backup compression – save storage 85%(up to) without compromising duration. As we had discussed in …
As we have discussed in the previous post how to Improve performance of DB Backup timing by more than 50%, today we shall see how to save storage by more than 85% without any compromise on duration. I am taking the same database which is of 30GB size – 20GB data and 10GB log file. …
Backup compression – save storage 85%(up to) without compromising duration Read More »
Backup of database is very crucial for a DBA and it is mostly a daily job. Database backup is used for loading on other environments and also in case of failure of the primary server. There are multiple types of backup and they can be used together to achieve point in time recovery, which will …
Improve performance of DB Backup timing by more than 50% Read More »