Video Screencast Help

pcAnywhere Solution

Created: 10 Apr 2013 • Updated: 23 Apr 2013 | 4 comments
louiesulit326's picture
This issue has been solved. See solution.

Hi Guys,

I would like to know if it is feasible to use SQL Server 2008 R2 SP2 Express on 1500 clients with pcAnywhere as the only component/module to be used?

No inventory, patch or software deployment. It's just pcAnywhere on a Symantec Management Platform.

Looking forward to your response.

Thank you and regards.

Comments 4 CommentsJump to latest comment

W007's picture


Look symantec pcanywhere system requirement

SQL support list

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

Lark's picture

I think this would be feasible.

You can certainly run the SMP on SQL Express (I even have it running on 2012) but it has some restrictions that would usually prevent you using it for that many endpoints for the whole CMS suite.  The 1GB memory and single core limits are the biggest problems.

On the basis that you're only running the core SMP and pcAnywhere (don't even install any other solutions) I think you'll be ok.  You might want to consider reducing all the filter and policy update frequencies, setting the agents to connect in less (8 hours or less?), reduce config update requests and (once you're up and running) use a table size report to check you're not holding useless information that could be purged more frequently.

I've not tried it but if you could find a way to disable the task agent component of the Symantec Management Agent this would also help to reduce the load on the SMP server by reducing task server load. AFAIK you don't need task server for pcAnywhere.

Please post back here if you get this working.  I'm always interested in how far SQL Express can be stretched.

Ch@gGynelL_12's picture

I think its not feasible because SQL express have limitations. And these limitations will probably cause an issue or problem in the future. So, to make sure all your deployments will work very well, do what Symantec Recommends to you.



louiesulit326's picture

Thank you for the response guys! I will follow Symantec's best practice on implementing this solution.