Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

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 28th January 2003, 15:52
astrom astrom is offline
Newbie
 
Join Date: May 2002
Location: Sweden
Posts: 2
astrom is on a distinguished road
Baan: IVc4 - DB: MS-SQL 2000 Std - OS: Windows 2000
MS SQL SP 3 performance problems

Due to the SQL SLQMMER worm we upgraded to Service Pack 3 for MS SQL 2000 Standard Edition. After that we have experienced performance problems. The session "Rebuild Planned Inventory Movements" used to take 4 minutes, now it takes 40 minutes.

We are running IVc4 level 1.

The problem seems to be simple queries taking long time. I isolated the following code:

select tdsls051.*
from tdsls051
where tdsls051.trdt >= :from.date
and tdsls051.ckor = 3
order by tdsls051._index5
selectdo
endselect

This code runs much slower with SP3.

Has anyone else seen this problem? Do you have any suggestions?
Reply With Quote
  #2  
Old 30th January 2003, 00:12
dedwards45's Avatar
dedwards45 dedwards45 is offline
Junior Member
 
Join Date: Feb 2002
Posts: 6
dedwards45 is on a distinguished road
Baan: 5.0c - DB: SQL Server 2000 - OS: Windows 2000 Advanced Server
SQL SP3

I am offering no help but just adding we are using Baan 5c on and also upgraded to SP3 and are seeing several performance issues. Baan Support has been no help for the last 2 days on getting this resolved.
Reply With Quote
  #3  
Old 30th January 2003, 10:19
sqlbuff's Avatar
sqlbuff sqlbuff is offline
Junior Member
 
Join Date: Apr 2002
Location: Hyderabad
Posts: 10
sqlbuff is on a distinguished road
Baan: All Baan versions - DB: SQL Server - OS: Windows NT and 2000
Rollback to previous MDAC version

Hi,

This problem looks like have affected many, which means the problem is more with the SQL2000 SP3 (or related) than with Baan.

Did you try reverting back to the previously installed MDAC version? SQL 2000 SP3 comes with MDAC 2.7 SP1. There are lot of bugfixes in this service pack, one or more of which would have affected the performance.

The following link tells you how to do that:
http://msdn.microsoft.com/library/de...dacinstall.asp

This might help. If not the MDAC, one of the hotfixes or security patches might have given this problem. But mostly rolling back the MDAC should help.

Regards,
sqlbuff
__________________
You can't recover from a problem you don't have
Reply With Quote
  #4  
Old 30th January 2003, 17:52
dedwards45's Avatar
dedwards45 dedwards45 is offline
Junior Member
 
Join Date: Feb 2002
Posts: 6
dedwards45 is on a distinguished road
Baan: 5.0c - DB: SQL Server 2000 - OS: Windows 2000 Advanced Server
Thanks a million

We rolled back to MDAC 2.7 instead of MDAC 2.7 sp1 and everything is back to normal.. Thanks a lot
Reply With Quote
  #5  
Old 30th January 2003, 18:37
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
We have are also experiencing the same problems, with the same configuration Baan IVc4 SP11, Win 2000 Std, SQL 2000 Std SP3. We have noticed that msql7_srv.exe processes consume huge amounts of processor (virtually all of it) and huge amounts of memory, approx 100MB.

We will attempt to go back to MDAC 2.7 also and let you know.

Thank you very much for sharing this information.
Reply With Quote
  #6  
Old 30th January 2003, 19:56
Ramiro's Avatar
Ramiro Ramiro is offline
Junior Member
 
Join Date: Nov 2001
Location: Grand Rapids - MI - USA
Posts: 10
Ramiro is on a distinguished road
Baan: Baan IV, Baan ERP V - DB: Informix, SQL-Server - OS: UNIX, NT
New solution 132157 to be publised

SQL 2000 SP3 comes with MDAC 2.7 SP1. Reverting back to the previously installed MDAC version solves this problem.

The following link explains how to do that:
http://msdn.microsoft.com/library/de...dacinstall.asp

Regards
__________________
Ramiro Burbano
Reply With Quote
  #7  
Old 30th January 2003, 20:50
astrom astrom is offline
Newbie
 
Join Date: May 2002
Location: Sweden
Posts: 2
astrom is on a distinguished road
Baan: IVc4 - DB: MS-SQL 2000 Std - OS: Windows 2000
Thumbs up Thanks for the help

This solved my problem and the system is back to normal performance.
Reply With Quote
  #8  
Old 31st January 2003, 23:10
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 517
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
Does anybody know if I can apply SP 3 without upgrading MDAC?

Thanks
Reply With Quote
Sponsored Links
  #9  
