Uipath database size increasing

Help Orchestrator
, , ,
2

Review the logs that are actively being generated this will indicate the credential being used as well as the Robot. Do they have anything in common?

Robots can be adjusted to have different log levels within their NLog configuration, Orchestrator Robot setting, and from the UiRobot Tray / Agent Desktop has any of your robots been bumped up to trace level and over logging when it does need to?

Take a look at your Orchestrator’s Web.config and look to what your minimum log level is configured for Robot.*. If you need to use this to control the log levels that make it into the database.

The other question would be, is the data size strictly increasing due to the dbo.logs or are other tables increasing your data size or possible the data base log file itself (temp log space allocated etc). Depending on if you are deleting records, truncating, creating new table, rebuilding index etc, your temp log space could be growing as you delete the records in the table.

I used the following SQL to help me identify and trim down table sizes last year when we were limited on space.

sp_helpdb UiPath;
DBCC SQLPERF(LOGSPACE);
exec sp_spaceused;
SELECT
 SUBSTRING(a.FILENAME, 1, 1) Drive,
 [FILE_SIZE_MB] = convert(decimal(12,2),
round(a.size/128.000,2)),
 [SPACE_USED_MB] = convert(decimal(12,2),
round(fileproperty(a.name,'SpaceUsed')/128.000,2)),
 [FREE_SPACE_MB] = convert(decimal(12,2),
round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,
 [FREE_SPACE_%] = convert(decimal(12,2),
(convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) 
/ convert(decimal(12,2),round(a.size/128.000,2)) * 100)),
 a.NAME, a.FILENAME
FROM dbo.sysfiles a
ORDER BY Drive, [Name];

SELECT 
(SELECT COUNT(*) FROM dbo.Logs) AS Logs,
(SELECT COUNT(*) FROM dbo.QueueItems) AS QueueItems,
(SELECT COUNT(*) FROM dbo.UserNotifications) AS UserNotification,
(SELECT COUNT(*) FROM dbo.TenantNotifications) AS TenantNotification,
(SELECT COUNT(*) FROM dbo.AuditLogs) AS AuditLogs;

Also remember to create some maintenance tasks that will keep your tables in a good state that is suitable for your need.