If, before deployment, you need to push the limits of your disk subsystem in order to determine whether the hardware’s I/O capacity meets the needs of a database application, if you need performance baselines, or if you want to identify any performance-related issues, then why not use the sqlio utility?
2014-02-13
6,077 reads
The sqliosim utility is provided with SQL Server to test the I/O stability and 'correctness' of a server. It is generally used before installing SQL Server in order to ensure that new hardware can handle your expected loads. Bob Sheldon explains what it is and how to use it.
2014-01-24
3,493 reads
Learn how to use Analysis Services Data Mining to identify the influence of RAID level and IO Pattern on Latency.
2013-03-26
3,105 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
Comments posted to this topic are about the item SQL Art, Part 2: New...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers