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


  Wednesday, April 17, 2024
Wider View Login

IBM - AS400
Performance Counters
Service Broker
SQL Server
     Temporary Database
     SQL Mail
     DTS - Data Transformation Services
          2gb or More Memory
     Jobs SQL Agent
     User Management
     System Databases
     Temp Tables
Windows OS

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 */