August 28, 2014 at 1:52 am
arooj300 (8/28/2014)
Hi Koen,I have written query, and selected only the key column but still the problem is same.
How big is the lookup table? What data type does the key have?
How much RAM does the machine have?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 28, 2014 at 3:33 am
Lookup table having 12 million records. we have 16 Gb of RAM.
We have five key columns , four are having data type int and one column is having nvarchar(50).
August 28, 2014 at 3:42 am
That's a bit over 1.6GB of memory you need to cache the lookup.
Maybe it's an issue when you run the package in 32-bit?
What if you execute the package in 64-bit?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 28, 2014 at 4:53 am
I executed package in 64-bit only. I also tried with 32-bit , but issue is remain same.
November 8, 2017 at 8:58 am
Hello!
Did you ever figure out the solution to this? I have the same exact problem...12 million rows in the lookup. Select is on 4 columns, an int and 3 varchars.
Getting error: A buffer could not be locked. The system is out of memory or the buffer manager has reached its quota.
Thanks for any assistance you can offer.
January 28, 2022 at 1:24 pm
Hi,
I have the same problem. Do you find any solution?
Thanks
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply