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