I have an open SR with Mcafee about this, but thought I'd throw this question out there as well. It seems that our data channel is getting overloaded and causing our DB server to start refusing connections. I can't keep the Mcafee Server service running for more than 10 seconds before the application locks up forcing me to restart all the Mcafee services (sans the Server service).
I'm looking at the DB and running select * from EPOAgentHandlerDataChannelWQ and there are over 1000 items listed. My question is it safe for my DBA to clear that table entirely for troubleshooting? Mcafee has had me performing a selective purge of EEADMIN tasks which seem to be the item that's flooding the channel.
I've never cleared the entire tables data before, but yes, I have deleted specific data without any issue due to the reasons mentioned in the above article. If your planning to delete the entire data of the table, ensure you have proper .ldf or .mdf backups depending on your SQL recovery model just to be safe; I doubt anything adverse would happen but it would be simple to revert back as long as you have proper backups.
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.
Community Help Hub
New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.