Testing SQL and Appserver on same server - setup question

Yahoo Archive
1
We run Vantage this way. When we purchased Vantage this was the recommended configuration. We use ODBC to the server. Vantage runs about as expected. It's not terribly fast, but as long as you keep your SQL database maintained, it works ok.

We have two Raid controllers. We have different 5 Raid Partitions configured for different things.


[Non-text portions of this message have been removed]
2
I'm testing running the SQL on the same server as the app server.
In that scenario are you still using ODBC to connect the appserver to the SQL database?
Has anyone done this?
We have a new server coming and I have an opportunity to change our current setup if it improves performance.

Thanks,

Chris Wineinger
ERP Specialist
Interior Systems Inc.
3
Yes, it is still ODBC, it's just to the local server instead of another
server.

If you are going to do this, I would suggest that you have completely
different sets of disks, not just partitions, for the OS, the App, the
Database, the Logs, and then a last one for backups, tempdb, and the
EpicorData folder.

If you can have more than one RAID Card in there to distribute the channels,
that is nice too.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
redrhyno13
Sent: Thursday, May 02, 2013 12:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Testing SQL and Appserver on same server - setup question

I'm testing running the SQL on the same server as the app server.
In that scenario are you still using ODBC to connect the appserver to the
SQL database?
Has anyone done this?
We have a new server coming and I have an opportunity to change our current
setup if it improves performance.

Thanks,

Chris Wineinger
ERP Specialist
Interior Systems Inc.



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links