Old 31st January 2003, 23:14
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
I don't think so. Installing SQL Server 2000 SP3 installs MDAC 2.7 SP1 without asking. See the now released solution 132157 for the short term fix.
Reply With Quote
  #10  
Old 31st January 2003, 23:24
benkoolstra benkoolstra is offline
Junior Member
 
Join Date: Aug 2002
Location: Bennekom, Netherlands
Posts: 12
benkoolstra is on a distinguished road
Baan: Baan 4C4 SP7 - DB: BISAM - OS: HPUX11.00
SQL 2000 SP3

I find it strange that a company like Baan is not testing their software with Service Packs from SQL. The first beta of SP3 was released 04-11-2002 !!!.

Ben Koolstra
Reply With Quote
  #11  
Old 31st January 2003, 23:57
Ramiro's Avatar
Ramiro Ramiro is offline
Junior Member
 
Join Date: Nov 2001
Location: Grand Rapids - MI - USA
Posts: 10
Ramiro is on a distinguished road
Baan: Baan IV, Baan ERP V - DB: Informix, SQL-Server - OS: UNIX, NT
SP3 was just released last week

SP3 wasn't released several months ago as you said.
In the final versions they can include other components, like in this case.
As stated in Microsoft Security Bulletin MS02-061, in the Technical Details Section:

Technical description:
Microsoft originally released this bulletin and patch on October 16, 2002 to correct a security vulnerability in a SQL Server stored procedure. The patch was and still is effective in eliminating the security vulnerability, and includes the fix for the vulnerability exploited by the "Slammer" worm virus (Note: Slammer affects only SQL Server 2000 and MSDE 2000). However, while the patch was fully effective in eliminating the security vulnerability, in October, 2002, it was found to interfere with SQL Server operations under some circumstances. As a result, on October 30, 2002, an additional non-security hotfix (317748) was required to ensure normal operations of SQL Server.

Microsoft released SP3 just last week. Included in this SP it was the hotfix for the security vulnerability, but also, it was included the SP for MDAC 2.7. Microsoft adviced everybody to install SP3 instead of installing just the fix.

Evidently, something has changed between MDAC 2.7 and MDAC 2.7 SP1.

It seems that Microsoft will have to release an additional non-security hotfix again, to solve the performance problem introduced in MDAC 2.7 SP1.
__________________
Ramiro Burbano
Reply With Quote
  #12  
Old 1st February 2003, 00:18
dedwards45's Avatar
dedwards45 dedwards45 is offline
Junior Member
 
Join Date: Feb 2002
Posts: 6
dedwards45 is on a distinguished road
Baan: 5.0c - DB: SQL Server 2000 - OS: Windows 2000 Advanced Server
Missing the point

I think the point being made here is that Baan should be more proactive in testing service packs / hotfixes instead of being reactive and causing a lot of customer frustration.
Reply With Quote
  #13  
Old 1st February 2003, 00:22
Ramiro's Avatar
Ramiro Ramiro is offline
Junior Member
 
Join Date: Nov 2001
Location: Grand Rapids - MI - USA
Posts: 10
Ramiro is on a distinguished road
Baan: Baan IV, Baan ERP V - DB: Informix, SQL-Server - OS: UNIX, NT
In case you haven't installed SP3

Do not install SP3, yet. Wait until the new fixes.

Check the following links:

http://www.microsoft.com/technet/tre...ts/slammer.asp

and

http://www.microsoft.com/technet/tre...n/MS02-061.asp


remain in SQL-Server 2000 SP and install just the fix 317748


Regards
__________________
Ramiro Burbano
Reply With Quote
  #14  
Old 1st February 2003, 00:23
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
I agree. Baan seem very reactive. To find out whether a SP is supported you need to raise a case with Baan support. Why is this? Why is the status of support for a service pack not public information? Can't Baan say if a SP is Supported, Unsupported, or still under test ?
Reply With Quote
  #15  
Old 1st February 2003, 14:54
benkoolstra benkoolstra is offline
Junior Member
 
Join Date: Aug 2002
Location: Bennekom, Netherlands
Posts: 12
benkoolstra is on a distinguished road
Baan: Baan 4C4 SP7 - DB: BISAM - OS: HPUX11.00
Ramiro,

What I meant is the first beta release of the SP which was made available to testers 04-11-2002. I would assume that Baan would also have access to these beta releases and test them against their software.

Ben
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
Problems deleting records with dynamic sql monica1 Tools Development 4 24th September 2004 13:37
Baan Oracle* Driver Performance Problems pshaw1 Performance & Tuning 7 25th February 2004 16:27
BaaN IV / SQL 2000 Performance tuning amolrp Operating Systems & Databases 2 27th August 2003 16:58
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 14:11


All times are GMT +2. The time now is 02:42.


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