New server with SQL Server 2005 standard x64 crashing

We have new 64-bit server and SQL Server 2005 where we moved databases and
applications from a 32-bit server and SQL Server 2000. Since we have moved
the databases and application to the new server the server crashes and
reboots at an irregular interval. This reboot seems to always be proceeded
by the memory working set for SQL Server being paged out and available memory
going up by a large amount. This usually occurs hours before the server
crashes. The available memory stays high until the server crashes.
OS: Server 2003 Standard edition x64 Edition
Version 5.2.3790 Service Pack 2 Build 3790
Hardware: HP ProLiant DL380 G5 with two Dual core cpu's 3000 MHz.
4 GB of memory
SQL Server Standard Edition (64-bit) Version: 9.00.3054.00
Using the performance monitory we can see the memory event that proceeds the
reboot and have ruled out some likely candidates like the Anti-virus and
backup software. The reboots occur anywhere from less the 24 hours apart to
4 days.
Does anyone know of any problems with SQL Server Standard x64 and memory
problems?
Any suggestions on how to identify if SQL Server is the problem or help
identifying some other service or driver as the cause of this problem?
--
MarkI have found it helpful to set the maximum memory setting in SQL Server to
less than the total available on the server. Based on the amount of memory
on the server this max amount would from 512 MB to 1024 MB less than the
maximum installed memory amount.
"masmith" wrote:
> We have new 64-bit server and SQL Server 2005 where we moved databases and
> applications from a 32-bit server and SQL Server 2000. Since we have moved
> the databases and application to the new server the server crashes and
> reboots at an irregular interval. This reboot seems to always be proceeded
> by the memory working set for SQL Server being paged out and available memory
> going up by a large amount. This usually occurs hours before the server
> crashes. The available memory stays high until the server crashes.
> OS: Server 2003 Standard edition x64 Edition
> Version 5.2.3790 Service Pack 2 Build 3790
> Hardware: HP ProLiant DL380 G5 with two Dual core cpu's 3000 MHz.
> 4 GB of memory
> SQL Server Standard Edition (64-bit) Version: 9.00.3054.00
> Using the performance monitory we can see the memory event that proceeds the
> reboot and have ruled out some likely candidates like the Anti-virus and
> backup software. The reboots occur anywhere from less the 24 hours apart to
> 4 days.
> Does anyone know of any problems with SQL Server Standard x64 and memory
> problems?
> Any suggestions on how to identify if SQL Server is the problem or help
> identifying some other service or driver as the cause of this problem?
> --
> Mark
>|||> Does anyone know of any problems with SQL Server Standard x64 and memory
> problems?
I dont have a link at hand, but I am pretty sure that SP2 for SQL Server
fixes this issue. We had the same issue from time to time, and we ended up
setting the min and max memory usage for the sql server 1 GB lower than the
total amount of memory. I searched google, and found a site saying, that the
SP2 would fix this issue.
If you haven't installed SP2, then you should take a look at the bugfixes
for that - and maybe you can permanent fix the problem with that.
/Sjang