Home

Error 2762 The 'xxx' command is not allowed within a multi-statement transaction in the database

Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database

While deploying the code from development team or support team or vendor provided code, you would have encountered below error and would have thought why this message and why to perform DDL statement inside a user transaction: The ‘%s’ command is not allowed within a multi-statement transaction in the ‘%.*s’ database. Lets understand why this …

Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database Read More »

Very Useful Command to perform Health check of SAP Sybase ASE Replication Server

Very Useful Command to perform Health check of SAP Sybase ASE Replication Server

We will cover few basic commands today which is a must to have for DBA who is supporting SAP Sybase ASE Replication Server and is responsible to keep the replication in a healthy state. Please note that these commands could be stored as a sql query file and can be invoked using a shell script, …

Very Useful Command to perform Health check of SAP Sybase ASE Replication Server Read More »

How to not encounter Error 10330 SELECTINSERTUPDATEDELETEEXECUTE permission denied on object XXX, database XXX, owner XXX

How to not encounter “Error 10330 SELECT/INSERT/UPDATE /DELETE/EXECUTE permission denied on object XXX, database XXX, owner XXX”

You must have encountered one of these errors or more than one at many times whenever there is a new object created or procedure has been changed(dropped and recreated). Mostly DBAs handle permissions at role level however in many cases some of the objects or logins(or users) are not part of role which caters to …

How to not encounter “Error 10330 SELECT/INSERT/UPDATE /DELETE/EXECUTE permission denied on object XXX, database XXX, owner XXX” Read More »

The transaction log for database 'XXX' (dbid 5) can no longer be dumped due to user 'dba' (suid 35) executing ALTER TABLE

The transaction log for database ‘XXX’ (dbid 5) can no longer be dumped due to user ‘dba’ (suid 35) executing ALTER TABLE

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 …

The transaction log for database ‘XXX’ (dbid 5) can no longer be dumped due to user ‘dba’ (suid 35) executing ALTER TABLE Read More »

Understanding SAP Sybase ASE Maintenance Jobs & When To Schedule

Understanding SAP Sybase ASE Maintenance Jobs & When To Schedule

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 »

Capturing Sysmon at SAP ASE Replication Server and Scheduling

Capturing Sysmon at SAP ASE Replication Server and Scheduling

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 »

Point in Time Recovery with Cumulative and Tran Backup Post Full Backup

Point in Time Recovery with Cumulative and Tran Backup Post Full Backup

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 »

Impact of SSD Disk over HDD on MSSQL Performance

Impact of SSD Disk over HDD on MSSQL Performance

Recently our server where MSSQL Server database resides was upgraded and SSD disk was installed. Let us understand the performance improvement on different processes of SQL Server where it had positive impact and where it didn’t have much. Sudden Improvement was observed at below Proesses: Backup of database Maintenance Job Report Generation Database Consistency CHECKDB …

Impact of SSD Disk over HDD on MSSQL Performance Read More »