The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
1answer
76 views

Storing Tlogs and data files on the same drive

I'm looking for some clarification of various things I've read. I understand it to be best practice to store your transaction logs on a separate drive (spindle) than where you MDFs and NDFs are ...
0
votes
0answers
43 views

SQL Server Physical Vs Virtual? [duplicate]

Like to know thoughts or recommendation on Below. We have SQL Server 2008 R2 set up as a physical clustered environment. Management planning to go for Virtualization. what are the things to be ...
3
votes
5answers
152 views

Does DBA need (a read) access to virtualization infrastructure? And why?

I am in charge of monitoring, troubleshooting, tuning and optimizing a few dozens production SQL Servers 2008 R2/2012 in my company that are being run inside VMWare virtual machines. I've requested ...
3
votes
3answers
107 views

Is it possible to setup failover clustering between a 32 bit instance and a 64 bit instance?

I am attempting to setup a couple of virtual machines in my lab for testing failover clustering on SQL Server 2008 and Windows Server 2008. One of the hosts I have is not capable of running a 64 bit ...
1
vote
2answers
136 views

Is database partitioning for performance reasons meaningful in virtualized environment? [closed]

When running SQL Server on real hardware partitioning database and placing different partitions with different tables on different hard drives can be beneficial for query performance. Or, to simplify ...
0
votes
1answer
22 views

How is a composite database different from an ESB in that both provide a single point of access for multiple data sources

After reading this article on composite db software here it seems to me that the composite db software is not exactly a databse store like Oracle which physically stores the data. It is more like a ...
0
votes
0answers
165 views

Named Pipes Provider error across VMs in Hyper-V environment

I recently moved my site from a Windows Server 2003 single server, single instance configuration (web and DB on same instance) to a Windows Server 2012 Hyper-V host + web VM + DB VM environment (both ...
1
vote
2answers
629 views

SQL Server: Additional cpus slow down batch

I'm running SQL Server 2012 in Windows 2008R2 in a virtualized environment. I've observed the following under both VMware Workstation 9 and Hyper-V 2012R1 and I don't know how to address it. I've ...
1
vote
0answers
197 views

SQLPlus times out when connecting to an Oracle XE database on another PC

I'm having the strangest issue. I have a very basic (I think) setup of an Oracle 11G database on one Hyper-V VM, and the Oracle 11G client on another VM. Although I'm able to access the database on ...
3
votes
1answer
63 views

CPU column 5x higher on one machine vs another?

We're running into a strange issue in a deployed version of our product where the performance is just not very good. When we restore a backup of their DB on one of our machines, it performs as we ...
4
votes
2answers
251 views

Total Memory capped far below available memory

We are testing out a new install of SQL Server 2012 on a virtual server and the memory allocated to SQL Server seems to be capped around 16 GB even though much more is available. What could cause ...
-3
votes
1answer
71 views

Are database servers less scalable than web servers? [closed]

Isn't it possible to scale database servers through virtualization, like forever? I like to keep most of the workload on database server because it optimizes queries and the architecture decreases the ...
1
vote
1answer
265 views

Automatic MySQL Sync from master, where Slave was offline for long period of time

Does anyone here know if there are any tools, not using mysql's built in replication that will sync up two databases when the slave has been inaccessible from the internet for extended periods of ...
3
votes
1answer
386 views

Slow SQL Server query using a DB2 linked server in virtual environment

I have a problem with a slow query which uses a linked server. Let me list out my environment first and I'll get to the issue: Virtual Windows 2003 R2 server (fresh deployments on XenServer 6.1 ...
4
votes
2answers
607 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 ...
2
votes
1answer
312 views

SQL Server 2005 Express in VMware causing very high CPU load

I'm having the problems described in KB937745 - very high CPU usage and the Application Log is reporting something like this: The client was unable to reuse a session with SPID SPID, which had been ...
4
votes
5answers
391 views

Improving SQL Server performance on VMware under Linux

I have a Linux server in a small company (3 users) acting as a domain server and running two VMs under VMware: one has SQL Server 2000 on it and one has SQL Server 2005, in each case running on ...