Questions tagged [ssd]

The tag has no usage guidance.

0
votes
1answer
43 views

Flash storage and auto-grow

Our databases files (data and log) of (a lot of) SQL Servers are hosted on flash storage (SAN), what would you use as auto-grow property for databases having size round 500GB (data) and 150Gb (log)? ...
0
votes
1answer
94 views

Should TempDB SSD Drive be formatted with 64 Kb Allocation Unit Size?

We have installed dedicated SSD drives for TempDB First question - should these drives be formatted with 64 Kb allocation size ? Currently it shows 4 Kb (Bytes per Cluster = 4096) Does TempDB ...
0
votes
2answers
114 views

What kind of SSD to speed up querying a lot of data?

For research purposes I am using a big MariaDB database (~500 GB) with 20 Tables (engine: myISAM) and around 9 Billion rows. Due to missing free storage on my Laptop (16 GB RAM), I put the data on an ...
0
votes
2answers
163 views

Raid 1 or Raid 1+0 for SQL Server Architecture

We are looking at new servers. Today our SQL Servers are built as follows: C/D on RAID 1 , E : Tempdb on RAID 1, F:log files on RAID 1 , G : Catalog data on RAID 1 , H: model data on RAID 1 , ...
1
vote
1answer
75 views

Performance of mysql equi-join observed in HDD and SSD

I experimented performance of queries having equi-joins. I have simplified version of EXPLAINs of the queries. Mysql version : 5.7.18 Engine : Innodb Cache state : Mysql restarted before experiment ...
1
vote
2answers
25 views

mysql - calculate traffic for tmp tables

I'm thinking of placing tmpdir to SSD - to increase speed of working with sorting data in tmp tables on disk. Our base creates a lot temporary tables on disk during sorting, merging, joining an so on. ...
1
vote
3answers
230 views

InnoDB “holes” in large table 200 Million Rows?

I have a large MySql InnoDB table with about 200 million rows. One of the columns has some data in it that I really don't need any more, so I'm thinking about removing that column, or setting all the ...
0
votes
1answer
117 views

Does the Mysql install location affect write speeds?

Up until lately, I used a 32 bit version of Mysql 5.7, bundled with a WAMP server (EasyPHP) on Windows for local development, all running on an SSD. I ran into database size issues, and had to upgrade ...
6
votes
1answer
3k views

Autodetect ‘random_page_cost’ vs ‘seq_page_cost’

I read this article about PostgreSQL performance on SSD: https://amplitude.engineering/how-a-single-postgresql-config-change-improved-slow-query-performance-by-50x-85593b8991b0 These two ...
1
vote
2answers
994 views

SQL Server on ssd seems slow

We recently moved SQL Server to SSD and the performance gain is not that great. SQLIO shows enormous gains (15-100 times faster), getting sequential read/write speed up to 6GB/s. But when we do a ...
1
vote
0answers
493 views

why SSD is slower than HDD SAS 15K on DBMS PostgreSQL?

Someone help me analyze the two execution plans below (Explain ANALYZE used), is the query 9 of TPC-H benchmark. I'm using two servers HP Intel Xeon 2.8GHz/4-core - Memory 8GB. O.S. Debian8, using ...
1
vote
0answers
410 views

SQL TempDB PCI-E NVMe card - 4K or 64K

Our primary OLTP workload is tempdb heavy (both reads & writes) based on virtual_file_stats DMV, and based on SPs all of which heavily use #tmp tables. The server has 400GB of memory, more than ...
0
votes
1answer
465 views

Does SSD drive make indexes rebuild and update stats useless with SQL Server?

Now that SSD is a standard de-facto. Can the maintenance job of rebuilding indexes and updating statistics, using Ola Hallengren https://ola.hallengren.com/ jobs for instance, be done only on demand ...
1
vote
0answers
99 views

Splitting Filegroups on a single SSD LUN

I've got an 8vcpu Hyperconverged 2008R2 Standard SQL Server with many TBs of data split across 4 Spindle LUNS. Each database has its Filegroups split into 4 physical files. I'm being given a 1TB SSD ...
3
votes
3answers
304 views

