Symantec Management Platform (Notification Server)

I currently have The Notification Server, Help Desk Solution, and MS SQL running on one server. I'm running NS Version No: 6.0.6074 (SP 3) and MS SQL server 05. I'm getting ready to move the SQL portion over to a dedicated SQL server but i was curious if there were any other Performance upgrades i could do. The server running NS and Help Desk is a dual CPU and running 2 GB of ram.

At the bare minimum, I would 2 GB of RAM to up the system to 4GB. This will allow you to utilize the /3GB Switch. How many clients do you have?

I whole-heatedly agree with Jim -your server is looking rather slim on RAM!

For your dedicated SQL Server move I would suggest lots of RAM (enough to fix all the hosted SQL databases in) and can you host it on 64bit hardware with 64bit Windows Server and SQL Server? This will give you the capability of native >4GB support and really fast SQL execution.

There are also lots of articles on the internet about optimising the SQL servers. In short,  multiple CPUs for fast parallel query execution, lots of RAM to ensure that pages are retrieved from memory rather than disk (and further to store cached queries), and fast RAIDed disks  to ensure data integrity and to keep disk queue lengths small (ensures that when data pages have to be loaded from disk that this occurs quickly)

For remote SQL access, I'd also advise (if possible) that the NS hardware and SQL server be in the same rack to reduce the chances of network glitches interferring with NS.

Kind Regards
Ian./

Also, I'd recommend connecting to the sql server using the SQL credentials and not the application credentials when connecting your NS to the Database. 

If budget is not a factor why not go with the maximum specs? just my two cents.

but if it would be a factor. i guess jharings suggestion would be good.