SQL Server Reporting Services - Revision history

Rkdrm at 03:04, 31 March 2011

2011-03-31T03:04:32Z

Rkdrm: /* Optimization */

2011-03-31T02:57:55Z

‎Optimization

Rkdrm: /* Optimization */

2009-01-20T05:57:14Z

‎Optimization

Rkdrm: 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...

2008-11-14T05:32:22Z

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...

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, 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 in the Application in IIS Manager.

← Older revision		Revision as of 03:04, 31 March 2011
Line 1:		Line 1:
	* [http://blog.infotoad.com/post/2009/09/08/Reporting-Services-2008-Using-XML-Data-Source-type-and-Querying-a-Web-Service.aspx Reporting Services 2008 - Using XML Data Source type and Querying a Web Service]		* [http://blog.infotoad.com/post/2009/09/08/Reporting-Services-2008-Using-XML-Data-Source-type-and-Querying-a-Web-Service.aspx Reporting Services 2008 - Using XML Data Source type and Querying a Web Service]
		+	* [http://msdn.microsoft.com/en-us/library/aa964129(v=sql.90).aspx#repservxmlds_topic4 (OBSOLETE, SQL Server 2005, but is MSDN article) Reporting Services: Using XML and Web Service Data Sources]

← Older revision		Revision as of 02:57, 31 March 2011
Line 1:		Line 1:
		+	* [http://blog.infotoad.com/post/2009/09/08/Reporting-Services-2008-Using-XML-Data-Source-type-and-Querying-a-Web-Service.aspx Reporting Services 2008 - Using XML Data Source type and Querying a Web Service]
		+
		+
		+
	== Optimization ==		== Optimization ==

← Older revision		Revision as of 05:57, 20 January 2009
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 in the Application in IIS Manager.	+	* 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.