SQL Server 2016 In-memory OLTP

In this episode of Data Exposed, Scott welcomes to the show Shamik Ghosh, Senior PM and Akash Verenkar, Senior Software Engineering Manager, both of whom are on the Data Migration team in the Data Group. Shamik and Akash are in the studio today to introduce the Data Migration Assistant, a tool for analyzing and recommending the best data platform for the customer.
At the [01:15] mark Shamik shares the vision and mission of the data migration team and provides an overview of
At the [02:50] mark Shamik introduces the DMA (Data Migration Assistant) and provides an overview of the features and functionality of v1.0 of the tool.
At the [04:20] mark Akash takes over and spends the remaining 15 minutes demoing the awesome features of the DMA, including the ability to detect compatability issues when upgrading to newer versions of SQL Server as well as the ability to discover and recommend new features in later versions of SQL Server. The demo gets even better when Akash shows off the assessment results from the DMA and how you can use these results to make educated decisions on SQL Server upgrades and migrations.
You can download the Data Migration Assistant here.
Data Migration Team blog: https://blogs.msdn.microsoft.com/datamigration/
Questions/Feedback: dmafeedback@microsoft.com
SQL Server Migration Assistant is a simple and handy tool for database migrations into SQL Server. It has a friendly user interface but this tool is not useful for the bigger table, I have noticed that the speed of data migration in SSMA is pretty low. This is not a critical issue for migrating of smaller data volumes, but for big data migration projects I am not able to get the performance. Can you suggest is there any way to increase the performance. in 18 hrs. i am just able to migrate only 33 million of records of 37 million i.e. only 764 records / second, I am using simple recovery model.
I am trying to migrate Oracle database into SQL, here is my server configuration..
Total Columns in table are 63
Total number of records in table 37 million
see the memory consumption that is pathetic , SSMA consumed almost 99% of memory just for 1 table :), I am using server side data migration. Is there some setting I am missing?.
System Configuration is 128 GB RAM and 2 TB HDD