As a DBA all I can do is make a recommendation to the development area that their code be fixed. I can even point them to the exact line(s)...

This command tells SQL Server to log error 229

sp_altermessage 229, 'WITH_LOG', 'true'

GO

The script below creates the alert. I have the alert start a job that essentially captures the results...

The SQL Server service account is a domain account with local administrative permission.

/3GB deals with virtual address space, which is different then PAE, which allows you to use more then 4GB of physical memory. Using /3GB allocates 3GB of virtual address...

I tried to, but the OS would not load when the /3GB and PAE were set at the same time. We called Microsoft and was told by an OS...

I did not know that. That's something I will keep in mind. One of our server guys fixed the problem by updating various drivers/firmware. He also addressed...

Thanks Simon.  I spoke with Microsoft regarding the issue and their OS engineer and SQL engineer both recommended I not use the /3GB switch.  The OS engineer said, outside of...

Here's an update.  I spoke with Microsoft today regarding the /3GB switch and SQL 2000.  I added the switch to a server yesterday and it would not load the OS. ...

I need to use PAE in order to access more then 4GB of memory.  I've read it is ok to use /3GB provided the physical memory is less then 16GB. ...

Here's what I've entered.  It's no different then how I've done it in the past with other servers.

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /PAE /3GB

I'll enable it on our 64bit server and run some tests to see if performance has improved.  The link below appears to imply that AWE memory doesn't impact the pagefile...

I thank you both.  I find this a bit confusing since heavy use of the pagefile is a possible indication of a memory bottleneck.  However I agree that hard page faults is...

I believe those recommendations apply to application and file servers, not database servers.  With a database server if you see paging consistently appoaching 2GB you probably have some serious memory issues. ...

Hi Ellis,

I have AWE enabled in order to take advantage of the more then 4GB of memory.  The paging is very small on my new 2005 servers, between 2.5% and...

Thanks.  This does help.  But why am I seeing some pagefile access if I have so much free physical memory.  I thought the pagefile is only to be accessed if...