17
Could not allocate memory for the threshold task's argument list; threshold task cannot be spawned for database %d, segment %d, free space %ld.
This error occurs when a stored procedure associated with a threshold was not initiated because there was not enough memory available in procedure cache.
Although error 7401 indicates that the threshold task did not run because not enough memory was available in procedure cache at that time, the threshold task may have run later when enough memory did become available.
Before performing the following steps, determine whether
the threshold task ran at a later time. If the threshold task has
already run, the following steps are not necessary.
To perform the threshold task that did not run because of this error:
Select the database:
1> use <database_name> 2> go
Where <database_name> is the database for which the error occurred.
Run sp_helpthreshold <segment_name> for the segment named in the error message. This will display the stored procedure associated with the threshold.
Run the stored procedure manually.
To prevent this error from occurring in the future, make sure there is enough memory to run stored procedures associated with a threshold by testing them during the time when your system is most heavily loaded. If there is not enough memory, do one of the following:
Use sp_configure to increase the Adaptive Server procedure cache size configuration parameter (increases the percentage of total cache space that is used as procedure cache).
Use sp_configure to increase the value of the total memory configuration parameter.
Rewrite the stored procedure to execute in the procedure cache available for the Adaptive Server.
Refer to the Adaptive Server Enterprise Performance and Tuning guides and “Configuring Memory” in the System Administration Guide: Volume 2 for information about Adaptive Server memory use.
Refer to the chapter “Managing Free Space with Thresholds” in the System Administration Guide: Volume 2 for information about Adaptive Server thresholds.
All versions
