There is nothing else on the server except SQL.
Checked the processes running nothing was consuming the 42 gig.
So the only thing i did was a DBCC CHECKDB command and thats when i see this go into PF.
Thats what i was thinking the data cache is in memory not in PF.
But i can do this everytime shutdown sql bring it up run command and the PF increases each time.
i have set the lock in pages which means, all memory that is allocated for the buffer pool will be ineligible for paging by Windows. ((kb 918483).
So im assuming this is not actually working then?