DARTS : Query Limits

PS Query Limits

		Run Time Limit in Minutes	Output Size Limit in Megabytes	Maximum Number Queries That Can Run Simultaneously
CSRPT
	When run query in Edit Mode	5 Minutes	5 MB	Variable¹
	When Run to HTML or Run to Excel	20 Minutes	15 MB	4
	When run as Scheduled query	Unlimited	Unlimited	0 - 3²

CSPRD
	When run query in Edit Mode	5 Minutes	5 MB	Variable¹
	When Run to HTML or Run to Excel	20 Minutes	15 MB	3
	When run as Scheduled query	Unlimited	Unlimited	0 - 3²
_________________________
¹	Variable depending on a number of circumstances
²	Depends on the number of other processes running at the same time

NOTE:
	When a query exceeds the above time limits and generates a "time out" message, please notify the DBA group to cancel the query. When a query times out it is actually still running, using system resources, and therefore needs to be cancelled.



HRPRD
	When run query in Edit Mode	5 Minutes	5 MB	Variable¹
	When Run to HTML or Run to Excel	20 Minutes	15 MB	2
	When run as Scheduled query	Unlimited	Unlimited	0 - 3²
_________________________
¹	Variable depending on a number of circumstances
²	Depends on the number of other processes running at the same time

NOTE:
	When a query exceeds the above time limits and generates a "time out" message, please notify the DBA group to cancel the query. When a query times out it is actually still running, using system resources, and therefore needs to be cancelled.


FNPRD

	When run query in Edit Mode	20 Minutes	10 MB	3
	When Run to HTML or Run to Excel	20 Minutes	10 MB	3
	When run as Scheduled query	Unlimited	Unlimited	0 - 5¹
_________________________
¹	Depends on the number of other processes running at the same time

NOTE:
	When a query exceeds the above time limits and generates a "time out" message, please notify the DBA group to cancel the query. When a query times out it is actually still running, using system resources, and therefore needs to be cancelled.

From Bill Gilfillan, 2/1/2010.

This information has not been recently validated.