The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
0answers
29 views

SQL server on VMWare restart loses five days of data

I am just now in the midst of a strange issue. A client moved their SQL database server from Hyper-V to VMWare on Saturday. Yesterday they called me complaining about performance. In the brief time ...
3
votes
0answers
42 views

Different Disk Drive Same Backend Storage

I have a database running on a VM which is getting hammered during a large load, in particular I can see waits of WRITELOG happening. My initial thought is to split the files out on to their own ...
5
votes
3answers
163 views

Virtualize SQL High CPU

This is a client environment which needs significant overhaul so all I am trying to do is slow the bleeding. Situation CPU is getting crushed, often 80% or higher utilization VMWARE 5.5, Windows ...
1
vote
0answers
31 views

SQL Server Performance in VMWare when creating different drives from a single Datastore [closed]

On VMWare if you are going to create a new SQL Server instance with 4 processors / 32GB ram as an example GuestOS and I have access to storage that is just one a big giant 800GB "Datastore" (made up ...
1
vote
1answer
32 views

Virtualized SQL Server Memory Oddity

I've not seen this before, though perhaps it is common. I am looking at a virtualized (VMWare 5.5) SQL Server (2008R2 on Windows 2008 R2). What I am seeing is that in Task Manager, sqlserver.exe is ...
1
vote
1answer
39 views

VMware and Oracle

VMware is supported by Oracle but not certified. That I get, but why does it matter anyway? Because support is the only thing matters and how will Oracle know that I'm on VMware? Either way, they will ...
9
votes
0answers
91 views

Why my database mirror break down after changing file group settings from RESTRICTED_USER to MULTI_USER?

My environment is the following: VMWare 5.5 vitalized server MS Windows Server 2008R2 Enterprise domain and SQL Server 2008 R2 Enterprise. Centralized storage with fibre-channel connection. I have ...
1
vote
1answer
59 views

Backup SQL Server with VMware

The VMs I run SQL Server on are regularly backed up by the VMware backup tool. I would prefer not to use this backup solution but I have no choice but to cope with it. The problem I've come up across ...
1
vote
1answer
63 views

SQL Server Failover Cluster Instance compatible with VMware HA?

Imaginary Setup: Microsoft SQL Server Failover Cluster Instance on virtual machine in an ESX-Cluster. Question: In case of a hardware failure, what will happen with both high availability ...
0
votes
1answer
64 views

sqlplus not connecting to Oracle XE 11g

I installed Oracle XE 11g on my Ubuntu in vmware fusion. The oracle installation is all went fine but I am not able to connect the oracle database using sqlplus. I am getting this exception: $ ...
3
votes
1answer
62 views

Backup of VM having SQL Server in it

I have SQL Server running on a virtual machine (VM). Weekly VM backup is done. My question is when we backup the VM, does it locks down the SQL Server or the databases residing in that SQL Server? I ...
0
votes
0answers
12 views

Configure Oracle DB to store backups on External Storage [closed]

How can we Configure Oracle DB to store backups on External Storage ? Oracle DB is a vm machine on ESXi Host Let me know if you need more details. Please advise.
4
votes
0answers
102 views

Find out why SQL Server released memory

I have a SQL Server 2008 R2 used for sharepoint and ssrs. The SQL Server hosts two instances. For a few minutes both instances were timing out, not responding. CPU slowly rose to 100%, 30% from ...
0
votes
1answer
54 views

How to connect to Oracle database on VM1 from host with 11gClient

I have a VM running Oracle Linux 6.5, I loaded Oracle server x64bit and created a database. The database functions fine and the listener is up and running for the database. I want to connect to the ...
2
votes
2answers
467 views

Are there benefits to using more than 4 CPUs for MySQL?

We are running MySQL 5.5 on linux under VMWare, running on 2 CPUs. We are planning on increasing this to 4, but we have un-used CPUs available, and I'm wondering if there is any benefit to increasing ...
1
vote
1answer
539 views

Connecting to a MySQL database on Mac from a VMWare fusion Virtual Machine

I have MariaDB (5.5.34-MariaDB) installed on a Mac (OS 10.8.5) I can connect to the database fine locally (127.0.0.1) on port 3306. But when I try to connect to the database from windows 7 64bit ...
0
votes
0answers
199 views

EMCA port Issue on Installing Oracle on Windows Server 2008 guested on VMware

I am trying to install Oracle 11gR2 on Windows Server 2008 guested on VMware Workstation 10 but I am getting this error on Enterprise Manager Configuration. I also tried to login to the database ...
0
votes
0answers
104 views

MySQL overtaking system memory and forced to restart

I'm facing a frustrating issue. I have a MySQL Server 5.5 running on top of Ubuntu Server 12.04.3 LTS (VMWare guest w/ 16GB RAM - 8 Cores) mysqltuner.pl says [OK] Maximum possible memory usage: ...
3
votes
2answers
3k views

SQL Server 2012 High Availability on VMware virtualization

We're going to host a large SQL Server 2012 under a VMware virtualization and we need it to be highly available. These are the three options I found supported, but couldn't find a lot of info and ...
0
votes
0answers
19 views

SQL Server 2012 High Availability on VMware virtualization [duplicate]

We're going to host a large SQL Server 2012 under a VMware virtualization and we need it to be highly available. These are the three options I found supported, but couldn't find a lot of info and ...
0
votes
1answer
3k views

SQL Server does not exist or access denied from a VMWare guest

I've made the configuration to allow remote connections to SQL Server 2012, however I still cannot connect to it from a VMware Workstation Guest (using both NAT and Bridge). I can ping the host ...
0
votes
1answer
329 views

File locations for Full Text Catalogs using SQL Server 2005 on VMware

I have an issue with one of our development SQL Server Servers. We have databases that use full text search catalogs. Just some background info, our servers are configured to use separate drives for ...
9
votes
3answers
1k views

Bulk insert into SQL Server from VMWare guest using distributed switch

This is mostly likely not a SQL server issue but the setup seems to only be affecting BULK INSERTS to SQL Servers. We have recently moved VM Hardware and all the guests that were moved had their ...
4
votes
1answer
722 views

SQL Server Buffer Pool Utilization under VMWare

I recently migrated a physical SQL Server box (2012) over to ESX (5.1) simply for ease of administration. It is and will be the only guest on the server. As expected there was a marginal performance ...
3
votes
1answer
304 views

Do my metrics justify changing the MAXDOP settings?

I recently took over a dual instance virtualized SQL Server with 8 x vCPUs and 8 x physical cores. This is the only VM on the host. MAXDOP is at the default setting. The server has 100 high ...
4
votes
2answers
1k views

SQL Server 2012 Licensing on a VMware Infrastructure [closed]

I am looking to license SQL Server 2012 Standard on my VMware Vsphere server farm. I currently have 3 hosts in the farm with the following spec: 2x 6core Xeon CPU (12 cores total) 128GB RAM ...
4
votes
2answers
1k views

Pros and Cons of virtualisation technology for database-server and datastorage

Yesterday we had a chat about performance and restorability and I realized how many good things a virtualisation environment can bring to me - but as I'm a little sceptic concerning performance I'm ...