Problem with SQL Server Enterprise Manager

[djlaauol]

Hola soy novato en esto, y estoy aprendiendo muchísimo gracias a este hermoso proyecto proxmox...


aquí va mi pregunta....




tengo instalado Proxmox v2.0 sobre un server hp proliant ML110 G3
y tengo creado 2 VM's


vm1 = Windows Server 2003 RS2 con Active Directory
vm2 = Windows Server 2003 RS2 con SQL Server 2000


Todo funciona perfecto. Ambas VM se originan de PC fisicas, y fueron convertidas a discos con extension .vmdk


Hasta que encontré una falla que no puedo comprender el motivo...


Puedo grabar datos y leer datos de las tablas en el SQL2000. Pero cuando necesito abrir la tabla mediante el Enterprise Manager usando una conexión localhost > databases > tables > sample1 > Open Table > Return Top ... el programa queda congelado, no responde... pero la VM no se muere.


Entonces copie la VM2 a otra PC con proxmox 1.9 y funciona perfecto el Enterprise Manager....


entonces la unica solucion es migrar todo a proxmox 1.9 ? o existe algún método para poder usar proxmox 2.0 y solucionar el Enterprise Manager ?

------------------------------------googletranslations
​Hello I amnew tothis,and I'mlearning a lotthanks to thiswonderful projectProxmox...

here's my question....


I have installedProxmoxServerv2.0on aHP ProLiantML110G3
and I havecreated 2VM's

vm1=Windows Server 2003with ActiveDirectoryRS2
vm2=Windows Server 2003withSQLServer 2000RS2

Everything worksperfect.BothVMoriginate fromphysicalPC,andwere converted todiscs withextension.Vmdk

Until I founda flaw thatI can notunderstand why...

I canwrite dataand read data fromtablesinSQL2000.Butwhen I need toopen thetable using theEnterpriseManagerconnectionusinglocalhost>databases>tables>sample1> OpenTable>ReturnTop...the programis frozen, no response...but theVMdoes not die.

Then copytheVM2to anotherPCwithProxmox1.9 andthe EnterpriseManagerworks fine....

then theonly solutionis to migrateeverything toProxmox1.9?or is theresome methodto useProxmox2.0 andfix theEnterpriseManager?

 

[udo]

Hi,
perhaps an IO-Problem on the pve2-node? What is the output of "pveperf /var/lib/vz" on both nodes (pve2 and where all runs fine)?

Are there a lot other IOs? Check with "iostat -dm 5 <device>". You must install sysstat to get iostat.

Udo

 

[djlaauol]

Take another test, this is to install a Proxmox 2.0 from the CD. but this time, I have not used apt-get upgrade, without having done updates, copy to inside / var/lib/vz/101 the. vmdk ... then open the Enterprise Manager program and when I try to open the table works perfect.
That is what might be causing the problem, because before mounting the VM's had done an apt-get upgrade.


Now I did another test. Install the Enterprise Manager client on another physical PC, and it works great.


For now I'll have to reinstall everything from scratch, but without using the apt-get upgrade. or my other option will use the Enterprise Manager remotely, but not the same for my daily tasks.
-------------------------------------------------------------------------------
Realice otra prueba, esta consiste en instalar un proxmox 2.0 desde el CD. pero esta vez, no he utilizado el comando apt-get upgrade, sin haber echo actualizaciones, copie a dentro de /var/lib/vz/101 el archivo .vmdk ... luego abro el programa Enterprise Manager y cuando intento abrir la tabla funciona perfecto.
Eso es lo que pudo causar el problema, porque antes de montar las VM's habia realizado un apt-get upgrade.


Ahora hice otra prueba. Instale el Enterprise Manager en otra PC cliente fisica, y funciona muy bien.


Por el momento tendre que reinstalar todo de cero, pero sin hacer uso del apt-get upgrade. o mi otra alternativa sera utilizar el Enterprise Manager de forma remota, aunque no es lo mismo para mis tareas diarias.

 

[djlaauol]

Hola a todos, hice muchas pruebas, y al final no tuve solución... Instale muchas veces el proxmox version 1.9 y 2.0 en uno de los servidores HP Proliant ML115 con microprocesador opteron 1210 y 4 GB de RAM...

Utilizando el mismo archivo de disco .vmdk en todas mis pruebas, aun no comprendo el motivo de la falla cuando intento abrir localmente las tablas usando el Enterprise Manager no responde...

