Speed up s ps42/9/2023 ![]() ![]() ![]() To give you an example I setup a test environment with a 8TB HANA DB with HANA 2.0 SPS3 Rev. Perform global savepoint Phases in detailįor our little deep dive this information are not enough.ĭetails for every phase: 2222217 – How-To: Troubleshooting SAP HANA Startup Times load the list of open transactions from the last savepointħ. load converter tables from the last savepoint (mapping of logical pages to physical pages in the data file)ģ. In any case we assume that the DB was stopped normally which includes a global save point at the end of the shutdown phase.Ģ. To understand which phase is your pain point, we have to understand how the DB starts and which phase can be optimized. But which possibilities are there to speed up which phase with which release? Because a lot of DBs are still not on SPS4 and can not profit from new features. This is also the reason why SAP introduced the fast restart option with SPS4. ![]() In my career as consultant I’ve seen a lot of HANA databases with pretty long startup times with more than 1 hour. Here we have to separate the available time and the reload time. One of the biggest challenges with SAP HANA databases are the duration of the startups. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |