Cache Problem - URGENT HELP !

Dear All,
I have web application (ASP.NET) where I use SQL Server Std Server
engine as backened.
The issue that I have noticed whenever I ran "perfmon" the Total Pages
and Cache Pages alway showss 100 which is topmost.
My WEB application execute many SP that return data to client. In most
of SPs I create Temp Table and drop the same upon completion of SP.
Also I get an alert from SQL Performance monitor tool which is shown
below:
" Not enough physical memory has been left for NT; this will cause
excessive NT paging, resulting in poor performance."
My SQL Server RAM 1 GB. Have configured SQL Server to "to dynamically
confgiure SQL memory"
Do you know what could be the problem of hitting "Total Pages" and
"Cache Pages" 100.
Kindly help and advise..
Many thanks in advance
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!If you only have 1 GB of RAM on the server, and the memory is maxed out, I
would check the counters in Performance Monitor to see if it indicated a
need for more RAM in the box... Are you running IIS and SQL Server on the
same box? Try setting your SQL Server to use a fixed amount of RAM (maybe
800 MB depending on what else you have running on that box?)
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> wrote in message
news:%23q3Gl6tMFHA.3328@.TK2MSFTNGP14.phx.gbl...
> Dear All,
> I have web application (ASP.NET) where I use SQL Server Std Server
> engine as backened.
> The issue that I have noticed whenever I ran "perfmon" the Total Pages
> and Cache Pages alway showss 100 which is topmost.
> My WEB application execute many SP that return data to client. In most
> of SPs I create Temp Table and drop the same upon completion of SP.
> Also I get an alert from SQL Performance monitor tool which is shown
> below:
> " Not enough physical memory has been left for NT; this will cause
> excessive NT paging, resulting in poor performance."
> My SQL Server RAM 1 GB. Have configured SQL Server to "to dynamically
> confgiure SQL memory"
> Do you know what could be the problem of hitting "Total Pages" and
> "Cache Pages" 100.
> Kindly help and advise..
> Many thanks in advance
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Michael,
Thanks for reply.
Yes, I have IIS and SQL on same box. I tried below statment to check
memory used which is return 753 MB used.
Also I checked following counters on "Performance" monitor this AM which
return as follows:
Object: SQL Server: Memory Manager:
--
Counter: Total Server Memory (KB) shows between 75-80
Object: Memory
--
Counter: Cache Bytes shows 100
Object: SQL Server: Cache Manager:
--
Counter: Cache Pages Shows between 50-55
Counter: Cache Object Counts 100
Object: ASP.NET Application
--
Counter: Cache Total hits shows 100
Due to all above, I suspect that my application might have affected it's
performance. I mean, in terms of speed.
How can I resolved this problem ?. Shall I increase the RAM ? What about
the Cache counters ? The pages in the cache, would it increase the
performance or decrease the performance ?
What about if I apply following DBCC commands ?. Will it help ?
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
I would really appreciate your tips or advise to increase the
performance of the application.
Many thanks in advance...
Regards,
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||My first thoughts would be - if at all possible, get IIS on it's own box.
If not possible, I would set SQL Server to have a Fixed Memory size.
Offhand I would say that your memory might be a bottleneck - to find out for
sure, you might want to check other counters. Here's a page that lists some
other counters you might want to check to verify that it is a memory
problem:
[url]http://www.sql-server-performance.com/performance_monitor_counters_memory.asp.[/ur
l]
If you determine it is a memory problem, your best bet might be to add some
memory to the box...
"Ahmed Jewahar" <ahmed.jewahar@.dhl.com> wrote in message
news:OBd7ZE2MFHA.3328@.TK2MSFTNGP14.phx.gbl...
> Michael,
> Thanks for reply.
> Yes, I have IIS and SQL on same box. I tried below statment to check
> memory used which is return 753 MB used.
>
> Also I checked following counters on "Performance" monitor this AM which
> return as follows:
> Object: SQL Server: Memory Manager:
> --
> Counter: Total Server Memory (KB) shows between 75-80
> Object: Memory
> --
> Counter: Cache Bytes shows 100
> Object: SQL Server: Cache Manager:
> --
> Counter: Cache Pages Shows between 50-55
> Counter: Cache Object Counts 100
> Object: ASP.NET Application
> --
> Counter: Cache Total hits shows 100
> Due to all above, I suspect that my application might have affected it's
> performance. I mean, in terms of speed.
> How can I resolved this problem ?. Shall I increase the RAM ? What about
> the Cache counters ? The pages in the cache, would it increase the
> performance or decrease the performance ?
> What about if I apply following DBCC commands ?. Will it help ?
> DBCC FREEPROCCACHE
> DBCC DROPCLEANBUFFERS
> I would really appreciate your tips or advise to increase the
> performance of the application.
> Many thanks in advance...
> Regards,
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!