Configuring physical storage for a Microsoft SQL Server installation

I'm configuring a Microsoft SQL Server installation which will use a SAN for storage. For SAN storage I have: A small number of SSD disks A larger number of 10K disks My SAN supports storage ...
-2
votes
1answer
52 views
0
votes
0answers
885 views

Postgres performance is constant after upgrading to an ssd with 5x more write iops (included fio results)

Recently we upgraded from a 480GB Intel 530 SSD to a 1TB 750 NVMe SSD and despite good benchmarks are experiencing no improvement in write performance. Using Python to insert a 27 column, 1,000,000 ...
1
vote
1answer
238 views

NVMe+bcache as huge storage cache for vertica database

We are in process of selecting hardware for 3 machines vertica cluster capable to serve 20-30TB of data (15TB compressed). This translates to 8TB of post-RAID storage. With 16 CPU cores, the storage ...
2
votes
1answer
142 views

SQL server Installation

I have received a new server. The server has the following specification. It has 500 gig 7.2K RPM disk, SSD NVME 1.2 TB 10K RPM disk. All are in RAID 1. I am planning to install Windows Sever on ...
28
votes
4answers
6k views

Do SSDs reduce the usefulness of Databases

I only heard about Robert Martin today, and it seems like he's a notable figure in the software world, so I don't mean for my title to appear as if it's a click bait or me putting words in his mouth, ...
3
votes
2answers
2k views

SSDs and 64K sectors

SSDs tend to have a natural 4K sector size as far as I know, but would it be beneficial to format Windows cluster size at 64K? This is good practice for spinning rust, but is it relevant on SSDs?
1
vote
3answers
1k views

Does innodb_flush_log_at_trx_commit = 1 wear out SSDs more than innodb_flush_log_at_trx_commit = 2?

I am running a Nextcloud instance and I suffer from a slow sync when a lot of small files are synchronized. I found out that innodb_flush_log_at_trx_commit = 1 is responsible for this so I was forced ...
2
votes
3answers
213 views

Is it normal for disk activity to disturb MySQL performance?

I'm running MySQL 5.5 on a server with two SSDs in software RAID-1 configuration. The filesystem is ext4. When any process (external to MySQL) produces a large amount of disk IO on the server, I find ...
2
votes
2answers
205 views

CrystalDiskMark Test Discovers Lopsided Throughput; What Setting Should be Changed?

I'm running time trials on a new Windows 2012 Server host with PureStorage FlashArray SSD LUNs attached. I conduct an initial test with CrystalDiskMark and discover write performance is substantially ...
0
votes
1answer
157 views

MDF, LDF, TempDb Location on same Hybrid SAN

I have seen this question asked before regarding SSDs or SANs, but never a Hybrid SAN. Also, most of the questions are several years old, so I figured I'd get a fall 2016 take on the answer. We ...
0
votes
1answer
185 views

intel p3600 SSD no increase in read speed - postgres rdbms vs hdd

We run a custom application that produces analyzable data-sets for medical research. the amount of data we have is about 600GB in form 3Billion rows distributed in 600+ tables it is hosted in ...
11
votes
2answers
1k views

Moving SQL Server database to a new disk while online

I have a 1.4TB SQL Server Database that's struggling massively with disk I/O. We've installed a new SSD array into the server that will solve all of our problems, we're just debating the best way to ...
6
votes
4answers
2k views

Mysql (percona-server 5.5) completely stalls during import (myloader)

While configuring our new servers (IBM X3650M4, 2x Intel Xeon E5-2620, 64G RAM, RAID 10 (4x 240G SSD)) we bumped into a strange problem. We're trying to import dumps (mydumper) from our (old) ...
0
votes
1answer
48 views

Record scan speed, column orientated databases and SSDs

I'm learning about column orientated databases. I have just watched a YouTube video on column orientated databases by Arnaldo from MIT, who suggests an interesting motivation for column orientated ...
1
vote
1answer
124 views

