MSAS/SQL Server 2K on VMWare

Greetings,

My company has decided to put our environment of MSAS/SQL Server 2K on
VMWare. One application in particular which has been in production for a
number years recently has been having a habit of running much longer than
expected(SQL cpu ~ 100%)...until I eventully kill it. The application used
to take 12 minutes to pull the data and process a cube. I'll see behaviour
where it will process 2 or 3 times sucessfully in a row, and then it run for
hours, until I eventually cancel the job. We have 2 servers. One for MSAS
and the other for SQL. Could VMWare be causing these issues? How can I best
to determine the root cause? Our VMWare administrator tells me that I'm
getting pretty much all of the CPU & memory that is available, but I'm
wondering what else could be impeding the job.

Any ideas would be most appreciated

Thanks
John


.

Relevant Pages

  • Re: (Now OT) Thin client question - (I think?)
    ... My original question was about a production ... dupe on the network if one is on while the other is booting), ... If you bridge the network for vmware, ... production environment, but they've WORKED. ...
    (Ubuntu)
  • Re: does fedora support 2 CPU system w/ HT?
    ... > I installed Fedora and did not find any option for enabling ... > Fedora I only see one CPU. ... > Might be a configuration option from VMware? ... Under normal circumstances, Anaconda, which is the RH/FC installer, will ...
    (linux.redhat.misc)
  • Re: does fedora support 2 CPU system w/ HT?
    ... > I installed Fedora and did not find any option for enabling ... > Fedora I only see one CPU. ... > Might be a configuration option from VMware? ... Under normal circumstances, Anaconda, which is the RH/FC installer, will ...
    (linux.redhat)
  • VMware Server 1.0.5 build-80187 + host: ubuntu 6.06; Guest Windows XP freezing.
    ... Some of you might advice me to post on the vmware forums, ... first i thought it was the host messing stuff up, ... I've monitored CPU and memory usage on the host, ... CPU and mem are 100%, while XP is runnig CPU drops to 10-15% and mem ...
    (Security-Basics)
  • Re: VMware Server 1.0.5 build-80187 + host: ubuntu 6.06; Guest Windows XP freezing.
    ... Some of you might advice me to post on the vmware forums, ... first i thought it was the host messing stuff up, ... I only get this output in the vmware.log for XP and no other guest. ... I've monitored CPU and memory usage on the host, ...
    (Security-Basics)