sql serverssrsssrs-2014
I have a SQL Server 2014 test box with SSRS installed. The site loads ok and reports are quick. When I try to go to Subscribe the page takes over a minute to load. From there if I pick a schedule it also takes minutes to load. This is a fresh box with nothing else installed. There's not antivirus installed.
The box has 2 x xeon @ 2.66 and 6GB of memory. I'm the only user on this box as it is just for testing.
When creating an index with online = on, the create index process will not block when creating the index object itself, but when it comes to near the end of the process, it will acquire a schema modification lock* for a period in order to actually add the index to the table, this lock type will block all outside operations until the lock is released, which could account for your blocking issues.
* An Sch-M lock is not required for online build of a new nonclustered index, though it is required in all other cases. A new nonclustered index requires only a table-level shared lock during the final phase, same as was needed during the preparation phase.
See this White Paper for details:
Online Indexing Operations in SQL Server 2005
As suggested by Mushtaq Mohammed in a comment on the question, also see:
Unicorns, rainbows, and online index operations by Paul Randal
The following helped quite a bit, but not totally. Control Panel -> System -> Advanced sytem settings -> Advanced -> Performance Settings -> Advanced -> Adjust for best performance of Background services.
Best Answer
This may be too late but try looking at the File settings for ReportServer and ReportServerTempDB, just like you normally would through SSMS on the instance. They may be defaulted to a few MB with a 1MB autogrowth.