Should I run SQLIOSim? – An e-mail follow-up from SQL PASS 2008

From: Robert Dorr [mailto:rdorr@microsoft.com] Sent: Thursday, November 20, 2008 11:29 AM To: A SQL PASS MEMBER – CSS First Aid Station Question About SQLIOSim As we discussed at SQL PASS – SQLIOSim is an independent utility and has been used as part of the Windows Hardware Compatibility Testing (WHCL) suite for several years.   Many of…

5

RSWindowsNegotiate and 401.1 Error when using RS 2008

While I was setting up one of my demos for SQL PASS, I starting hitting 401.1 errors.  I was setting up a SharePoint Intergrated setup with Reporting Services. I knew I had a distributed environment, so I accounted for my Kerberos configuration.  I lined up my SPNs and made sure my accounts were trusted for…

1

PRB: RML Utilities – ReadTrace -M or -MF parameters cause processing to fail with SQL 2008 trace files

Summary ReadTrace processing may unexpectedly stop with an assertion if you use the -M or -MF parameters with SQL 2008 trace files. Workaround Do not use the -M or -MF parameters with SQL 2008 trace files. More Information This problem is currently being investigated and I will post back with any updates. Sarah Henwood |…

1

INF: RML Utilities – You cannot use 9.01 Reporter against performance analysis database loaded by down-level ReadTrace

Summary If you use the latest 9.01 release of Reporter and point to a performance analysis database that was loaded by a down-level version of ReadTrace, you may get errors about missing stored procedures such as the following: “Could not find stored procedure ‘ReadTrace.usp_CheckSchemaVersion’” More Information The 9.01 Reporter version will not work against a…

1

Microsoft CSS at the PASS Summit 2008

Once again I’m proud to be part of a team of CSS engineers from Microsoft that will be speaking and participating at the PASS Summit 2008 next week in Seattle, Washington. A nice summary of the CSS participation can be found on the PASS website at: http://summit2008.sqlpass.org/css_agenda.html Let me give you some inside info about…

1

PRB: RML Utilities – Setup may Always Prompt for Report Viewer 2008 Redistributable

Summary In rare circumstances on systems with UAC enabled, setup of Cumulative Update 1 of the RML Utilities may continue to prompt you for the Microsoft Report Viewer 2008 Redistributable (SP1 or later) even after you have already installed the redistributable: “The RML Utilities require the Microsoft Report Viewer 2008 Redistributable (SP1 or later). Do…

2

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)   ********** Final Summary for file E:\sqliosim.mdx ********** File Attributes: Compression = No, Encryption = No, Sparse = No Target IO Duration (ms) = 100, Running Average…

5

Cumulative Update 1 to the RML Utilities for Microsoft SQL Server Released

    Version 9.01 of the RML Utilities for Microsoft SQL Server has been released.  This release of the RML Utilities provides support for SQL Server 2000, SQL Server 2005 and SQL Server 2008.  Additionally this release of the RML Utilities for SQL Server contains important software updates, enhanced features and reports, and performance and scalability…

8

RML Utilities: ReadTrace may encounter assertion building the partial aggregates

Summary In rare circumstances ReadTrace may encounter the following SQL Server 2008 assertion error when attempting to execute a parallel query. 11/03/08 00:05:35.139 [0X00003B94] Dumping error record 1 of 2: 11/03/08 00:05:35.139 [0X00003B94] ————————————————————————– 11/03/08 00:05:35.144 [0X00003B94]    Description       = A system assertion check has failed. Check the SQL Server error log for details. Typically, an…

2