SAP on SQL—— A very end user friendly combo pack.
In layman language, I found MS SQL very user friendly in SAP environment which tackles most of all the database administration things automatically. By bench-marking with SAP with oracle, I got following major positive points, which are being handled automatically without any manual intervention :-
1. We don’t need to check the table space .
2. No need to maintain Archive log mode — ON /OFF which generally leads to full the archive directory .
3. No need to do statistics update manually .
4. Upgrade is also comparatively easier than oracle.
I have raised all above points based on my perception , so there may be some ambiguities which I would like you to suggest for correction, so that we can get to a bottom line of the topic being discussed over here.
And of course, there are many advantages are also there for oracle and other databases, but all mentioned points only subjects to past experience. Request you all to update on this to make a valuable blog.