NS, SQL & VM Support
Updated: 06 Jun 2010 | 7 comments
Hello,
We are running NS 6.0.6074 SP3 R8. The SQL database is on a separate server, which we are looking to retire.
We would like to replace the physical server which running Server 2000 SP4 and SQL 2000 with a 32-bit, 2003 R2 SP2 VM running in our VMWare ESX 3.5 environment. The VM would be loaded with SQL 2005 SP2. Is this configuration supported? By that I mean that if we were to have any issues - would we be able to get support with that configuration?
Any info would be helpful. Thanks.
discussion Filed Under:
Comments
Yes, but..
Yes, but there are some known issues. See "Installing the Symantec Management Platform on VMware", https://kb.altiris.com/article.asp?article=45258&p=1, which has a link to
https://kb.altiris.com/articleRedirect.asp?aid=45257|Issues associated with hosting SQL Server on VMware.
A full support matrix can be found here:
https://kb.altiris.com/article.asp?article=46349&p=1
(I assume you're supported. It says SQL Server 2005 SP2 for 6.x up to R5, SQL Server 2005 SP3 for up to 6.x R10.)
Mike Clemson, Systems Engineer
Intuitive Technology Group -- Symantec Platinum Partner
Thanks. The KB articles are
Thanks. The KB articles are mainly talking about new installs, but I would assume the SQL errors generated by the high I/O in the VM would still apply to existing installations...
Up to R5/R10? Does that mean you need at least R5 for SQL Server 2005 SP2? I just want to make sure I'm reading that right.
Contact support
Not sure, actually. The document only says R5 or R10, the only assumption you can make is that R5 is supported on SQL Server 2005 SP2 and R10 is supported on SQL Server 2005 SP3.
I'd recommend that you contact the Symantec support team by e-mail, including your proposed environment, and explicitly asking if you will be supported. Then you have something to fall back on (other than some forum replies) if you were ever to be denied support.
Mike Clemson, Systems Engineer
Intuitive Technology Group -- Symantec Platinum Partner
64bit OS / 64bit SQL if you can do it
If you can manage it, go for a 64bit SQL 2005 install for your SQL box, even in VM. It makes a huge difference, particularly if you're allocating more than 4GB RAM for the SQL machine. We went from on-box 32bit SQL 2000 SP4 to off-box, 64bit 2005 (granted with a dual quad-core, 48GB RAM box) and it made a huge difference. Reports don't time out anymore (even those that hit the Inv_AeX_SW_Audit_Software view, and/or large Evt_ tables) and switching tabs/collections/etc is much faster (maybe 20% of the previous time for some operations like switching tabs). Even the collection picker is much peppier (maybe 5 seconds to load now where in some cases it would take 30 seconds or more).
Thanks,
Kyle
Symantec Trusted Advisor
For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.
I WISH we could go with a
I WISH we could go with a physical box with 48GB RAM and dual quad-core. Unfortunately money's tight (where isn't it?) and that's why they're looking at a VM solution.
If you knew what SQL our Altiris was running on now you would cry...
Go 64-bit whatever happens
Saying that it run SQL Server 2000 on Windows 2000 makes me feel like crying.
But as Kyle stated above you would greatly benefit form a 64-bit server even with only 8GB of RAM (48 is good so you can have the entire DB in-memory ;-).
Now if you have to do that in a VM, I don't mind but there's no need to limit yourself to 32-bit (unless you are really broke and your VM infrastructure doesn't go on multi-proc server with substantial amount of memory in which case the entire virtualization subject is debatable).
Adding to this reply title I would say that even if you are limited right now have a 64-bit OS and SQL install will allow you to easily scale up on the hosted VM later on.
Ludovic FERRÉ
Principal Remote Product Specialist
Symantec
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect
How many nodes?
How many nodes are you managing? 64-bit makes sense, yes, and certainly with enough memory. (What is the point of replacing a old, underpowered server with a newer, underpowered server?)
Mike Clemson, Systems Engineer
Intuitive Technology Group -- Symantec Platinum Partner
Would you like to reply?
Login or Register to post your comment.