SQL 7 and BaaN

[jeffieboy]

We have just migrated from Informix DB to SQL 7 and are having performance issues. Speed of processes are cut by 75%.
Hardware = 4 way pentium pro 200 proc.,1.3 gig ram, raid 1 with 54 gig visibility. Win NT 4.0 SP 6a. Using BaaN 4C3, also on a similar box. Any suggestions would be a help. Thanks.

 

[tlbroadbent]

Generally, performance problems are due to poor application design and/or poor table indexing. As you can probably not modify the Baan design, you should focus on Indexing.

Check for indexes on the tables. You should have one or more indexes defined on each table. The indexes should be defined on columns referenced in query Where criteria. You can use SQL Profiler to help determine which columns are referenced.

For more information on indexing check the following sources.

Tips on Optimizing SQL Server Indexes

http://www.sql-server-performance.com/optimizing_indexes.asp

Tips on Optimizing SQL Server Clustered Indexes

http://www.sql-server-performance.com/clustered_indexes.asp

Tips on Optimizing Non-Clustered SQL Server Indexes

http://www.sql-server-performance.com/nonclustered_indexes.asp

SQL Server Index Tuning Wizard Tips

http://www.sql-server-performance.com/index_tuning_wizard_tips.asp

Getting The Best From The SQL Server Index Tuning Wizard

http://www.sql-server-performance.com/nb_index_wizard.asp

Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot