Home > > How beneficial it is to have EP system database on HANA?

How beneficial it is to have EP system database on HANA?

Dear HANA Experts,
I would like to know the benefits of implementing EP 7.4 on HANA.
As far as I know, there will be less Database accesses during Java Enterprise Portal system operations.
How beneficial it is to have EP 7.4 database on HANA?
Please provide pointers to know more information regarding this topic.
During POC, one benefit which we have observed is that Portal system came up in less than 2 minutes on HANA DB where as it is taking around 7 minutes in MSSQL DB !!
John Prabhakar
I currently have 11 1G system files which I'd like to combine into say 3 4GB system data files, or 2 6GB system data files.WHY is any change needed?
What is gained by doing so?
Do you suffer from CTD?
Never confuse movement with progress.
Going around in circles is movement, but most folks do not consider it to be progress,
Read the other 5 answers
When we try to set a New Protection, and choose an instance of our SQL Cluster, we only see the system databases, and not the databases we've created. However, in other instances in the same cluster, we don't have this problem. Any ideas? Thanks, Dav
Hi all, After installation of BOE 3.1 the system fires back the error message on attempt to logon to CMS: Account Information Not Recognized: The CMS system database is not available. This error cannot be rectified by the end user. Report this error
Hi Experts, I have some queries around system refresh in HANA. I have a side-car implementation of HANA. Data is replicated by SLT from ECC to HANA. Question is - Can we directly perform a system refresh from prod HANA to Quality HANA box? or we can
So While I was playing around I wondered if it was possible for me to setup a similar version of SQL 2012 on a different environment and restore it quickly.   Master Env SQL 2012  - 3 databases , 2 SSIS packages , 2 Sql Agent jobs and 1 report. The i
Hi Experts, We are trying to install Dev and BW quality system on one HANA appliance. Please reply with any of the best practices and docs for this type of installations. Thank you, PraveenHi Praveen, Hardware resources permitting, SAP supports runni
Hi All, RMS v12.0.6; OS: AIX 5.3 64 bit Could anyone please let me know the following: 1.What's the process to create,move Oracle Retail Merchandising system Database users to IOD? 2.In R12, is "appsweb.cfg" located in FORMS_WEB_CONFIG_FILE is u
Hello,  I am trying to rebuild system database after a DR Scenario by running the below.  C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release>SETUP /QUIET / ACTION=REBUILDDATABASE /INSTANCENAME=CORPPLN /SQLSYSADMINACCOUNTS=xxxxxx /SAPWD
we are often losing connection to CMS/AUDIT system Databases therefore users can not log into Infoview. The work around is to restart the Server Intelligence Agent (sia.exe) Server Details: we have BusObjects Edge standard XI 3.0 Application Server:
Hi, We are planning to use ASM and migrate of file-system database How do you move/copy oracle datafiles,logfiles,controlfiles,*.dbf to ASM? The docs said ASM does not allow OS copy commands :( Thanks a lotThanks a lot Hussein, Arnoud :) I like those
Is there any table tells the installed database is a DEMO or SYSTEM database in Peoplesoft? (or) is there any way to identify the same? ThanksThere is nothing by default, unless the admin who created the database filled the proper columns : SQL> sele
While attempting to set up sql replication in MSSQL 2005 one of my user databases is now in the systems database folder.  I need to move it back to the user databases folder.  Any help would be greatly appreciated.I'm still at the point where if I ru
In a scenario where HANA live co-exists with HANA DB (aka side-car approach), trying to understand the impact of system refreshes to HANA Live content. Is there a method to choose only HANA DB specific data for the refresh i.e. excluding HANA Live da
can anyone elaborate on the risks associated with not backing up default MSSQL system databases (i.e. master, msdb) etc. When would you need to restore data from those databases? What kind of data do they hold? How often do you back them up?System da
As the title .I can run following query when I use  'use master' , But don't work at the DB which be created my myself. --Error massage Msg 208, Level 16, State 1, Line 1 Invalid object name 'SYS.DM_EXEC_QUERY_STATS'. --SQL Version : 2005 --compatibi
I am in a sales cycle and SAP services estimated price for implementation is to expensive and we are pitching HEC.  Do we have a list of SAP certified system integrators for HANA Enterprise Cloud for ERP (Finance and Merchandising for Retail)?Yeah, n
If SQL server system databases crash, what will happen? If sql server system databases crash, how to fix the issue? Any difference to fix for master, msdb,model temp and distribute? ThanksThere would be various situation after "crash". If Master
Should I backup my system databases?The answer is "yes" for master, model and msdb. The answer is "no" for tempdb and the resource database. I usually do my system databases daily, same job as the other databases' full backup. Tibor Ka
Is distrubution database  consider as system database? Thanks ShashikalaHi, depends on what you consider to be a system database. http://blogs.msdn.com/b/jenss/archive/2008/07/16/get-all-system-databases-of-a-server.aspx -Jens Jens K. Suessmeyer http
Hi. We are doing analysis of Legacy system and which needs to be converted to SAP system i.e. SAP implementation. I just want to know , how we migrate the existing whole data( from legacy system) into SAP system. and which method is the best method t