Hello All,

My company currently runs Baan 5c on a Windows/Oracle 10gr2 environment. We have over 5 years of production data and the size of tfgld418 is almost 10 million records. We were thinking of cutting over to a new DB our next fiscal year. I wanted to know if anyone here has had any experience running Baan on a SQL Server DB? I would like to know if there were noticible performance issues with a fairly large DB compared to an Oracle DB? If anyone has information to share, I would appreciate it. Thanks.

Frank

We do have 7 mil recs tfgld418 in SQL 2005 and the performance is good . Normally we make it a point to delete all not-for-fin trx regularly . I dont have performance related comparision on oracle vs sql .

Thanks for your reply Hitesh..

I was wondering if you could tell me how you have the SQL data configured? Is it across multiple drives? How many Baan companies do have in the DB? Thanks.

Frank

We have about 60 milion records in tfgld106 in a production company and about 150 milion in an archive company and Baan runs very well (Numbers in tfgld418 are more or less the same).
We have a dedicated database server with 4 processors and 20 GB of RAM running sql server 2005 (level 2 driver).
Although you should take a look at Infor documentation for tunning in sql server.
Regards

You can use filegroups to separate data accross different files/partions in a efficient manner using the storage file.

We have 4 company data with separate filegroups for test company and archieve company on quad core dedicated failover cluster with 8 gb ram (lvel 2 driver) . SQL requires log files to be stored on separate drive for better performance . Also u need to reserve separate drive for log / differential / full backups .

ttfgld418 for my production coy, i have around 4000000 record. i only use the default FILEGROUP.

i have done SHRINKFILE for the log every weekend to keep it low.