I have a server that has 32GB of RAM and SQL Server 2014 Enterprise installed over it. I want to try the impact of Buffer Pool Extension (BPE) on Full Text Population.
I created a table and populated it with dummy information till it reached 100GB of size.
First I tried populating the full text index before BPE. It took 3 hours. Then I tried populating the full text index with BPE configured on a 140GB SSD with 120GB allocated memory. The weird thing is the population of the full text index didn't get any faster.
I used the following query to create the BPE on SSD then restarted the instance:
alter server configuration
set buffer pool extension
on ( filename = 'Z:\Cache.bpe' , size = 120gb )
The questions are :
How to check the buffer pool usage of SQL Server ( I want to know if the BPE is used )?
Does BPE affect FullText index population?
Did I miss any Server or Buffer Pool configuration?