Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st August 2003, 11:15
GAURAVGUPTA9's Avatar
GAURAVGUPTA9 GAURAVGUPTA9 is offline
Unconfirmed User
 
Join Date: Mar 2002
Location: India
Posts: 103
GAURAVGUPTA9 is on a distinguished road
Baan: BaanIV C4 BAAN5.0C - DB: SQL Server7,2000, Oracle8 - OS: HP unix, Win2000,AIX
serious performance problem

Hi all
i am having a sesious problem. we have two servers one is development server another is live server. the development server is having one processor and 1 GB RAM. live server equiped with 4 processors and 3 GB RAM. when we r processing the payroll session monthly. the live server taking around 1.5 min for one employee. but development server taking only 35 sec for the same. the data is same on both the servers. i am unable to understand wot is the problem??? there can be some performance issue. both server having
WIN2000 and SQL SERVER2000.
plz some body help me to overcome this situation....
Thanx in Advance
Gaurav Gupta
Reply With Quote
  #2  
Old 21st August 2003, 12:31
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,075
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2
Analyse your logfile WhySoLong when running with this option:
-- -keeplog -logfile WhySoLong -set TT_SQL_TRACE=020240 <sessioncode>
__________________
Also read Luke 24:4-8
Reply With Quote
  #3  
Old 21st August 2003, 21:48
danielv's Avatar
danielv danielv is offline
Member
 
Join Date: Nov 2002
Location: San Diego
Posts: 62
danielv is on a distinguished road
Baan: LN 10.2.1 - DB: MS SQL Server 2012 - OS: Windows 10
Also there might be a problem with MS SQL 2000 Service pack 3.
Try to upgrade your installation to MS SQL Server Service pack 3a
Reply With Quote
  #4  
Old 22nd August 2003, 11:08
Guillaume.G's Avatar
Guillaume.G Guillaume.G is offline
Member
 
Join Date: Aug 2002
Location: Lyon - France
Posts: 69
Guillaume.G is on a distinguished road
Baan: Triton3.1, BaanIV,baan ERP and ERP Ln - Workflow - DB: Oracle(7 to 10i), SQLserver(6.5 to 2005), Bisam - OS: NT,2000, 2003, Unix(Solaris,AIX,HPUX)- Linux
It's probablya pb WithSQL2000 SP3

Hi,

I think is Pb a with the SP3 of SQL2000 (extacly with MDAC2.7 SP1)

in this case you have two solutions:
- install SP3a (which containt the MDAC2.71a)
- Desinstall SP3 (return to SP2)

For my case, i'm choice the second solution (Because, when I have this Pb the SP3a is not available). And I'm prefered waiting theSP4

You can refer of baan solution n°132157

Guillaume G.
Reply With Quote
  #5  
Old 22nd August 2003, 11:19
Sai_krishna Sai_krishna is offline
Member
 
Join Date: Jan 2002
Location: Pune
Posts: 95
Sai_krishna is on a distinguished road
Baan: IV,V,LN - DB: Oracle,SQL - OS: NT,UNIX
service pack

How can i check the service pack of SQL server2000
Reply With Quote
  #6  
Old 22nd August 2003, 11:46
Guillaume.G's Avatar
Guillaume.G Guillaume.G is offline
Member
 
Join Date: Aug 2002
Location: Lyon - France
Posts: 69
Guillaume.G is on a distinguished road
Baan: Triton3.1, BaanIV,baan ERP and ERP Ln - Workflow - DB: Oracle(7 to 10i), SQLserver(6.5 to 2005), Bisam - OS: NT,2000, 2003, Unix(Solaris,AIX,HPUX)- Linux
Hi,
To identify which version of SQL Server 2000 you have installed, type :
SELECT @@VERSION at the command prompt when using the osql or isql utilities or in the Query window in SQL Query Analyzer.
The following table shows the relationship between the version string reported by @@VERSION and the SQL Server 2000 version number.

@@VERSION SQL Server 2000 version
8.00.194 SQL Server 2000 RTM
8.00.384 Database Components SP1
8.00.532 Database Components SP2

I don't know for the SP3

Guillaume G
Reply With Quote
  #7  
Old 22nd August 2003, 17:07
GAURAVGUPTA9's Avatar
GAURAVGUPTA9 GAURAVGUPTA9 is offline
Unconfirmed User
 
Join Date: Mar 2002
Location: India
Posts: 103
GAURAVGUPTA9 is on a distinguished road
Baan: BaanIV C4 BAAN5.0C - DB: SQL Server7,2000, Oracle8 - OS: HP unix, Win2000,AIX
8.00.194 SQL Server 2000 RTM

i checkd it, it is
8.00.194 SQL Server 2000 RTM. both the servers. do i need to instal new service pack.
Gaurav
Reply With Quote
  #8  
Old 8th September 2003, 19:55
danielv's Avatar
danielv danielv is offline
Member
 
Join Date: Nov 2002
Location: San Diego
Posts: 62
danielv is on a distinguished road
Baan: LN 10.2.1 - DB: MS SQL Server 2012 - OS: Windows 10
go directly to sp3a directly.
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 Performance Problem santosh Tools Development 1 15th October 2003 15:00
Baan IVc2 and Oracle 8.1.7 performance problem mpenno Performance & Tuning 2 3rd September 2003 19:50
Performance problem in session tisfc0102m000 christophe Manufacturing & Supply Chain 5 29th January 2003 17:59
Performance Problem ~ Calculate Commissions jroberts Performance & Tuning 1 7th December 2001 15:23


All times are GMT +2. The time now is 01:07.


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