Sr Database Administrator

Jim Youmans

<div>
What is it you are trying to prove? that your disks are under performing, or that your config is not optimal?<br />
<br />
What does your disk config look like? are you using Spining Rust or SSD's?
</div>


What is it you are trying to prove? that your disks are under performing, or that your config is not optimal?

What does your disk config look like? are you using Spining Rust or SSD's?

<div>
<div class="content wysiwyg-content">
I am trying to use Diskspd to check the IO on my SQL Server 2012 server running Windows Server 2012 R2. &nbsp;It is set up to have the data files on the E: drive and the log files on the F: drive. &nbsp;What I don't understand is how to make it check a given disk. &nbsp;Does it automatically check SQL to see what drives SQL uses or does it just run on the drive from where it is located? &nbsp;I looked at the documentation but don't see that mentioned. &nbsp;Anyone know the answer? &nbsp;Thank you<br />
<br />
Jim
</div>
</div>


I am trying to use Diskspd to check the IO on my SQL Server 2012 server running Windows Server 2012 R2.  It is set up to have the data files on the E: drive and the log files on the F: drive.  What I don't understand is how to make it check a given disk.  Does it automatically check SQL to see what drives SQL uses or does it just run on the drive from where it is located?  I looked at the documentation but don't see that mentioned.  Anyone know the answer?  Thank you

Jim

How to use Diskspd IO tester

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.