Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th January 2005, 19:53
batmush's Avatar
batmush batmush is offline
Senior Member
 
Join Date: Jan 2005
Posts: 117
batmush is on a distinguished road
Baan: BaaN IVc4 - DB: Oracle - OS: 2003 Server
SQL Mem usage is too high.

Hi guys,
I have 1G RAM on the BaaN server. 77-80% of Mem usage is for sqlservr.exe so I have only 50M RAM available.
Is this normal?
Thanks.
Reply With Quote
  #2  
Old 18th January 2005, 23:17
p.cole's Avatar
p.cole p.cole is offline
Senior Member
 
Join Date: Nov 2001
Location: Portsmouth, UK
Posts: 265
p.cole is on a distinguished road
Baan: Baan IVc4 SP20, ERP LN FP3 - DB: MSSQL 2005 - OS: W2K3
Yep, SQL Server uses as much memory as it can so that it can cache tables in memory for faster access. There are settings to tweak this though.
Reply With Quote
Sponsored Links
  #3  
Old 19th January 2005, 15:00
batmush's Avatar
batmush batmush is offline
Senior Member
 
Join Date: Jan 2005
Posts: 117
batmush is on a distinguished road
Baan: BaaN IVc4 - DB: Oracle - OS: 2003 Server
What kind of settings? Where?

Could you tell me where are the settings?
Reply With Quote
  #4  
Old 24th October 2005, 11:08
Viplov's Avatar
Viplov Viplov is offline
Senior Member
 
Join Date: Dec 2004
Location: Delhi
Posts: 201
Viplov is on a distinguished road
Baan: Baan IV c4 - DB: oracle - OS: Unix,Solaris & windows
This document will help you
Attached Files
File Type: doc performance report.doc (473.0 KB, 73 views)
Reply With Quote
  #5  
Old 25th October 2005, 00:27
Darren Phillips's Avatar
Darren Phillips Darren Phillips is offline
Guru
 
Join Date: Aug 2001
Location: west wales, UK
Posts: 334
Darren Phillips is on a distinguished road
Baan: IV4c4 SCH1 SP14 /AGS2 - DB: SQL7/sql2000/Oracle 9 - OS: NT4 Enterprise / win2000/3
in enterprise manager there is an option to either allow sql to use the memory in dynamic mode or allocate a specific amount of memory to sql. I found on SQL7 that if it was in dynamic mode the server would lock up after about 3 weeks. once allocated the memory the problem went away.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
Strange requirement Renegade Tools Development 8 7th April 2004 16:06
(Embedded SQL) and (Dynamic SQL) nopadon Tools Development 2 6th December 2003 06:55
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 13:11
A powerful SQL worksheet with edit capability halvorn Third Party Products 0 28th February 2002 08:37


All times are GMT +2. The time now is 22:31.


©2001-2017 - Baanboard.com - Baanforums.com