Lo que me llama aun mas la atención, es que instale proxmox 2.0 en un PC Desktop AMD Phenom X555 con 4 GB de RAM, mother Asus... y puedo abrir las tablas con Enterprise Manager localmente, alguno experimentado que pueda asesorarme por favor

Pido disculpas por mi falta de ingles, uso el traductor de google para traducir. ...muchas gracias...

--------------------------------

Hi all, I did many tests, and finally I had no solution ... Often the Proxmox installversion 1.9 and 2.0 on a HP Proliant server ML115 Opteron microprocessor1210 and 4 GB of RAM ...

Using the same disk file. Vmdk in all my tests still do not understand the reason for failure when trying to open locally tables using the Enterprise Manager does not respond ...

What strikes me even more attention is to install Proxmox 2.0 on a Desktop PCAMD Phenom X555 with 4 GB of RAM, Asus mother ... and I can open the tableswith Enterprise Manager locally, you can advise me some experience please

I apologize for my lack of English, use the google translator to translate. thank you very much ... ...

 

[tito]

Yo que vos no usaria discos virtuales vmdk.
Para windows, ellos recomiendan usar modo raw con discos ide.
Para Linux, lo mejor es usar discos raw con virtio. Muy buenos resultados.

 

[djlaauol]

como puedo convertir mis unidades vmdk a raw ? Gracias tito

 

[m.ardito]

read this

http://linux.die.net/man/1/qemu-img

Marco

 

[djlaauol]

Voy a ensayar y luego te comento lo que suceda...

Gracias

 

[djlaauol]

Hola, gracias por la idea que me sugieren, pero no funciono.

Lo que no me explico es esto.

Tengo dos servidor HP
HP ProLiant ML110 G5 ( 2 x Intel Xeon CPU E3110 @ 3.00 Ghz)
HP ProLiant ML115 G1 ( 2 x Dual-Core AMD Opteron 1210)

Ademas tengo una PC Escritorio ( 2 x AMD Phenom II X2 560 ) Con placa madre ASUS M4A78LT-M LX

Todas las maquinas tienen instalado Proxmox v2 actualizado.
Todas tienen 4GB de Ram y Discos de 500 GB SATA.
Todas tienen la misma imagen de disco VMDK obtenidas de servidores fisicos usando el vmwareconvert
Todos los Nodos ejecutan 2 maquinas virtuales ( VM100: Windows 2003 DNS) (VM101: Windows 2003 MSSQL 2000)


Sobre los servidor HP ... cuando utilizo el Enterprise Manager no puedo abrir las tablas del SQL.

Existe una excepción: en el servidor HP ProLiant 110ML usando Proxmox v1 obtenemos buenos resultados, y funciona perfectamente el Enterprise Manager, permitiendo editar y abrir las tablas.

Pero usando la PC Escritorio funciona perfectamente el Enterprise Manager y puedo editar y abrir las tablas SQL. con cualquiera de las versiones de proxmox v1 o v2.


Probe convertir los discos en raw y produce el mismo resultado.

Luego les subo un video así puedo mostrarles mejor el detalle...

Escucho mas sugerencias :


---------------------------------------------------------------------------------
Hi, thanks for the idea that I suggested, but did not work.

What I do not understand is this.

I have two HP server
HP ProLiant ML110 G5 (2 x Intel Xeon CPU E3110@3.00 Ghz)
HP ProLiant ML115 G1 (2 x Dual-Core AMD Opteron 1210)

Also I have a Desktop PC (2 x AMD Phenom II X2 560) With ASUS motherboard M4A78LT-M LX

All machines have installed Proxmox v2 updated.
All have 4GB of Ram and 500 GB SATA disks.
All have the same VMDK disk image obtained using the physicalserver vmwareconvert
All nodes running 2 VMs (VM100: Windows 2003 DNS) (VM101: Windows 2003 MSSQL 2000)


On HP server ... when using the Enterprise Manager I can not openSQL tables.

There is one exception: in the HP ProLiant server using Proxmox v1110ml obtain good results, and it works perfectly EnterpriseManager, allowing you to edit and open tables.

But using the PC Desktop Enterprise Manager works fine and I canopen and edit SQL tables. with any version of Proxmox V1 or V2.


Probe convert raw disks and produces the same result.

Then I upload a video so I can better show the detail ...

I hear more suggestions:

 

[udo]

...

