For us there appears to be a link between IT Analytics and nse processing. For the life of me I cant figure out how. But if we turn off ITA processing, the number of issues are greatly reduced. We were able to confirm that yesterday.
As for the process I do the following:
Stop the following services on SMP in this order:
World Wide Web Publishing Service
Altiris Support Service
Altiris Service Hoster
Altiris Service (stop dependent processes when prompted)
Altiris Object Host Service
Altiris File Receiver
Altiris Event Receiver
Altiris Event Engine
Altiris Client Task Data Loader
Altiris Client Message Dispatcher
Delete the following:
delete files from c:\program data\Symantec\SMP\EventQueue\EvtQueue
delete files and folders in c:\nse files\ (we turned on the option to keep bad nse files and store them here)
On the SQL Server:
Start, All Programs, Microsoft SQL Server 2008 R2
SQL Server Management Studio, windows authentication, connect
New Query, select Symantec_CMDB
truncate table EventQueue
truncate table EventQueueStatus
truncate table EventQueueEntry
truncate table ResourceMerge
Back on the SMP
restart services in the same order as well as any other Altiris marked as Automatic that arent running.
If you have ssetools from support, on the main page there is a Service Controler option. If you launch that, you can change the drop down box to SQL Maintenance and then stop and start services from there.
When you have everything setup the way you want, you can restart and cleanup in about 2 minutes. I have from time to time just moved the nse files for further study instead of deleting them.