Ok, Thanks for all your inputs. Appreciate it.

Hi,

Size of the table: 195 GB

Number of Indexes: 90

220GB memory is allocated only for the sql server....out of total 260 GB Server memory.

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...

Thank you so much.

Please help with below scenario.

I am trying to Copy the 500 million rows of data of Table A from Server A(sql 2008 r2) in chunks (100...

Yes, its 32bit SQL.

can u tell me how to do the switch?

Hi,

I checked the virtual memory settings and found the following.

Initial size - 4096MB

Maximum size - 4096MB

Total paging file size for all drives - 34080MB.

I think this setting is fine.

Please advise.