How to get postgres to resume processes after it hangs when the RAID drive hosting the tablespace times out

Nearly once per day I'm getting a timeout that shows up in console like: 7:1:36 PM kernel: Areca RAID volume scsi command timeout (target=0 lun=0) which corresponds exactly to when all postgres ...
1
vote
0answers
271 views

mysqld stops right after starting because of corrupted tables (disk full + hardware reboot) - how to fix it?

I'm dumb, I did the stupidest thing I could. On one of my servers, the SSD was full and I wasn't aware of it. The high-traffic website became working really slow, then started displaying errors, ...
1
vote
1answer
94 views

SQL Server : multiple databases with transaction log on one SSD array

I know for HDD arrays that having multiple log files from different databases has a performance hit as it changes the IO pattern from sequential to random for the array. So having an array per ...
5
votes
2answers
330 views

Shrink or no Shrink dilemma

I have databases that I am tasked to move two databases DBName1 and DBName2 to SSD and I only have limited space on the SSD to fit these databases.I do not want to shrink log or data files for the ...
1
vote
2answers
562 views

Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck

We are upgrading hardware for a MySQL database server (DB is around 200GB). We're getting 4x Samsung 850 Pro SSDs and are planning to run them in a RAID10 configuration. Also, 128GB of RAM. The ...
1
vote
1answer
266 views

Postgresql two tablespaces one on SSD and one on SATA III HD

Continuing my previous question PostgreSQL maximize performance SSD the DBA SE community has given me efficient advice on optimal settings for PostgreSQL on SSD. The problem is that I will define two ...
2
votes
1answer
805 views

Upgrading to new cPanel Server with mySQL on SSD — What should I change in my.cnf?

I'm upgrading to a faster server with whm/cpanel and the mysql databases will be on a SSD. I've read a bit about not wanting any query cache and stuff like that, but as a novice, I've learned that ...
2
votes
1answer
175 views

Wordpress blog where pages are almost-always served from cache: SSD or more RAM?

I am working on the design of a Wordpress blog which when finished will almost-always serve pages from disk cache and this is because all posts will be published in batch and then cached, with at ...
2
votes
2answers
1k views

Where to place tempdb and logfiles

I have fallowing configuration for my SQL 2014 server: SSD RAID 1 - for data files SSD RAID 1 - for tempdb? logfiles? HDD (SAS 15K) RAID 1 - for tempdb? logfiles? I noticed that sql uses tempdb ...
5
votes
1answer
1k views

SQL Server 2012 Local SSD TempDB Slow

I have a production deployment using local SSDs for tempDB. I have 2 SSDs in a RAID1 configuration. I am seeing average reads of 1-2ms but the average writes are showing as 1377ms on all four of my ...
6
votes
2answers
1k views

Major Discrepancy Between SQLIO IOPS/Throughput Stats and DBCC CHECKDB Operations

I'm conducting time trials on a new SSD array running both SQLIO tests and a real-world workload of DB restores and DBCC CHECKDB calls. I'm seeing a major discrepancy between the IOPS and throughput ...
0
votes
1answer
1k views

Sybase9, not using full system capacity

The SSD I/O capacity is around 450MB. When I copy files from one folder to another I can see in the Windows Resource Monitor that the sum of read/write speed gets around 450MB. Why the same wont ...
1
vote
1answer
2k views

SQL Server Express 2008: Can I store database files (.mdf, .ldf) in directory other than the default DATA directory?

I have a SQL Server Express 2008 instance of which I am attaching databases from development systems quite often. Typically I transfer the .MDF and .LDF files to the instance's DATA folder and ...
41
votes
6answers
72k views

SSD vs HDD for databases

I am trying to purchase a new Server to run MySQL Server on. This new server will be a slave of my main machine. However, this server will be dedicated for reporting only "Lots of reads and complex ...
4
votes
2answers
5k views

MySQL on SSD - what are the disadvantages? [closed]

Recently, I heard that I should not host my MySQL database on an SSD drive because there is a big chance of disk failure and data lost. Given that 20% of all queries in my database are INSERTs and ...