SQL Server SSD vs HDD performance -


so i'm doing performance comparison between ssd , hdd sql server insert statements.

i'm inserting 2,000 columns worth of data across 4 different tables.

for each record insert 1 row in each table.

i tested on 1 machine ssd main hard drive running sql server process , database file on secondary hdd drive.

i tested on machine ssd drive has both sql server process , actual db file.

i have expected machine database field on hdd slower machine on ssd.

is behavior i'm seeing expected? if why?


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -