As we are aware that, we have different types of Database Backup in SAP(Sybase) ASE inline with other relational databases. In this post, we shall cover types of Backup concerning sp_dboption(database option) and how to use them effectively together while loading the database in order to achieve Point in Time Recovery. Full Backup – This …
Point in Time Recovery with Cumulative and Tran Backup Post Full Backup Read More »
If you are working on SAP ASE(Sybase) replication server, there is likelihood of facing this error which states “Replication Server failed with fatal error while allocating memory. Most likely, there is not enough memory. Replication Server is going to abort.” We faced this issue when we added a MSA(Multi-Site Availability) to the existing set-up of …
First of all, Let me state it upfront that hinting index is not a very good idea and could result in degraded performance. Index hint is not actually a hint rather we are ordering Database Engine to use the provided index however it is still called as “Hint”. In one of my earlier post, I …
Index Hint – Index Is Dropped By DBA, What Will Happen Now? Read More »
I am sharing here my recent experience with one of our vendor who is considered as very much reputed and experienced, they have team of DBAs(development DBA cum Architect, Production DBA, Infrastructure DBA etc..) and mostly their database codes as well as their indexing are not disputable. I am the lonely DBA working in my …
Why Index Hints Should Not(judiciously) Be Used(My Experience) Read More »
You must be knowing conventional method of stopping and starting the replication between primary and secondary server. This involves multiple steps at replication server like suspending replication, dropping the connection and performing few more steps at primary server. These steps again depend on whether we want transaction logs to be propagated to replication server and …
How to Stop Sybase ASE Replication in These 2 Steps Read More »
There could be many indexes on a table other than clustered index, as we are aware – one table can have only one clustered index however can have many non-clustered index. Ever wondered – why do we have only one clustered index and why not multiple like non-clustered one? This is for the simple reason …
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 …
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 »