0
votes
1answer
176 views

Can sql server scalable shared databases work with a vmware (ESX server) shared disc?

I've recently found out about sql server scalable shared database technology and I'd like to test it out in a vmware environment. Our production environment is SAN based but we don't have a test ...
0
votes
1answer
296 views

Installing SQL Server on a VM (ESX) on a SAN

I've got a an ESX VM and the storage is provided by a decent SAN. On a physical server, I would ordinary install SQL Server across 3 drives; one for the OS + SQL, one for data, and a third for log ...
0
votes
1answer
902 views

How to upgrade from Virtual Center 2.5 + SQL Server 2000 to vCenter 4.1 + SQL Server 2008 (R2)?

I'm planning the upgrade of an existing VMware Infrastructure 3 (Virtual Center 2.5 + ESX 3.5) to vSphere 4.1, and I'm stuck at upgrading the Virtual Center server and its back-end database. vSphere ...
1
vote
3answers
993 views

Poor IO performance on SQL Servers in VMs

I have a small VM ESX 3.0 implementation - mostly test web servers, however there is 1 db server that gets terrible io performance. Will adding additional virtualized disks in a RAID help ...
2
votes
2answers
469 views

How much memory to allocate to sql server

I have SQL Server inside an ESX VM... the server has 32GB Ram. Right now, I've given it 4GB of Ram because I had some to spare. How do I know how much memory I should throw at SQL Server (since it ...
1
vote
3answers
1k views

SQL Server performance on VSphere 4.0

We are having a performance issue that we cannot explain with our VMWare environment and I am hoping someone here may be able to help. We have a web application that uses a databases backend. We have ...
0
votes
2answers
660 views

ADO 2.8, VMWare and SQL Server - sudden bulk dropped connections

We have an overworked server currently running a single SQL Server 2000 instance on physical hardware, and about 40 different apps interact with it on a daily basis. Last year, the RAID controller ...
5
votes
3answers
1k views

SQL server in VMware

Please provide your tips and best practices for virtualizing SQL Server in VMWare ESX I am interested in advanced configurations and settings. Please provide reasoning behind your recommendations ...