Difference between revisions of "SQL Server Reporting Services"
From Richard's Wiki
(New page: == Optimization == From http://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.mspx Technet Performance Optimization Tips: * If performance is poor even for single users, che...) |
(→Optimization) |
||
| Line 5: | Line 5: | ||
* If performance is poor even for single users, check the Application Restarts counter in the ASP.NET category. Some antivirus software is known to “touch” configuration files, thus causing expansive Application Domain restarts in the Report Server Web service. For more information, search [[http://support.microsoft.com/ support.microsoft.com]] for articles about antivirus and ASP.NET. | * If performance is poor even for single users, check the Application Restarts counter in the ASP.NET category. Some antivirus software is known to “touch” configuration files, thus causing expansive Application Domain restarts in the Report Server Web service. For more information, search [[http://support.microsoft.com/ support.microsoft.com]] for articles about antivirus and ASP.NET. | ||
| − | * If performance is slow on the first Web service access after a period of no activity, disable the idle time-out on the Performance tab | + | * If performance is slow on the first Web service access after a period of no activity, disable the idle time-out on the Performance tab of the Application Pool corresponding to SQL Server Reporting Services, in IIS Manager. |
Revision as of 21:57, 19 January 2009
Optimization
From [Technet Performance Optimization Tips]:
- If performance is poor even for single users, check the Application Restarts counter in the ASP.NET category. Some antivirus software is known to “touch” configuration files, thus causing expansive Application Domain restarts in the Report Server Web service. For more information, search [support.microsoft.com] for articles about antivirus and ASP.NET.
- If performance is slow on the first Web service access after a period of no activity, disable the idle time-out on the Performance tab of the Application Pool corresponding to SQL Server Reporting Services, in IIS Manager.
