Home Forums SQL Server 2014 Development - SQL Server 2014 HI...Sample INSERT statement script needed to insert 500 million rows into in-memory table sql server 2014 RE: HI...Sample INSERT statement script needed to insert 500 million rows into in-memory table sql server 2014

  • Hi Jason,

    Thanks for your reply.

    Ok, The purpose of doing this test is to conduct performance stress test by loading the data into a in-memory enabled table. so..I created the table structure first on target server with in-memory enabled.

    Coming to your questions,

    How much memory do you have allocated to SQL Server on the target server? - 220GB of memory

    How much free space do you have on the disks of the target server? - 5.3 TB of disk..which is more than sufficient for this data

    Does the table that is desired to be in memory contain out of row data (LOBs)? - No

    All of these things are critical and could impact the ability to be able to put that data into memory on the target server.

    Next concern.

    Why wouldn't you move the data to a table on the target server first, then enable that new table to be in-memory?

    --------------------------------

    Please advise.