Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ali Reza Pooneh
Starting Member
14 Posts |
 Posted - 2010-06-04 : 08:48:17
|
| Hi.I have some txt large files that contains about 3milion records. I used Bulk Insert and in about 2 minute one of them inserted into my table.For that txt file format and my table format are difference, I create SP and in it,create a temp table(#t) and copied data by bulk into it, then inserted all in my table by a simple select to change some format.But from insert completed time to now(about 6hours), sqlserver process memory usage is very large(about 300MB, also go to 700MB in first hours!), also after restart get this amount of memory.Why?I drop temp table in end of SP.Why sql server memory usage is so big?!?!?! What do I do? |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-06-04 : 08:53:30
|
| What was the Recovery model of the database when you imported the data?PBUH |
 |
|
|
|
|
|
Bulk and big memory usage