• It's not using large pages, don't worry about that. Without traceflag 834 SQL won't use large pages, it enables the extensions, but that's all.

    http://blogs.msdn.com/b/psssql/archive/2009/06/05/sql-server-and-large-pages-explained.aspx <- explained there why you see that entry in the error log.

    When SQL's actually using large pages, your error log entry looks like:

    2009-06-04 14:20:31.13 Server Large Page Extensions enabled.

    2009-06-04 14:20:31.13 Server Large Page Granularity: 2097152

    2009-06-04 14:20:31.14 Server Large Page Allocated: 32MB

    2009-06-04 14:20:40.03 Server Using large pages for buffer pool.

    2009-06-04 14:27:56.98 Server 2048 MB of large page memory allocated.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass