SQL Server Performance

Large pages -T834

Discussion in 'ALL SQL SERVER QUESTIONS' started by acki4711, Aug 17, 2012.

  1. acki4711 Member

    Hi all,
    Just set up a Win 2008 ent. sp2 server with sql 2008 r2 ent. with large pages on and traceflag -T834 set. Server has 32 GB RAM, SQL instance memory min = 10 GB, max = 25 GB.
    When I now startup sql instance I see in Errorlog the following:

    2012... Server Detected 12 CPUs. This is an informational message; no user action is required.
    2012... Server Large Page Extensions enabled.
    2012... Server Large Page Granularity: 2097152
    2012... Server Large Page Allocated: 32MB
    2012... Server Large Page Allocated: 32MB
    2012... Server Using large pages for buffer pool.
    2012... Server 3200 MB of large page memory allocated.
    2012... Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

    My understanding when using large pages and Traceflag 834 is that sql server tries to occupy all the memory (max) at startup and if it is not continuosly somthing lower then memory max. But log says now that he just allocated 3 GB large page memory ??? How comes and why do I not see those allocated memory in Taskmanager if it's allocated during startup ???

    TIA for some light in the dark...

Share This Page