Altiris KB# 50744 – Agent Install Page Slow

August 11, 2010

AKB# 50744 covers a problem where the Altiris Agent install page loads very slowly. This symptom occurs regardless of how you access the page (Actions> Agents/Plug-ins> Push Altiris Agent) or (Settings> Agents/Plug-ins> Altiris Agent). In my environment I started seeing upwards of seven often 10 minute load times for the push screen, unacceptable by any standard. The KB talks about a stored procedure that is used to help populate the data in the grid on the install page. The article goes on to explain that in testing this SPROC was taking approximately  5 minutes to run, similar to the times I was seeing.

The article then discusses the evt_aex_agent_push_status table, this is where information about computers you add to the grid to install the agent to is stored. I found on my installation of SMP 7 SP4 that this table was named evt_aex_push_status with the word ‘agent’ removed. There are 2 solutions to this issue, the one prescribed in the KB article is the faster of the two.

1.) Truncate the evt_aex_agent_push_status or evt_aex_push_status table. This clears the data from the table and the SPROC should complete in seconds rather than minutes which translates directly into a much faster load time in the console. It is important to note the use of truncate here and not delete. ‘Deletes’ in SQL Server are logged and so running a delete against a table with a lot of records isn’t advisable (unless you have all day). Secondly, and perhaps more importantly, a truncate can be rolled back.

2.) If you wait the painful 5-10 minutes for the Agent push screen to load, clear all computers out of both the Windows and (more importantly) the ULM (unix linux mac) push tab. It seems as though ULM computers cause this more than windows devices.

The reason for this post is to add the following code that you can use to create a stored procedure (SPROC) of your own to truncate the aex push data table. Paste the following code into SSMS or your tool of choice.

USE Symantec_CMDB
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[usp_TruncateAeXPushStatus]
AS
SET NOCOUNT ON
TRUNCATE table Evt_AeX_Push_Status

This will create a SPROC called ‘usp_TruncateAeXPushStatus’ that you can then execute to truncate your push status table in the event that this should happen again. The SPROC might be overkill since you are typing ‘exec usp_truncateaexpushstatus’ instead of ‘truncate table evt_aex_push_status’ but hey, I saved you from typing some underscores.

Keep in mind you have to have the proper permissions to truncate tables and this also fixed another issue I was having where it was taking five minutes or more just to add a ULM computer on that screen.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: