Hi Guys,

I would like to ask one quick question regarding Page File Usage in Task
Manager, currently we have 8 GB memory in one of our Server and I can see 7.5
GB usage in PF Usage task manager. When I stop SQL Server Service it goes
down to 700 MB and when I start SQL Server Service and when we run couple of
stored procedure it again hit to 7.5 GB, any idea what needs to be done to
resolve this issue.
Thanks in advance.

Hi Rogers,

The first thing that I can think of is SQL Server is not configured to use
most of the memory on the server and therefore has to go to the Page File.
What version of SQL Server are you running and is it 32 bit or 64 bit? I
would run the sp_configure in SQL Server to see if AWE had been enabled and
what the Max Memory is set at. Post back and let us know!.

SQLSquirrel
http://www.lockergnome.com/sqlsquirr...m-sqlsquirrel/


"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote

Thanks for your reply.

SQL Server runs on 64 BIT..... max memory I was configured to 7 GB. AWE is
disabled..

Thanks

"Brett Davis" <sqlsquirrel (AT) msn (DOT) com> wrote

Then, what you described is expected behavior because you did give the SQL
Server process 7GB. This plus the memory used by other OS processes brings it
to 7.5GB.

Linchi

"Noor" wrote: