-
sql 2005 mem ? round 2
I have a sql 2005 enterprise edition running on win2003 with 16 gig of memory. I was getting errors on sql server while running a large query. I have the same boot.ini on a sql 2000 server running on win2003 and it utilizes all the memory.
now have the following for my boot.ini
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOW S
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windo ws Server 2003, Enterprise" /fastdetect /PAE /NoExecute=OptIn
Is there a way with a dbcc command I can see if sql 2005 is using the 15 gig I have it set to? I run sp_configure and it shows 15 gig as the setting
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|