PSS SQL Server Engineers

Wednesday, November 12, 2008 5:31 PM

How It Works: SQLIOSim - Running Average, Target Duration, Discarded Buffers ...

The following is from a lengthy conversation I had with Kevin Kline. I believe he will be posting more details along with his "Understanding SQLIOSim Output - http://sqlblog.com/blogs/kevin_kline/archive/2007/06/28/understanding-sqliosim-output.aspx

Posted by psssql | 3 Comments

Filed under: SQLOS, Tools, How It Works

Wednesday, March 05, 2008 4:51 PM

How It Works: SQLIOSim - Checksums

SQLIOSim, like its predecessor SQLIOStress, is designed to read pages it has written and validate the data. SQLIOSim does this using a checksum algorithm. When SQLIOSim starts up it creates a set of buffers and used the Cryto APIs to generate

Posted by psssql | 1 Comments

Filed under: SQLOS, Engine, Tools, How It Works

Monday, January 14, 2008 7:19 PM

SQLIOSim - Error Request Could Not Be Performed - Unable to get disk cache info

Both SQLIOSim and SQLIOStress use DeviceIOControl to determine information about the target. On disk caches are typically not battery backed and when enabled can lead to data loss during a power outage. The utilities attempt to warn the user

Posted by psssql | 1 Comments

Filed under: SQLOS, Engine, Tools

PSS SQL Server Engineers

This Blog

Syndication

Search

Tags

Archives

Browse by Tags

How It Works: SQLIOSim - Running Average, Target Duration, Discarded Buffers ...

How It Works: SQLIOSim - Checksums

SQLIOSim - Error Request Could Not Be Performed - Unable to get disk cache info