[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

Server 2008 x64 becomes unresponsive running VM ware server 2.0

I have been working on this issue for 2 weeks.  The server is a dual quad opteron with 16 Gb ram.  There are 4 VM's on the box and I believe I have nailed down the cause to the VM running SQL 2005.  All four VM's are win 2003 std.  The issue occurs over time as if the SQL slowly grinds it to a halt.  Nothing really shows in the performance monitors on the VM or the host.  Although, giving the VM more Ram to work with seems to delay the crash.  The odd thing is the Host, while inaccessable, still seems to run the vm's in the background and I can remote into them.  I have trend AV, all the latest patches and have scanned for malware.  Anyone who might have an idea and needs more info just ask and I will supply the information.
0
simpkinst
Asked:
simpkinst
  • 4
  • 3
1 Solution
 
-DJL-Commented:
Do you have the latest version of VMware Server 2 -  build 122956 is the latest.

Anything in the hosts event log?

Is this a new problem?  Or has it always existed with this setup?

Hows the memory allocated between the VMs?

0
 
simpkinstAuthor Commented:
I do indeed have the latest VM Ware.  There is nothing out of the ordinary in the logs.  These machines were set up during the holidays(dec) and were fine until the Vendor began loading the apps on them.  They are CRM servers (Pivotal) and it seems that the  VM's and host are ok as long as the SQL server has the SQL server service shut down.(meaning it runs ok as long as they are not utilized)  Each of the four hosts have 2 GB of ram except for the SQL server, I upped that to 4gb but it doesnt seem to help.
0
 
-DJL-Commented:
Are you running SP2 or SP3 on SQL2005?

Have you specified the maximum amount of memory SQL can use?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
simpkinstAuthor Commented:
SP3 on SQL 2005, I have not specified the max amount of ram SQL can use but have given the vm 8 GB to use at one point and it still locked the host.
0
 
-DJL-Commented:
I would try specifying a memory limit on SQL.  Also, do you know what the memory usage was on the sql guest around the point the host locked

Which opterons are you running?  Do you have the latest motherboard BIOS installed.
0
 
-DJL-Commented:
any luck with this?
0
 
simpkinstAuthor Commented:
Looks like not having it run as a VM took care of the issue.  My guess is something on the Pivotal CRM suite was running away with the memory on a VM/SQL combo.  The memory response was the right tree to bark to I think...
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now