---------------------------------------------------------------------------------
Hi, thanks for the idea that I suggested, but did not work.

What I do not understand is this.

I have two HP server
HP ProLiant G115 (2 x Intel Xeon CPU E3110@3.00 Ghz)
HP ProLiant 110ml (2 x Dual-Core AMD Opteron 1210)


Also I have a Desktop PC (2 x AMD Phenom II X2 560) With ASUSmotherboard.

On HP server ... when using the Enterprise Manager I can not openSQL tables.

But using the PC Desktop Enterprise Manager works fine and I canopen and edit SQL tables.

Both have the same VM vmdk disks.
Probe convert raw disks and produces the same result. only variesin hardware.

Then I upload a video so I can better show the detail ...

I hear more suggestions:

Hi,
you have also pve running on the desktop-pc?
I guess your IO-Performance is better on this hardware? What values show pveperf (on the disk, which you are using for the VM)?
If you tried to open the Enterprise Manager, what shows "top" (wait and sys).

Udo

 

[djlaauol]

Hola de nuevo. Miren el video, aca esta la muestra del problema que tengo.

http://www.youtube.com/watch?v=Ep6OZxmrUfY&feature=youtu.be


Primero les muestro el PC de Escritorio, que ejecuto perfectamente el Enterprise Manager, y puedo abrir y ver los datos de mis tablas.

Luego ingreso al Proxmox instalado en mi segundo servidor HP ProLiant 110ML y produce el error, no abre ni responde la aplicación.

Todas tienen la misma imagen de disco y configuración.

--------------------------------------------------------------------------------

Hello again. Look at the video, here is the sample of the problem I have.

http://www.youtube.com/watch?v=Ep6OZxmrUfY&feature=youtu.be

First I show the Desktop PC, which run perfectly Enterprise Manager,and I can open and view the data in my tables.

Then enter the Proxmox installed on my second 110ml HP ProLiant server and produces the error, does not open the applicationresponds.

All have the same disk image and configuration.

Gracias ! / Ty!

 

[udo]

...

Hello again. Look at the video, here is the sample of the problem I have.

http://www.youtube.com/watch?v=Ep6OZxmrUfY&feature=youtu.be

First I show the Desktop PC, which run perfectly Enterprise Manager,and I can open and view the data in my tables.

Then enter the Proxmox installed on my second 110ml HP ProLiant server and produces the error, does not open the applicationresponds.

All have the same disk image and configuration.

Gracias ! / Ty!

Hi,
strange. Please post the vm-config from the not working node and the vm-config from the amd-desktop system (working).

Udo

 

[djlaauol]

Desktop PC (2 x AMD Phenom II X2 560) Winner ?
Hardware Details in html: https://docs.google.com/open?id=0B_miX3U-7HAlY3NSOGEza29RNTJxQVJGaGRTRWdHUQ


FILE: 101.conf

bootdisk: ide0
cores: 1
ide0: local:101/vm-101-disk-1.vmdk
ide1: local:101/vm-101-disk-2.vmdk
ide2: local:101/vm-101-disk-3.vmdk
ide3: none,media=cdrom
memory: 512
name: Svrtunning
net0: virtio=92:5F:E0:F64:48,bridge=vmbr0
onboot: 1
ostype: wxp
sockets: 1

HP ProLiant ML110 G5 ( 2 x Intel Xeon CPU E3110 @ 3.00 Ghz) Losser ?
​Hardware Details in html: https://docs.google.com/open?id=0B_miX3U-7HAlU0lNNl9MSklURS1fVkZrS1VvcnBWdw


FILE: 101.conf

bootdisk: ide0
cores: 1
ide0: local:101/vm-101-disk-1.vmdk
ide1: local:101/vm-101-disk-2.vmdk
ide2: local:101/vm-101-disk-3.vmdk
ide3: none,media=cdrom
memory: 512
name: Svrtunning
net0: virtio=92:5F:E0:F64:48,bridge=vmbr0
ostype: wxp
sockets: 1

HP ProLiant ML115 G1 ( 2 x Dual-Core AMD Opteron 1210) Losser ? (but with Proxmox v1.9 work ! )
​Hardware Details in html: https://docs.google.com/open?id=0B_miX3U-7HAlUnpHMVNEV3VUSy11YlN4UHRuTE1LUQ


FILE: 101.conf

