64 bit system enterprise edition: check error log and on start up you'll
see "Using locked pages for buffer pool"

If you are using 32bit system " Address Windowing Extensions is enabled'
but the AWE setting needs to be set to 1 or you won't see these.

http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-
lock-privilege-for-local-system.aspx


PAYCHEX
Christopher Bellizzi
Information Technology * Database Administration
675 Basket Road * Webster, New York 14580
(585) 216-0670 * [Email address protected]


-----Original Message-----
From: Roberts Adonnica Ms CIV USA AMC
[mailto:mssqldba-ezmlmshield-x27466879.[Email address protected]
Sent: Thursday, November 29, 2007 2:23 PM
To: LazyDBA Discussion
Subject: SQL Server 2000 Lock & Memory Configuration (UNCLASSIFIED)

Classification: UNCLASSIFIED
Caveats: NONE

How do you check the lock & memory configuration? Any tips for optimal
settings? Considerations? Thanks in advance.

Regards,

Adonnica L. Roberts
Computer Scientist
CE-LCMC SEC-Belvoir
Voice: (703) 806-3442 DSN 656
Classification: UNCLASSIFIED
Caveats: NONE


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



-----------------------------------------
The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution, or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately
by replying to the message and deleting it from your computer.

Thank you. Paychex, Inc.

MS Sql Server LazyDBA home page