The hardware tag has no wiki summary.
9
votes
1answer
268 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 ...
8
votes
1answer
158 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 ...
7
votes
6answers
529 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 ...
7
votes
3answers
246 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 ...
4
votes
2answers
399 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:
...
3
votes
2answers
387 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 ...
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 ...
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 ...
2
votes
2answers
88 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 ...
2
votes
1answer
257 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
vote
1answer
534 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
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 ...
1
vote
1answer
42 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 ...
1
vote
1answer
583 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 ...
0
votes
3answers
200 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
1answer
130 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. ...
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 ...
-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 ...
-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 ...
