Welcome to MSDN Blogs Sign in | Join | Help

January 2009 - Posts

Thursday, January 29, 2009 1:52 PM

PRB: RML Utilities - Reporter errors during report rendering

Summary On a sporadic basis you may encounter any one of the following errors while rendering reports in Reporter: Index was outside the bounds of the array. Object reference not set to an instance of an object. Fix The following Reporting Services hotfix
Posted by psssql | 0 Comments
Wednesday, January 28, 2009 3:17 PM

Hot It Works: SQL Server SuperLatch'ing / Sub-latches

SQL Server Books Online uses the terms super latches and sub-latch to describe them.   For example the SQL Server:Latches performance counter group calls them super latches.   The DVM that exposes the super latches use the term sub-latch,
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
Thursday, January 22, 2009 7:44 PM

How It Works: Statistics Sampling for BLOB data

I worked on an interesting issue today and the outcome deserves a post.  The issue was that when auto update statistics executed the query went from 6 seconds to 6+ minutes. select count(*) from tblImageData where blobData is null Turing on the SP-:StmtStarting
Posted by psssql | 1 Comments
Wednesday, January 21, 2009 4:50 PM

PRB: RML Utilities - ReadTrace and how to workaround MARS

Summary We've lately gotten several questions from users regarding ReadTrace and how to workaround when your input trace files contain MARS (Multiple Active Result Sets).  ReadTrace currently does not support processing MARS and you will need to
Posted by psssql | 1 Comments
Filed under: ,
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: ,
Wednesday, January 21, 2009 3:33 PM

How It Works: sys.dm_os_buffer_descriptors

Here is a question I was recently asked: " I am counting pages in the buffer pool using ' Select count(*) from sys.dm_os_buffer_descriptors' and I g et 6,460 buffers but when when I look at the Buffer Node:Database pages counter it shows 6,599.  
Posted by psssql | 1 Comments
Filed under: ,
Tuesday, January 20, 2009 9:54 PM

How It Works: SQL Server Sparse Files (DBCC and Snapshot Databases) Revisited

Sarah and I have been approached by several customers wanting to know more about sparse file allocation behaviors.   This post attempts to answer those questions. Previous Posts http://blogs.msdn.com/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx
Posted by psssql | 3 Comments
Filed under: ,
Tuesday, January 13, 2009 1:30 PM

"Error: SharePoint is installed but not configured" when installing the RS Add-in on Windows 2008

I ran across an interesting issue when trying to install the Reporting Services Add-in for SharePoint on a Windows 2008 server.  We would get the error listed above when trying to install the Add-in.  We choose repair on the Add-in component. 
Posted by psssql | 0 Comments
Monday, January 12, 2009 11:14 PM

ReadTrace Generates Unexpected Connect Node - Not Really

At first glance it appears that ReadTrace has generated an unexpected connect node.  Upon closer inspection the behavior is correct in order to maintain the proper set options for the connection. Trace has both physical and logical connect/disconnect
Posted by psssql | 0 Comments
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: , ,
Wednesday, January 07, 2009 8:04 PM

Installing SQL Server 2005 SP3 or SQL Server 2008 on builds prior to XP SP3 Can lead to Bug Check (0xF4, Blue screen, Critical Process Termination)

Due to a bug in Windows XP builds prior to the XP SP2 hot fix or XP SP3 release you may encounter one of the following bugs while attempting to install SQL Server 2008 or SQL Server 2005 SP3 based builds. An application that uses the Sxs.dll file crashes
Posted by psssql | 1 Comments
Monday, January 05, 2009 12:17 AM

WMI Provider Error: Access is denied. [0x80070005] from SQL Server Computer Manager

When you attempt to change the Login Account for the SQL services [SQL Server, SQL Agent, Full Text, Analysis Services] from the SQL Server Computer Manager tool, you may encounter the following error message: "WMI Provider Error" "Access is denied. [0x80070005]"
Posted by psssql | 5 Comments
 
Page view tracker