Server Hangs

Question

Post reply

Server Hangs

jabinc

SSC Rookie

Points: 48
More actions
December 6, 2012 at 3:12 am

#271570

i had installed IIS 7.5 & SQL Server 2008 Std on Windows server 2008 R2 Std. over IBM Quad Core server with 12 GB RAM
the application is accessed from 18 locations over intranet wan and over 100 simultaneous connections are there.
the application runs smoothly and is very fast responding initially. but over time, the memory used by the server increases and ultimately IIS hangs
while checking the perfmon, the memory used by IIS and SQL shows only around 300 - 900 MB.
At first we restart the server, but now after restarting the SQL Server releases the memory from 11.8 GB to 5 GB.
I had checked several forums of both IIS and SQL Server and did all the suggestions in IIS and SQL server. but the problem persists
The server hangs once per day. after releasing the memory, the server works very well.
while checking , we found that memory increases when there are lot of client connection

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Gazareth One Orange Chip Points: 27737 More actions · Answer 1

Have you configured max server memory in SQL Server?

SQL loads data into RAM and will use as much memory as you allow it to.

MasterDB Hall of Fame Points: 3054 More actions · Answer 2

Your Windows Machine is 32-bit or 64-bit.

If 32-bit, Please Enable AWE. For 64-bit machines it is auto enabled.

If possible, increase the Virtual memory on your machine.

Divine Flame SSCoach Points: 15943 More actions · Answer 3

Gazareth (12/6/2012)
Have you configured max server memory in SQL Server?
SQL loads data into RAM and will use as much memory as you allow it to.

+1

You must configure the min. & max. server memory properties for SQL Server.

Since IIS is existing on the same server you should configure SQL Server memory limits acording to that.

Sujeet Singh

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 4

What other applications are running on that server?

Is it 32/64 bit?

Who is consuming most of the memory is it IIS or SQL Server?

Set the perfmon counters and see the memory utilization.

Pavan.

jabinc SSC Rookie Points: 48 More actions · Answer 5

Gazareth (12/6/2012)
Have you configured max server memory in SQL Server?
SQL loads data into RAM and will use as much memory as you allow it to.

i tried max server memory in sql server as 8 GB. still the memory increases over 11 gb and hangs

jabinc SSC Rookie Points: 48 More actions · Answer 6

MasterDB (12/6/2012)
Your Windows Machine is 32-bit or 64-bit.
If 32-bit, Please Enable AWE. For 64-bit machines it is auto enabled.
If possible, increase the Virtual memory on your machine.

its a 64 bit machine & 64 OS installed

please tell me how to increase virtual memory in the server

jabinc SSC Rookie Points: 48 More actions · Answer 7

dba_pkashyap (12/6/2012)
What other applications are running on that server?
Is it 32/64 bit?
Who is consuming most of the memory is it IIS or SQL Server?
Set the perfmon counters and see the memory utilization.
Pavan.

64 bit. IIS consumes an average of 90 - 600 at peak time (in perf mon )

SQL server consumes an average of 150 - 700 at peak time (in perf mon )

it is actually the memory utilised by process of these programs no ?

how can i check how much memory is used for caching / temporary tables etc. ?

the server also has Active directory and DNS configured

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 8

jabinc (12/6/2012)
The server hangs once per day. after releasing the memory, the server works very well.
while checking , we found that memory increases when there are lot of client connection

By the above statement, it can be possible that the application actually creates/access some exe or a process, which in turn is actually consuming most of the memory and not releasing it as the process is not killed/closed / decommissioned properly etc..

Pavan

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 9

jabinc
i tried max server memory in sql server as 8 GB. still the memory increases over 11 gb and hangs

8gb is only the buffer pool memory, other memory is used by clr/extended procs/linked servers etc or it can be of backups/ssis/ssrs/ssas etc...

Pavan.

Jeff Moden SSC Guru Points: 1004290 More actions · Answer 10

jabinc (12/6/2012)
MasterDB (12/6/2012)
Your Windows Machine is 32-bit or 64-bit.
If 32-bit, Please Enable AWE. For 64-bit machines it is auto enabled.
If possible, increase the Virtual memory on your machine.
its a 64 bit machine & 64 OS installed
please tell me how to increase virtual memory in the server

I honestly don't believe that will help because I think the code either has a memory leak or a connection leak.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)