only provided you really did manage to resolve all corruption (via DBCC or any other mean), then only you can reset the suspect status via sp_resetstatus (dbname). SQL 2005 apparently...

there was one suggestion to try detach and re-attach a suspect database. i think not. if truly the database is corrupted, the chances of reattaching it is very very slim...

kgiambas is right, the thing with profiler90 is that the /M parameter which is supposed to be the end time for the profiler to stop doest seem to work. any...

ye, it is very interesting. also, i wouldnt want to rely on task manager on 32-bit, its a known bug from M$ saying the memory consumption shown there (especially those...

As far as i know, SQL doesnt utilise much page...

This is supposed to be a humour, but it isnt! lighten up for Christmas dudes 🙂 All answers should get 5 points, especially the wackiest ones!!

you can try to use vmstat.exe to view contiguous block of memory in MemToLeave area. Quest also has a stored proc xp_memory_size to check max contiguous memory. This comes with...

try to use the -g flag in sql startup to increase the MemToLeave area (make it to ~512MB) if you still encounter the error.Let us know if this helps.

my 2...

From your description, the error msg might not dissapear after making these switch changes in the boot.ini file. I suspect something in the application that is connecting to SQL or...

might as well just use DBCC INPUTBUFFER(spid).

saves you from typing too.. wonder why the need to select and save the "encrypt" and then "decrypt"

Hi Dave,

yes, apparently PAE enables several advanced system and processor features such as DEP, hot-add mem, NUMA, etc. This switch only applies to 32-bit OS.

I believe the HP mgmt...

Hi Dave,

The memory you see has nothing to do with PAE. PAE is only used to access >4GB memory on a 32-bit WinOS. As Phil has explained, one possible reason...

syed muhammad naveed (10/29/2007)

---

Dear CJR

dont worry its happened

any ways i am giving you some techenique if you follow you will get rid off this issue

For example your...

Murali,

with or without the /3gb and/or awe enabled, sql server wont be able to utilise anything more than 2gb since you've only got 4gb memory in total without kb899761. this...

Murali,

AWE is required to access more than 3GB memory of user-mode VAS (Here since you've got the /3GB switch enabled, this will increase the user-mode VAS to 3GB and AWE...