Month: October 2012

Re-visiting SQLIO SSD Disk Performance Tests

Below are test results from re-running SQLIO tests on a laptop workstation used primariyl for Microsoft SQL Server 2008 R2/2012

SQLIO is a tool provided by Microsoft which can also be used to determine the I/O capacity of a given configuration.   Click here for the software. Test configurations were based on Brent Ozars article on finding SAN bottlenecks. Click here for the article.

Test was run with a 1Gb test file.

Results:

Write/Random:

CUMULATIVE DATA:
throughput metrics:
IOs/sec: 27918.74
MBs/sec: 218.11
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 1
Max_Latency(ms): 1573
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 1 36 57 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Read/Random

CUMULATIVE DATA:
throughput metrics:
IOs/sec: 22417.17
MBs/sec: 175.13
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 65
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 1 17 44 28 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Write/Sequential:

CUMULATIVE DATA:
throughput metrics:
IOs/sec: 4079.34
MBs/sec: 254.95
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 15
Max_Latency(ms): 3949
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 99 0 0 0 0 0 0 0 0 0

Read/Sequential

CUMULATIVE DATA:
throughput metrics:
IOs/sec: 4266.00
MBs/sec: 266.62
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 14
Max_Latency(ms): 6629
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 0 0 0 0 0 0 0 0 0 0 0 1 2 1 57 40 0 0 0 0 0 0 0 0 0

 

 

Security Update for SQL Server 2012 RTM (KB2716442)

Security Update for SQL Server 2012 RTM (KB2716442) :
“A security issue has been identified in the SQL Server 2012 RTM that could allow an attacker to compromise your system and gain control over it.”

This will update your SQL 2012 instance from version number 10.0.2100 to 11.0.2218 as shown below:

select @@VERSION

——output ——————————————————————————————- Microsoft SQL Server 2012 – 11.0.2218.0 (X64)
Jun 12 2012 13:05:25  Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

(1 row(s) affected)

Click here to download this important update.

SQLIO test – SSD vs. Non SSD on a laptop running Microsoft SQL Server

SQLIO Tests:

“SQLIO is a tool provided by Microsoft which can also be used to determine the I/O capacity of a given configuration.” Click here to down load the Disk subsystem benchmark application. Below is my test result on my laptop before and after l got a 240Gb Corsair Force 3 Solid State drive.

Before SSD:

After/with SSD:

WEI – Windows Exprerience Index jumped from 5.9 to 7.8 for disk performance.