Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Tools   (RSS)
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
Thursday, April 10, 2008 7:20 PM

Troubleshooting xp_cmdshell failures

This post assumes you have properly enabled the xp_cmdshell feature using the Surface Area Configuration tool and you have used Management Studio | Server Properties | Security to establish a proxy for xp_cmdshell execution. Sample command:  
Posted by psssql | 1 Comments
Filed under: ,
Saturday, April 05, 2008 6:21 PM

Microsoft to Increase Use of SQL Server 2005 Best Practices Analyzer (SQLPBA) - So Should You

I don't want you to be surprised when you see more use of SQLBPA.   It was 18 months ago when the development team approached the support team asking us to help identify issues for SQLBPA.   Several of us, including myself helped identify
Posted by psssql | 1 Comments
Filed under: ,
Saturday, April 05, 2008 3:24 AM

SQLIOSim is "NOT" an I/O Performance Tuning Tool

This blog post is to again inform you "NOT" to consider SQLIOSim as an I/O performance evaluation tool!   Every other month or so I get a rash of questions about using SQLIOSim to validate I/O performance and I have to repeat the same
Posted by psssql | 2 Comments
Filed under: ,
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
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: , ,
Friday, January 11, 2008 9:52 PM

RML Utilities Install Fails with MSI (Windows Installer) Error #2755

It is possible to encounter error 2755 when installing the RML Utilities package.   The most common cause is an encrypted file.  This is generally from storing the download in an encrypted folder. Reproduction Steps Store the RMLSetup*.msi
Posted by psssql | 0 Comments
Filed under: ,
Wednesday, November 21, 2007 2:43 PM

RML (READTRACE/OSTRESS) Utilities for SQL Server 2005

As I promised at the PASS 2007 Summit in Denver, I'm writing a post here about the popular RML Utilities better known and READTRACE and OSTRESS. Our goal was to have this fully ready and posted on the web for public download by Thanksgiving. That day
Posted by psssql | 3 Comments
Filed under: , ,
Tuesday, April 10, 2007 4:04 PM

SQLIOSim - Outstanding I/O Warnings

I have encountered some questions pertaining to the SQLIOSim outstanding IO warnings and I am posting some details.   The Display monitor thread is responsible for updating the display (progress outputs) and checking for long IOs   (CheckForLongIO/ReportLongIo).
Posted by psssql | 3 Comments
Filed under: ,
 
Page view tracker