2
votes
1answer
85 views

Windows Server 2012 Hyper-V Rename - SQL DB Issues

I set up a Windows Server 2012 virtual machine exactly the way we want it. I shut down the instance, made a copy of the .vhdx virtual drive, then spun up a new VM and attached the copy of the drive. ...
1
vote
1answer
26 views

Lab 2012 Hyper-v migration from esxi

I need some clarity on the hyper-v virtualization strategy coming from ESXi 4.x. Purpose: A VM for Sql Server 2012 w/ SP1 A VM for Sql Server 2014 CPT1 Hardware: Poweredge T100 8GB RAM, 2 SSDs ...
-2
votes
2answers
320 views

Windows Server Configuration with Exchange, SQL Express and IIS [closed]

In our small office we are currently running a standalone tower server with WS 2008 R2, SQL Express and IIS. This server is going to be decommissioned and scrapped as its old and very noisy. We are ...
2
votes
2answers
147 views

Latency between IIS and SQL on same physical, two VMs

I have a single server (2x4 core CPUs, 32GB ram), that is a Windows Server 2012 Hyper V host, and it hosts two guest VMs (also Windows Server 2012 instances). One of them is a web server, the other is ...
0
votes
2answers
98 views

Why Virtualize? [closed]

I am looking at expanding the hardware behind our .NET web application from a single box running the Web Server and SQL Server to two separate units with the web server on one and SQL Server on the ...
0
votes
3answers
249 views

AMD processors VS Intel Processors in virtualization and SQL tasks [closed]

I need to buy a server. This machine will be used as a virtualization host, therefore it will have a lot of v-machines sitting there using its resources. One of those v-machines is a SQL Server that ...
5
votes
1answer
1k views

Should I Use the Default SQL Server 2012 Accounts or Make Specific Ones?

I'm installing the 180 day trial of SQL Server 2012 on a virtual machine with the intent of buying a license for it later on. From past experiences with installing SQL Server I would always make ...
2
votes
2answers
219 views

High Availability with 3 servers: To virtualise or not?

We're changing hosts for our SAAS app (IIS+MSSQL) and have an opportunity to redesign the infrastructure. Either stick with what we have (which works well) or virtualise with vSphere. Current: 2x ...
54
votes
7answers
5k views

What are the drawbacks of running a database inside a virtual machine? How do I overcome them? [closed]

Running anything inside a virtual machine will have some level of performance hit, but how much does it really impact the performance of a database system? I found this academic reference paper with ...
3
votes
1answer
93 views

Virtualization versus simple consolidation of a web infrastructure

After talking to a friend who works for a virtualization firm, I started to think whether it could be of benefit to my small company. Right now we have our IIS web server on one server, and our SQL ...
1
vote
3answers
386 views

MSSQL: separate dev and prod databases as separate instances on shared hardware?

I've got a small virtualised environment which hosts a small internal website with database backend. I've currently separated my webservers and database servers on separate VMs running on the same ...
1
vote
2answers
2k views

How to configure SQL Server access for guest OS?

What is the best way to configure a SQL Server on a host OS so that a guest OS can access it but it is not available outside the host OS? I am using VirtualBox to host the guest OS.
0
votes
3answers
1k views

Connecting to SQL Server on Parallels Desktop with PHP

well I recently bought a Mac and am using it as my primary computer. Because I am required to work with MSSQL via PHP, I have installed Parallels Desktop and run Server 2008 R2 on it. I am using the ...
5
votes
3answers
1k views

Certain SQL queries performing very poorly in ESXI hosted environment

We recently set up a new machine with 8 dual-core CPUs, 20 GB RAM, and 3 1-TB drives set up in a RAID of some sort resulting in 2 1-TB drives we actually get to use (I'm not the hardware guy here). ...
2
votes
2answers
1k views

MS SQL Server: multiple databases on one or more VMs?

We are planning to deploy an eCommerce Solution using three distinct databases, all to be hosted in MS SQL Server 2008 R2. The whole stack will be hosted in a VMWare environment (two physical machines ...
1
vote
0answers
211 views

DOS path not resolving in VM

As a developer, I had our systems team setup a VM of a server to practice an upgrade of an old third party application. This server has its own instance of SQL Server 2000 that's used exclusively for ...
0
votes
1answer
128 views

Demo a database mirroring on SQL Server, which choice is the best?

I'm going to demo a high-availability SQL Server database to my mentor. My current PC configurations are: Pentium E6300 2G of RAM Windows 7 Ultimate I planned to create 3 virtual machines by ...
1
vote
2answers
219 views

Virtual PC doesnot meet SQL Server 2005 enterprise's hardware requirements?

I used Virtual PC to create a virtual machine with configuration: CPU: Intel Pentium E6300 2.8Ghz overclocked to 3.66Ghz (which supports VT technology) RAM: 600MB I thought it was enough for me to ...
4
votes
4answers
6k views

Optimising MSSQL 2008 server inside VMWare ESXi

I normally run my MSSQL servers on dedicated servers, but we've taken on a client who is running their SQL Server inside a VMWare ESXi 4 host, and quite frankly it's running like crap. We have ...
1
vote
2answers
706 views

SQL Server wont start on my 64-bit virtualization slice

I have installed SQL server 2008 express on a 64-bit virtual box and the service wont start. Looking at the event log I get: Could not create tempdb. You may not have enough disk space ...
2
votes
4answers
104 views

Virtualizing Microsoft SQL Server for developer server

I'm currently setting up an environment for our developers and I am faced with a problem. We're planning on having Crowd, JIRA, Confluence, Bamboo, etc (all by Atlassian; all running on Windows Server ...
2
votes
6answers
436 views

To virtualize, or not to virtualize

Disclaimer: I'm a developer and I know very little about setting up servers, but in small shops, responsibilities tend to bleed over. We've just got a new server to run SQL Server on, and we're ...
1
vote
4answers
606 views

SQL Server DR Strategies with virtualisation & multi sites

I'm looking for advice on the best HA/DR strategies for SQL Server. Currently I'm using Express edition with backups being copied over a the WAN to a remote site and being restored. The SQL Express ...
5
votes
1answer
596 views

Virtual vs. Named SQL Instances

What are the benefits to using virtual as opposed to running multiple instances of SQL on a box?
3
votes
7answers
6k views

SQL Server Slow but CPU Normal

We're having some trouble with SQL Server hosted on a virtual server. We occasionally have short periods where even performing a simple select takes minutes. During this period the CPU and memory ...
0
votes
3answers
194 views

MSSQL 2000 + VMWare

I have an MSSQL 2000 instance installed and running on VMWare (not my choice, but mandated to me) ... It's been running fine because I've cut my teeth a few times performance tuning it. This sql ...
3
votes
3answers
6k views

How does the LeftHand SAN perform in a Production environment?

I previously asked this ServerFault question: Does anyone have experience with lefthands VSA SAN The general consensus looks like it does not perform well enough for a production SQL server even at ...
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 ...