Replication Server failed with fatal error while allocating memory. Most likely, there is not enough memory. Replication Server is going to abort.

Replication Server failed with fatal error while allocating memory. Most likely, there is not enough memory. Replication Server is going to abort.

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 …

Replication Server failed with fatal error while allocating memory. Most likely, there is not enough memory. Replication Server is going to abort. 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 »

What If Mismatched Instance Name & Port - Which One Takes Precedence

What If Mismatched Instance Name & Port – Which One Takes Precedence

This scenario could be faced by someone who is having multiple instances running on the same server. Mostly we try to have dedicated server for Production environment however for Test environments(SIT, UAT, Dev) – Based on criticality of application, we tend to install multiple instances of SQL Server on the same server. As you are …

What If Mismatched Instance Name & Port – Which One Takes Precedence Read More »

Why Index Hints Should Never Be Used(My Experience)

Why Index Hints Should Not(judiciously) Be Used(My Experience)

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 »

How to Stop Sybase ASE Replication in These 2 Steps

How to Stop Sybase ASE Replication in These 2 Steps

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 »

MAXDOP and CTP Value - Should You Change Them In Working Hour At Production Server

MAXDOP and CTP Value – Should You Change Them In Working Hour At Production Server

You would have seen number of articles describing the importance of MAXDOP(MAXimum Degree Of Parallelism) and why should it be changed and shouldn’t be left to its default value, which is set at 0 after installation of SQL Server – I have covered them in one of my earlier post – Why MAXDOP shouldn’t be …

MAXDOP and CTP Value – Should You Change Them In Working Hour At Production Server Read More »