Welcome to MSDN Blogs Sign in | Join | Help

SQL Server (RSS)

Scaling out the Viewer Control and rsExecutionNotFound

One of the criteria that the report server uses to match the provided SessionID with a stored report is that the SessionID has to be provided by the same user that initially created the session. Usually, this is the case. Someone browses the report in Read More...
Posted Friday, August 08, 2008 9:26 AM by jgalla | 0 Comments

Scaling Up: SSRS 2008 vs. SSRS 2005 (spoiler: 2008 wins)

The SQL Customer Advisory Team just released a Technical Note comparing SQL Server Reporting Services 2008 vs. 2005 from a scale-up perspective. Its good to see that a lot of the work that we did over this release focusing on performance and scalability Read More...
Posted Thursday, July 10, 2008 8:59 AM by jgalla | 0 Comments
Filed under: ,

All those temporary files (RSTempFiles)

When you install Reporting Services, we create a few directories: LogFiles ReportManager ReportServer RSTempFiles Most of these are fairly self explanatory. LogFiles... well we put our log files in there. ReportManager contains the Report Manager application Read More...
Posted Monday, June 30, 2008 11:04 AM by jgalla | 0 Comments
Filed under: ,

Where has John been?

Ok, it has been a little while. But I have been pretty busy lately . His name is Christopher. We have also been pretty busy locking down Katmai to get CTP6 (aka known as the "February CTP") out the door and working bugs. I recommend that people head over Read More...
Posted Tuesday, March 11, 2008 10:35 AM by jgalla | 0 Comments
Filed under: , ,

SQL Server 2008 (Katmai) and Reporting Services

Today the first public release of SQL Server 2008 is shipping. Of course, Reporting Services is still there in the box. You can find general information about the release here: https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395&wa=wsignin1.0 Read More...
Posted Monday, June 04, 2007 1:59 PM by jgalla | 0 Comments
Filed under: ,

Diagnosing Reporting Services Issues

I was poking around some other SSRS blogs from folks here on the product team, and I found this post from Lukasz about troubleshooting Reporting Services . It is a great overview of some of the guidance we have given in the form of whitepapers, KB artciles, Read More...
Posted Thursday, March 29, 2007 9:36 AM by jgalla | 0 Comments
Filed under: ,

ReportServerTempDB IO Saturation

Reporting Services uses a temporary database for storage of objects which are, well, temporary . For example, report snapshots which are associated with a particular user session as the result of a live execution. Cached report snapshots are also stored Read More...
Posted Wednesday, March 21, 2007 11:09 AM by jgalla | 1 Comments
Filed under: ,

Aggregating rsExecutionNotFound Posts

The posts about things dealing with rsExecutionNotFound seem to be what people find most interesting these days. In order to aggregate the posts into one place, I will be adding links that deal with this error here. Maybe I will add a tag as well... Careful Read More...
Posted Thursday, February 01, 2007 9:34 AM by jgalla | 0 Comments

Careful when using rc:Toolbar=false

I'm in the middle of reinstalling Visual Studio, and so I thought I would share an interesting story from a couple of weeks ago. An internal customer (Microsoft-speak for some other team at Microsoft) of Reporting Services was encountering seemingly random Read More...
Posted Wednesday, January 31, 2007 3:47 PM by jgalla | 1 Comments

Load Testing Reporting Services

This question came across one of our internal discussion aliases, and it wasn't the first time I had seen it... so I thought it might be interesting to other people as well. Oftentimes, when people configure a load testing tool they set it up so that Read More...
Posted Monday, January 15, 2007 5:52 PM by jgalla | 1 Comments
Filed under: , ,

Diagnosing rsInternalError

You know the one. You try to render a report and you end up hitting the dreaded "An internal catalog exception has occurred" error message. Generally speaking, this is an indication that something very bad happened within the server which is not necessarily Read More...
Posted Tuesday, December 05, 2006 12:52 PM by jgalla | 0 Comments
Filed under: , ,

A Great Place to Ask a Question

Recently I have had a couple of people send questions directly to me via the " Email " tab asking me for some specific one-on-one technical support for Reporting Services. I thank you very much for your interest in our product, but unfortunately I am Read More...
Posted Tuesday, December 05, 2006 12:27 PM by jgalla | 0 Comments
Filed under:

Transitioning between SOAP and URL Access

The SSRS Web Server supports two basic protocols, SOAP and URL Access. The SOAP API is great for managing the catalog and doing some session management within the context of a report session, but is generally not the greatest thing in the world when actually Read More...
Posted Friday, November 17, 2006 1:59 PM by jgalla | 0 Comments
Filed under: ,

SQL Express and Reporting Services Catalog

SQL Server Express with Advanced Services SP1 shipped a while ago and it includes Reporting Services. There is a bit of an annoying issue though. In the Express SKU, the database engine automatically creates databases with AutoClose on. This behavior Read More...
Posted Monday, October 30, 2006 10:24 AM by jgalla | 0 Comments
Filed under: ,

Session Timeout during execution

Reporting Services has a notion of a user session. This is not the same as ASP.Net's notion of a user session, and in fact the two are completely orthogonal to each other. SSRS's session maintains information about which report a user is looking at, the Read More...
Posted Wednesday, October 11, 2006 1:14 PM by jgalla | 3 Comments
More Posts Next page »
 
Page view tracker