Sunday , 30 April 2017

Database

SAP HANA in-Memory Computing Engine Architecture Overview

The memory computing engine is responsible for the server activities. It would take care of the memory management Read and Write which includes Row stores / Column stores, Delta memory merges. It also takes care of the data persistence to the physical storage. The regular DB activities like session management, memory management for the sessions, transaction consistency, transaction persistence are …

Read More »

SQL Server 2012 Configuration Parameters for SAP Systems

The configuration of a SQL Server database consists of these areas: Startup parameters Startup parameters are the optional arguments of the executable sqlservr.exe. They are read from the registry, when starting SQL Server as a service. You can modify the startup parameters by using the SQL Server Configuration Manager. The most common startup parameter is “-T” which allows to set …

Read More »

Setting SQL Server Traceflags for SAP Systems

Trace flags offer additional information about the SQL Server engine and enable or disable functionality in the SQL Server engine. Some trace flags should only be set, if specific problems occur of if asked by SAP or Microsoft Support. The following trace flags should not be set by default: 610, 611, 652, 661, 834, 1210, 1211, 1224, 3604 The following …

Read More »

Difference between LEFT and RIGHT OUTER Joins in SQL – MySQL

   

Read More »

SAP MaxDB Installation on Windows and Linux

For installing or uninstalling the SAP MaxDB software in SAP systems please refer to the following information (login required): http://service.sap.com/installNW70 http://service.sap.com/upgradeNW70 SAP Note 767598 Note: The following description only applies to SAP MaxDB as a standalone database or when used for developing your own applications using the SAP MaxDB interfaces. You can download the SAP MaxDB Community edition from the …

Read More »

Optimizing tempdb Performance

What is Stored in tempdb? tempdb is used to store three different categories of temporary data: User Objects Internal Objects Version Stores   User Objects Local and global temporary tables and indexes User-defined tables and indexes Table variables Tables returned in table-valued functions Note: These lists are not designed to be all inclusive.   Internal Objects Work tables for DBCC …

Read More »

Compressing an SAP Database Using MSSCOMPRESS Report

Read More »

Choosing Microsft SQL Server compression type for SAP

Depending on the SAP and SQL Server release, there are different compression types supported by SAP NetWeaver. Unfortunately the naming convention used by SAP and Microsoft is not consistent. Therefore there was some confusion about this in the past. In SAP notes the following compression types are mentioned: database compression, data compression, row compression, page compression, UCS-2 compression (aka unicode …

Read More »