Prev: SQL 2008 Policy management through sql queries
Next: Script to get DB space usage Info.
From: benxxv via SQLMonster.com on 4 Jul 2008 07:48
Hi,

I have SQL Server 2005 Standard on a Windows Server 2003 64Bit Operating
System, Dell PowerEdge2900 with 8GB RAM.

Once in couple of months, the SQL Server just stops responding for my client
requests which my application uses as a backend database.

The memory usage of SQL Server goes as high as 4GB out of my 8GB RAM. All I
do is, restart SQL Services and the RAM usage goes down to an average of only
300MB RAM and my application starts working fine.

Can any one help...Is it required that I restart SQL Services every now and
then ?

Regards.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200807/1

From: Dan Guzman on 4 Jul 2008 09:30
> The memory usage of SQL Server goes as high as 4GB out of my 8GB RAM. All
> I
> do is, restart SQL Services and the RAM usage goes down to an average of
> only
> 300MB RAM and my application starts working fine.

It is normal for SQL Server to allocate significant amounts of memory and
not release it unless it detects memory pressure, assuming the default
memory settings. This maximizes performance due to cached data.

When the application freezes, do you have any other symptoms? Can you
connect and run queries via SSMS? Have you checked for blocking? Do you
have any related messages in the errorlog?

> Can any one help...Is it required that I restart SQL Services every now
> and
> then ?

You should not need to routinely restart SQL Server. My guess is that the
restart cleared some problem.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"benxxv via SQLMonster.com" <u30064(a)uwe> wrote in message
news:86a460ae4e4a0(a)uwe...
> Hi,
>
> I have SQL Server 2005 Standard on a Windows Server 2003 64Bit Operating
> System, Dell PowerEdge2900 with 8GB RAM.
>
> Once in couple of months, the SQL Server just stops responding for my
> client
> requests which my application uses as a backend database.
>
> The memory usage of SQL Server goes as high as 4GB out of my 8GB RAM. All
> I
> do is, restart SQL Services and the RAM usage goes down to an average of
> only
> 300MB RAM and my application starts working fine.
>
> Can any one help...Is it required that I restart SQL Services every now
> and
> then ?
>
> Regards.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200807/1
>

From: vinu on 7 Jul 2008 11:30
Hi

First thing you need to do is, check the sql server error log, windows
application event log. does any of this log says anything???

vinu

"benxxv via SQLMonster.com" <u30064(a)uwe> wrote in message
news:86a460ae4e4a0(a)uwe...
> Hi,
>
> I have SQL Server 2005 Standard on a Windows Server 2003 64Bit Operating
> System, Dell PowerEdge2900 with 8GB RAM.
>
> Once in couple of months, the SQL Server just stops responding for my
> client
> requests which my application uses as a backend database.
>
> The memory usage of SQL Server goes as high as 4GB out of my 8GB RAM. All
> I
> do is, restart SQL Services and the RAM usage goes down to an average of
> only
> 300MB RAM and my application starts working fine.
>
> Can any one help...Is it required that I restart SQL Services every now
> and
> then ?
>
> Regards.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200807/1
>


 | 
Pages: 1
Prev: SQL 2008 Policy management through sql queries
Next: Script to get DB space usage Info.