Work Queue database space consumption

IshanMahajan — Fri, 11 Dec 2020 10:46:00 GMT

Hi,

Does any know how much space it occupies when you create a work queue entry which have item data of 5X1000 array, i mean 5 columns and 1000 rows.

i understand BP database must have archiving policies and workqueue data must be cleaned up periodically but i am just interested to know what is the space consumption amount ?

I am storing it for reporting perspective and would delete after reports are generate.

------------------------------
Ishan Mahajan
India
------------------------------

RE: Work Queue database space consumption

NicholasZejdlik — Fri, 11 Dec 2020 15:32:00 GMT

It would vary significantly depending on what is in that 5x1000 array. Also, work queue data is stored in XML format, so there's some overhead from that as well. I think the only way to get an accurate estimate would be to check the length data field of the item in the BPAWorkQueueItem table on SQL.

Here's an example query to calculate roughly how many bytes would be used to store the data for a specific queue:

Select
	Len(data) * 2 [Rough Size in Bytes] -- Multiply by 2 because of nvarchar
From
	BPAWorkQueue Q
	Inner Join BPAWorkQueueItem I On
		Q.ident = I.queueident
Where
	Q.name = 'your queue name here'

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

topic RE: Work Queue database space consumption in Product Forum

Work Queue database space consumption

RE: Work Queue database space consumption