bootdisk: ide0
cores: 1
ide0: local:101/vm-101-disk-1.vmdk
ide1: local:101/vm-101-disk-2.vmdk
ide2: local:101/vm-101-disk-3.vmdk
ide3: none,media=cdrom
memory: 512
name: Svrtunning
net0: virtio=92:5F:E0:F64:48,bridge=vmbr0
ostype: wxp
sockets: 1

VM 100 = Windows Server 2003 with DNS - Active Directory
VM 101 = Windows Server 2003 with MS SQL 2000 and Enterprise Manager (3 Disk ( 1 for windows os, 2 Sql Data, 3 BackUP and app))

 

[djlaauol]

I hear more suggestions

 

[udo]

I hear more suggestions

Hi,
and what's about the IO-performance?
Is the non-running raw-disk an copy from the original-server or from the running raw-disk?

Udo

 

[djlaauol]

Hi,
and what's about the IO-performance?
Is the non-running raw-disk an copy from the original-server or from the running raw-disk?

Udo

Hi Udo.

The physical server using vmware migrate convert it which I target the copies to an external disk format. Vmdk ... you copy those files into the VM in your folder.

You also tried to make copies using qemu convert raw included within theProxmox.

The performance does not vary between raw and supporting vmdk far I tested for hours sitting in front of computers, copying GBs and GBs, I could not find a logicalanswer, ergo, no longer know what to say, if then you should buy a server largerdesktop pC or a game server to make it ...


------------------------------------------------------------------------------
Hola Udo.

El servidor fisico lo migre utilizando vmware convert el cual me destino las copias a un disco externo en formato .vmdk ... esos archivos los copie dentro de la VM en su carpeta correspondiente.

Ademas tambien probe convertir las copias a raw utilizando qemu convert incluido dentro del mismo proxmox.

El rendimiento no varia de forma justificativa entre raw y vmdk hasta donde hice pruebas horas y horas sentado frente al computador, copiando GBs y GBs, no he podido encontrar una respuesta logica, ergo, ya no sabria que decir, si entonces deberia comprar un servidor mas grande o una pc desktop game para hacerla server ...

 

[udo]

HiUdo.

Thephysicalserverusingvmwaremigrateconvertitwhich Itargetthe copies toan external diskformat. Vmdk...you copythose filesinto theVM in yourfolder.

Youalso triedtomakecopiesusingqemuconvertrawincludedwithin theProxmox.

The performancedoes not varybetweenrawandsupportingvmdkfarI testedfor hourssittingin front of computers, copyingGBsandGBs, I could notfind alogicalanswer, ergo, no longerknow what to say, ifthen you shouldbuy a serverlargerdesktoppCor agameserverto make it...


...

Hi,
sorry I don't understand the part of the vm-disk.
Simple question: are the raw-disks on all pve-systems the same?

One thing to test - can you tried to use virtio instead of ide? (change in the config "ide2:" to "virtio0", start the VM and use the driver from http://alt.fedoraproject.org/pub/alt/virtio-win/latest/images/bin/ as mounted cd-rom; shutdown VM, change ide0 to virtio0 and the others to virtio1 and virtio2, start vm and use the driver again).

Udo

 

[djlaauol]

Hi,
sorry I don't understand the part of the vm-disk.
Simple question: are the raw-disks on all pve-systems the same?

One thing to test - can you tried to use virtio instead of ide? (change in the config "ide2:" to "virtio0", start the VM and use the driver from http://alt.fedoraproject.org/pub/alt/virtio-win/latest/images/bin/ as mounted cd-rom; shutdown VM, change ide0 to virtio0 and the others to virtio1 and virtio2, start vm and use the driver again).

Udo

Ok, gracias Udo. voy a probar esa idea tuya. Luego te comento los resultados

----------------------------------------------------------------------

thanksUdo.I willtry thatidea of ​​yours.ThenI mentionthe results

all virtual machine, i use disk vmdk

 

[djlaauol]

Hi Udo.

Te comento que no funciono. Utilice controlador virtio con los discos vmdk ahora solo me resta probar en raw, pero no creo que sirva de mucho, ya que solo mejoro en la velocidad por lo que alcance a ver, pero no funciona el Enterprise Manager en los servidores HP.

-----------------------------


I commented that it did not work. Use virtio driver with vmdk disks now onlyremains for me to try on raw, but I do not gain much, since only improved in speedas it reaches to, but does not the Enterprise Manager on HP servers.

 

[djlaauol]

I hear more suggestions?