We have 8GB of memory with 4 dual core processors and our machine is
very under utilized with 30 users. We have several other databases on
the SQL server and want to split Vantage away from the same server as
SQL but were told not to. I agree with the views, table locks become a
problem on big queries. Would you not need SQL Enterprise to take
advantage of 8GB of memory? From what I have read and observed, SQL
Standard will only use 2GB of memory.
Joe Luster
Network Administrator
Cold Jet, LLC
513-831-3211 ext. 308
513-831-1209 FAX
<http://www.coldjet.com>
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of acp2g99
Sent: Thursday, May 31, 2007 7:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage Server Buffers
Chris,
How did you configure your 8GB memory.
We're running 2.8GHz Dual Core / Dual processor with 8GB RAM on Dual
Ranked DIMMS and we continue to peg out our pages per second.
Although it's intermittent, it just about brings our system to its
knees.
Additionally, have you ever heard of using SQL VIEWS instead of
TABLES to create Crystal reports using ODBC, so that records are not
locked? Epicor seems to believe that is part of our problem with our
slowness as well.
Any direction is sincerely appreciated.
acp2g99
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Steve Findley" <sfindley@...> wrote:
Behalf
very under utilized with 30 users. We have several other databases on
the SQL server and want to split Vantage away from the same server as
SQL but were told not to. I agree with the views, table locks become a
problem on big queries. Would you not need SQL Enterprise to take
advantage of 8GB of memory? From what I have read and observed, SQL
Standard will only use 2GB of memory.
Joe Luster
Network Administrator
Cold Jet, LLC
513-831-3211 ext. 308
513-831-1209 FAX
<http://www.coldjet.com>
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of acp2g99
Sent: Thursday, May 31, 2007 7:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage Server Buffers
Chris,
How did you configure your 8GB memory.
We're running 2.8GHz Dual Core / Dual processor with 8GB RAM on Dual
Ranked DIMMS and we continue to peg out our pages per second.
Although it's intermittent, it just about brings our system to its
knees.
Additionally, have you ever heard of using SQL VIEWS instead of
TABLES to create Crystal reports using ODBC, so that records are not
locked? Epicor seems to believe that is part of our problem with our
slowness as well.
Any direction is sincerely appreciated.
acp2g99
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Steve Findley" <sfindley@...> wrote:
>[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Chris,
> We went to 8gb memory.
> We also upgraded to a Dell quad 4 server.
> We have 70 licenses.
> 30 data collections.
> All in sql....we seem to be fine now.
>
> I do not know about the open edge, but I can research if you desire.
>
> Please advise.
>
> Stephen Findley
> IT Manager
> 281-353-1191 Office
> 713-419-4084 Cell
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Behalf
> Of Chris Robischto
> Sent: Wednesday, May 30, 2007 1:57 PM
> To: Vantage Yahoo
> Subject: [Vantage] Vantage Server Buffers
>
>
>
> Would like to get an idea how others are allocating memory buffers
> Vantage, especially version 8.x SQL. I think we need to go to 8gbmemory
> for go-live. Right now, we have:[Non-text portions of this message have been removed]
>
> Memory: 4gb
> SQL: 1.2gb (fixed)
> OpenEdge: 40,000 (* block-size of 4096 = 164mb)
> Office Licenses: 26
> Data Collection: 6
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>