Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Friday, November 14, 2008 11:35 PM

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
Posted by psssql | 1 Comments
Filed under:
Friday, November 14, 2008 4:20 PM

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
Posted by psssql | 1 Comments
Filed under:
Thursday, November 13, 2008 3:32 PM

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
Posted by psssql | 1 Comments
Filed under:
Wednesday, November 12, 2008 11:40 PM

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:
Posted by psssql | 2 Comments
Filed under:
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: , ,
Wednesday, November 12, 2008 3:01 PM

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
Posted by psssql | 5 Comments
Filed under:
Monday, November 03, 2008 2:20 PM

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] --------------------------------------------------------------------------
Posted by psssql | 2 Comments
Filed under: ,
Wednesday, October 08, 2008 4:02 AM

SQL Server Support in a Hardware Virtualization Environment

There is no doubt that virtualization is a hot and popular topic (the number of questions over email I get daily are a testament to that). Therefore, I think it is important for our customers to understand the support policies from Microsoft regarding
Posted by psssql | 3 Comments
Filed under: ,
Tuesday, October 07, 2008 9:19 PM

RML Utilities: ReportViewer Bug Affects SQL Server Management Studio and Reporter Utility

Summary An index out of bounds error can occur while rendering a report in Local Report Viewer Mode with more than one dataset. Outer Exception: Object reference not set to an instance of an object, an error occurred during rendering of the report. Inner
Posted by psssql | 2 Comments
Filed under: ,
Wednesday, October 01, 2008 5:06 PM

Windows Scalable Networking Pack – Possible Performance and Concurrency Impacts to SQL Server Workloads

The Scalable Networking Pack aka. SNP (TCP Chimney, RSS and NetDMA) is enabled by default if you apply Windows Server 2003 Sp2.  This is an operating system feature that provides capability to offload TCP/IP packet processing from the processor to
Posted by psssql | 3 Comments
Filed under:
Tuesday, September 30, 2008 7:54 PM

How to fix your SQL Server 2008 Setup before you run setup...

Huh? This is not meant to be a brain teaser. The purpose of this post is to help you avoid problems with SQL Server 2008 setup before you run..well setup. Why not take advantage of known fixes we have for setup to avoid the problem in the first place?
Posted by psssql | 4 Comments
Friday, September 26, 2008 2:36 PM

Welcome to SQL Server 2008 Patching

We have posted the first cumulative update for SQL Server 2008 aptly named Cumulative Update 1 (CU1). I thought before you considered installing a patch for SQL Server 2008, you would like to see a tour of what it looks like compared to SQL Server 2005
Posted by psssql | 9 Comments
Tuesday, September 23, 2008 1:24 PM

Reporting Services Windows Service will not start after applying MS08-052

We have been seeing a few cases where the Windows Service for Reporting Services will not start after applying the following fix: MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008 http://support.microsoft.com/kb/954606/
Posted by psssql | 1 Comments
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: ,
Friday, September 12, 2008 9:23 PM

SQL Server (2000, 2005, 2008): Recovery/Rollback Taking Longer Than Expected

I have blogged on the various ways to determine the state of recovery but this week I was involved in an interesting discussion around rollback. The transaction has run for 14 hours and then a KILL SPID was issued. The SPID goes into rollback and happed
Posted by psssql | 2 Comments
Filed under:
More Posts Next page »
 
Page view tracker