The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Sunday, July 22, 2018

 


Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
Cook Book

 

DSC02668.JPG

  bob Links
Microsoft TechNet
Beer was not made to be moralized about, but to be drunk. - Theodore Maynard
Wider View Insert

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
     Views
     Backup
     SQL Mail
     DTS - Data Transformation Services
     Memory
          2gb or More Memory
     Security
     Excel
     Jobs SQL Agent
     MSDE
     Install
     DBCC
     User Management
     System Databases
     BCV
     Deadlocks
     Temp Tables
Windows OS

Insert Category

Will be added as a sub-category of, Memory
2gb or More Memory
-- configuring sql server to use more than 2gb of ram -- ensure you are running windows 2000 advanced server -- ensure the boot.ini file has been adjusted /pae /3gb swithces sp_configure 'show advanced options', 1 RECONFIGURE GO sp_configure 'awe enabled', 1 RECONFIGURE GO -- increments of 1024 sp_configure 'max server memory', 4096 RECONFIGURE GO /* You must also enable "lock pages in memory" for the id that sql server is using */ /* How to enable the Lock Page in Memory option (Windows) Note This functionality is available only if you are running the Microsoft® Windows® 2000 operating system. To enable the Lock Page in Memory option On the Start menu, click Run, and then in the Open box, type gpedit.msc. On the Group Policy console, expand Computer Configuration, and then expand Windows Settings. Expand Security Settings, and then expand Local Policies. Select the Users Rights Assignment check box. The policies will be displayed in the details pane. In the details pane, double-click Lock pages in memory. In the Local Security Policy Setting dialog box, click Add. In the Select Users or Groups dialog box, add an account with privileges to run sqlservr.exe */ /* -- Verification Reboot the server Verify the SQL Server log has the following entry and no errors anywere: Address Windowing Extensions enabled. - It is ok to have sql mail errors in the log as this is normal */