SQL 2005 - Not responding

SQL 2005 - Not responding - freezing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

benxxv - 04 Jul 2008 12:48 GMT

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.

Reply to this Message

Dan Guzman - 04 Jul 2008 14:30 GMT

> 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.

Signature

Hope this helps.

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

> Hi,
>
[quoted text clipped - 16 lines]
>
> Regards.

Reply to this Message

vinu - 07 Jul 2008 16:30 GMT

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

> Hi,
>
[quoted text clipped - 16 lines]
>
> Regards.

Reply to this Message