Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Tools   (RSS)
Thursday, June 04, 2009 10:20 PM

RDTSCTest CPU Speed Output Clarified

Starting with SQL Server 2005 SP3 and SQL Server 2008 the RDTSC counter is not used for timing in SQL Server but you may still have occasion to use RDTSCTest.   From: Robert Dorr Sent: Thursday, June 04, 2009 4:14 PM Subject: RE: SQL Troubleshooting
Posted by psssql | 0 Comments
Filed under: , , ,
Tuesday, April 07, 2009 8:16 PM

Troubleshooting sp_xp_cmdshell_proxy_account Errors

I was attempting to establish the command shell proxy on my local machine and ran into a series of errors.   As I looked at them more I decided to file some work items with the SQL dev team to provide better context in the message text.  
Posted by psssql | 1 Comments
Tuesday, March 31, 2009 8:00 PM

SQL 2005: SQL Server Configuration Manager Error: Connection to target machine could not be made in a timely fasion.

There is a bug with the message spelling (fasion instead of fashion) but that is not the focus of this post. When launching the SQL Server Configuration Manager you may receive this message if the WMI connections and queries do not complete within 30
Posted by psssql | 1 Comments
Filed under: , , ,
Friday, January 23, 2009 10:10 PM

INF: Multi-Machine Replay Using ORCA and OSTRESS

You can place ORCA on a central computer and allow it to control the sequencing from multiple client computers running OSTRESS.    To accomplish this you must configure the firewall properly. Note: Be sure to install the same version of
Posted by psssql | 0 Comments
Wednesday, January 21, 2009 4:38 PM

WMI Provider Error Access is denied - while changing SQL Server account password

Recently one of our blog readers reported that when they tried to change the SQL Server account password in SQL Server Configuration Manager they were getting "WMI Provider Error Access is denied [0x80070005]".  This was happening on two
Posted by psssql | 2 Comments
Filed under: ,
Thursday, January 08, 2009 5:51 PM

Filtering Trace Data Without Loading In Profiler or Database Table

We are often asked how to extend the filtering of RML (ReadTrace/OStress) or Profiler.  Filtering during trace production is the preferred method because it typically reduces the overall impact of the Trace on the SQL Server throughput.  
Posted by psssql | 1 Comments
Filed under: , ,
Friday, December 19, 2008 7:45 PM

Using SQLIOSim to Diagnose SQL Server Reported Checksum (Error 824/823) Failures

This is an extension to by previous post about SQLIOSim data integrity testing. http://blogs.msdn.com/psssql/archive/2008/03/05/how-it-works-sqliosim-checksums.aspx SQLIOSim (.exe/.com) is the predecessor to SQLIOStress.   SQLIOSim is SQL Server
Posted by psssql | 1 Comments
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 | 5 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, September 02, 2008 8:29 PM

SQL Server 2008 Management Tools Basic vs Complete Explained....

A few questions have come up about the differences between the features you can install on SQL Server 2008 called Management Tools - Basic   and Management Tools - Complete. So I thought I'd blog about these to resolve any questions you might have.
Posted by psssql | 3 Comments
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 | 2 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 | 1 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 | 3 Comments
Filed under: ,
More Posts Next page »
 
Page view tracker