October 26, 2010 at 2:06 pm
We have this report that is displaying 92,000 records, after first doing some grouping and sorting on the SQL side, but after about 20 minutes we get this error:
Internet Explorer cannot display the webpage
---------
Most likely causes:
...
I found out that there is extensive blocking on the ReportServerTempDB database, table SessionLock, idx IDX_SessionLock.
I wonder if I need to re-build this index? Anyone else had this issue before? Not sure if it is related with the problem I'm having.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 26, 2010 at 2:41 pm
I saw this link just now:
[p]http://www.sqlservercentral.com/Forums/Topic795626-150-1.aspx[/p]
One recommendation is to change the isolation level of ReportServerTempDB to READ COMMITTED.
I wonder if anyone has attempted this?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply