Solution Brief: Lawson System Foundation Running on SQL Server

In August 2011, Lawson and Microsoft worked together to confirm the scalability and performance of Lawson System Foundation (LSF) 9.0.1 on SQL Server 2008 R2 Enterprise and Windows Server 2008 R2 Enterprise. Human resources, payroll, accounts payable, and general ledger application procedures were tested with up to 6,000 concurrent users. The results were very impressive,…

0

Benchmark Results: Lawson System Foundation Running on SQL Server

Lawson and Microsoft worked together on a series of benchmarking tests using Lawson System Foundation (LSF) 9.0.1 running on Microsoft SQL Server 2008 R2 Enterprise and Windows Server 2008 R2 Enterprise. The goal of the benchmark testing was to confirm that the LSF module running on the Microsoft platform can meet the demands of the…

0

Migration: The value gained moving from Oracle to SQL Server 2008R2

[DB2 Migration Value]  [Sybase Migration Value] In the early 1980’s I was an Oracle Developer on mainframes and on MS-DOS using Oracle 5.1 on MS-DOS (distributed on some 20+ diskettes — I still have them). It was an interesting time because PC products like dBase II were power-user friendly but did not scale. Oracle scaled, but was…

0

Migration: The value gained moving from DB2 to SQL Server 2008R2

[Oracle Migration Value]   [Sybase Migration Value] Two decades ago, I made my living as a DB2 developer working for GTENW (now Verizon). In this year’s spring-cleaning, I came across my old DB2 certificates; perhaps it is time to do a spring-cleaning of perceptions about DB2 and SQL Server. As a developer, I have become hopelessly biased for…

0

Lawson: S3 version 9.0 handles 256000 General Ledger Transactions with SQL Server taking a nap

I recently read a white paper on the performance of Lawson S3 Enterprise Management System running on SQL Server 2008 and was struck by the idleness of SQL Server in handling the type of load seen with large corporations. The SQL Server hardware used was approaching prosumer levels: 2 x Quad Code Processors (8 cores) 10 GB RAM…

0

Lawson: Support for Microsoft Platforms

I have listed below which Microsoft technologies are supported by Lawson M3 (7.1) and S3 (9.0) releases. Architecture Tier Product Operating System Client Microsoft Office 2003 SP3Microsoft Office 2007 SP1 Windows XP SP3 (32+64 bit)Windows Vista SP (32+64 bit)Windows 7 (32+64 bit)Windows Server 2003 (32+64 bit)Windows Server 2008 (32+64 bit)Windows Server 2008 R2 (64 bit) Database Server SQL Server 2005 with…

0

Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

 [Prior Post in Series]   [Next Post in Series] In my last post Fundamentals: Creating a Workload by Using a Trace Log, I illustrated how to create a workload. In this post, I will look at the complimentary step, using the log as input to the Database Engine Tuning Advisor to identify performance-improving indexes. This in-depth process takes some…

2

Fundamentals: Creating a Workload by Using a Trace Log

[Next Post in Series] This is the kick-off post of a regular Friday series of posts, “Basic Skills for SQL Server ISV Administrators”. I have found that ISV Administrators are often Professional Engineers (P.E.) — rich in business knowledge and light in Information Technology expertise.  In this series of posts, I will give visual step-by-step instructions on…

0

Best Practices Analyzer for ISV SQL Servers to protect your company’s property

The intellectual property(IP) or other valuable information may be stored on SQL Server in your ISV product. Its value is more than credit card records (credit cards can be cancelled if lost, IP can’t). It may be the equivalent of a state secret for your firm. Microsoft provides two versions of its free Best Practices…

0