Tags » I/Ops

Porting from SQLIO to DISKSPD: How to Test Disk Performance for SQL Server

DISKSPD TESTS

Original post related to SQLIO took from brentozar blog.

diskspd -w100 -t8 -d60 -o32 -r -b8K -Sh -L -c20G C:\test.dat
diskspd -w0 -t8 -d60 -o32 -r -b8K -Sh -L -c20G C:\test.dat
diskspd -w100 -t8 -d60 -o32 -si -b64K -Sh -L -c20G C:\test.dat
diskspd -w0 -t8 -d60 -o32 -si -b64K -Sh -L -c20G C:\test.dat
… 264 more words
Sql Server

StorageShort: The Problem With Splunk Storage Management

Of all the new applications on the market today, Splunk does make one of the best attempts to manage storage. It uses a bucket metaphor to make sure data is in the most performance and cost appropriate storage type. 86 more words

Flash

[Recommended Reading] IOPS

Source: IOPS Wikipedia

Input/output operations per second (IOPS, pronounced eye-ops) is a performance measurement used to characterize computer storage devices like hard disk drives (HDD), …

30 more words
Recommendations

Samsung SSD 960 Pro review: Raising the bar for SSDs

(Source: www.hardwarezone.com.sg)

Introduction

Note: This article was first published on 18th October 2016, but it’s now re-published in January 2017 as the product is now widely available in retailers. 955 more words

Technology

Splunk Storage Basics

Splunk is software for searching, monitoring and analyzing machine-generated data. While there is a lot of talk about “big data initiatives”, this is the big data that organizations have right now. 526 more words

Blog

Webinar: How To Design High Performance, Cost Effective Splunk Storage

Organizations have an analytics project right in front of them — log data created by the machines and systems they already have deployed. Analysis of this data can lead to better decisions, problem detection and tighter security. 125 more words

Flash