Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slivolsi
Starting Member
2 Posts |
 Posted - 2011-02-20 : 19:24:52
|
| I have an installation of SQL Server 2008 Workgroup Edition (ver 10.00.4000) running on Windows 2008 64 bit R2 Standard with 8gb of memory. We have an issue where the server memory slowly increases to 100% after 4 to 5 days and hangs the server. I have set the Maximum server memory to 4096mb and system paging file is currently 12288mb which is greater than the recommended 12198mb.As far as I know Lock Pages in Memory is not supported on Workgroup Edition.Any suggestions would be appreciated. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-02-21 : 03:07:14
|
| Have you gathered Performance counters ?Also why just 50% of the available memory 8GB have you assigned to the SQL ?Are there any other softwares running on the server or is a dedicated SQL Server ?PBUH |
 |
|
|
slivolsi
Starting Member
2 Posts |
Posted - 2011-02-21 : 17:13:00
|
| I have Rockwell software RSLinx and Factory Talk Transaction manager interfacing to a PLC. Other than that it is only SQL Server.I have limited the memory for SQL to 50% because of the memory issue. If I change it to 6Gb it will hang after 1 to 2 days. Which performance Counters should I be monitoring?Thanks |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-02-22 : 02:01:33
|
| Check the all the Memory related counters in the Perform monitor.Also check your SQL error logs when the server hangs.Seems like a memory paging issue for me.Try setting Lock In pages so that the memory is not paged to OS from the Buffer pool in case of memory pressure.PBUH |
|
|
|
Sachin.Nand
2937 Posts |
|
|
|
|
|
SQL Server 2008 Workgroup Edition 64 Bit Hangs