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 »
Running database backup is one of the most critical part of DBA’s job. If you don’t have RTO and RPO defined and backup job configured to meet those objectives then the job could be at stake. When its daily job, we need to ensure that the backup(dump) process could finish as fast as possible. When …
How to Expedite SAP Sybase ASE Backup(Dump) Process Read More »
We all must have gathered sysmon output at ASE server and analyzed it while performing troubleshooting at server level. How about gathering similar output at replication server level – this is a very interesting output to look at and understand the details underlying. Lets first talk about the duration and scheduling of this command – …
Capturing Sysmon at SAP ASE Replication Server and Scheduling Read More »
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 …
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 »