The hardware tag has no wiki summary.
-3
votes
1answer
56 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
43 views
SQL Server 2012 Availability group disk configuration options
Background
I am quite far into the process of setting up a 2 server SQL Server 2012 Always on availability cluster to provide redundancy with a readable secondary replica of all our databases.
Since ...
7
votes
6answers
540 views
Optimal drive configuration for SQL Server 2008R2
I have a fairly busy database server running SQL Server 2008 R2 that has the following setup:
SATA RAID 1 (2 Drives) - OS / Programs
SAS RAID 10 (4 Drives) - Sql Database Files (data and logs)
SAS ...
8
votes
1answer
159 views
Strategies for organising SQL Server with large amount of RAM
We now have a new server for our DB and amongst other things we have 128GB of RAM available (previously I had 16GB) . I know SQL Server is very good at managing it's resources, but I was wondering if ...
3
votes
0answers
73 views
What utilities can I use to simulate I/O load for a DB restore and DBCC check?
I'm trying to figure out the peak load I can sustain on new hardware I procured for validating backups and performing DBCC checks. I've been using Crystal Diskmark to get throughput stats which helped ...
3
votes
2answers
396 views
SAN block size for SQL Server on 4KB NTFS
A potential customer wants to evaluate our storage system. They run Windows 2008R2 x64 with 4KB NTFS on a virtual test machine they've sent us. They did not seem to know this at hand, so I think it's ...
0
votes
1answer
132 views
consequences of using “innodb_flush_method = O_DIRECT” without having a battery backed write cache? or on a KVM guest?
Mysql 5.5.29 Innodb- 128GB Ram - 32 cores - Raid 10 SSD.
Our server which is a dedicated KVM guest on a 'baremetal' is hosting our heavy read-write DB server.
Everything is file-per-table. ...
9
votes
1answer
269 views
Why don't SQL Server queries use more than 7MB/sec of disk I/O
I have an SSD that, using IOmeter test, shows performance over 200MB/s. However when I run any SQL query from local machine the windows resource monitor never shows disk IO above 7MB/sec. This holds ...
2
votes
1answer
260 views
SQL Server recommended MAXDOP settings for NUMA
I have an OLTP SQL Database running on SQL 2008 R2 Enterprise Edition that may be fairly busy (5000 batches/sec) in next couple of months after going live production. Looking into server configuration ...
-1
votes
1answer
107 views
Is 2.23 mbs/sec for 8k random writes slow? [closed]
I have recently ran some hard drive benchmarks on one of my servers follow Brent Ozar's blog. For the random writes test, i got 86.52 ios/sec and 2.23mbs/sec. I am not a hardware person, and my sys ...
2
votes
2answers
90 views
Required hardware to build a development environment in Sql Server
We have a bunch of applications that depends on about 10 different databases servers (all sql server) in our network.
We are looking to build a development environment where we could have a mirror of ...
1
vote
1answer
550 views
What are the most compelling reasons to upgrade from SQL Server 2005 to SQL Server 2012?
We currently have 2 SQL Server 2005 Enterprise machines in a mirrored environment running on Dell R815 servers. These machines consist of:
Four AMD Opteron 6176 Processors (12 cores at 2.3Ghz), for ...
1
vote
1answer
586 views
Optimizing MySQL for Read-Only?
We have 14 GB worth of CSV's which total 138 million rows. I imported this into a MySQL table first with InnoDB, and then tried again with MyISAM. In both cases, a simple SELECT on primary key ...
4
votes
2answers
400 views
Should we need to use Barriers on a production database (MySQL/InnoDB)?
Even though we are using a journaling filesystem (EXT3) with barrier enabled, is this still safer and recommended?
e.g
mount -o barrier=1 /dev/sda /mntpnt
Reference:
...
1
vote
1answer
139 views
Hard Drive Configuration for my setup
I have a fairly large transactional database (100GB) with a lot of users. The database access is solely via stored procs that make heavy use of temp tables, table variables, cursors and other fun ...
0
votes
3answers
201 views
Custom SQL Server Computer Build
I hope this is the right place to ask this question. I'm a user at StackOverflow, and when I perused the StackExchange websites, this was the best match I could find. So, if I've posted in the wrong ...
0
votes
0answers
30 views
Getting info on hard disk [closed]
Apologies if this question is too simple for gurus.
For a windows box with a given hard drive, I wish to determine:
The max disk i/o, the hard disk is capable of
The number of platters in the hard ...
2
votes
2answers
99 views
Is this Dedicated Server good enough to Run MySQL on Linux Ubuntu?
I have a web application that runs simple logic. Most of the SQL procedures that I have
only do simple selects, some simple join table and some simple inserts. I want to get
a dedicated server for My ...
7
votes
3answers
247 views
Is there a performance benefit to placing transaction log files on a separate drive?
There are many blog posts and best practice articles extolling the virtues of placing the SQL Server data file on one hard drive and the transaction log on another. The reason given is that that the ...
