Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » How It Works » Tools   (RSS)
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: , ,
Thursday, September 18, 2008 10:35 PM

How it Works: SQL Command Mode Parsing

I ran across a teaser this week that makes for a interesting blog post.  SQL Server uses a common batch parser for the SQLCMD, OSQL, SSMS Query Window in Command mode and various other locations. The primary job of this parser is to identify GO delimited
Posted by psssql | 1 Comments
Filed under: ,
Tuesday, August 19, 2008 9:18 PM

How It Works: SQLIOSim [Audit Users] and .INI Control File Sections with User Count Options

The Page Audit User is one of the main execution paths for data integrity checking.   SQLIOSim runs test cycles and during each test cycle the [Audit User] section of the .INI configuration file is used.  These workers perform various page
Posted by psssql | 1 Comments
Filed under: , ,
Thursday, May 22, 2008 3:42 PM

How It Works: SQL Server 2005 - Possible data recovery when checksum failure reported

I and Microsoft will always opt for restore of a backup when corruption of the database is encountered.   This is the only way to safely restore the database to a known state.   All other actions, such as dbcc repair, can remove data
Posted by psssql | 0 Comments
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: , , ,
Thursday, January 24, 2008 3:30 PM

How It Works: Conversion of a Varchar, RPC Parameter to Text from a Trace (.TRC) Capture

The Senior Escalation Engineers do various training and mentoring activities. As I do this I thought I would try to propagate some of this information on the blog. This was an interesting issue I ran into this week. The reported problem was that the data
Posted by psssql | 1 Comments
 
Page view tracker