Benchmark Test Results: SQL Server Provides Performance, Scalability, and Value for RedPrairie’s Parcel

A team of engineers from RedPrairie and Microsoft worked together to test the performance and scalability of RedPrairie’s Parcel on Microsoft SQL Server 2008 R2 and the Windows Server 2008 R2 operating system. Tests were also run on a pre-release version of SQL Server 2012, SQL Server Denali CTP3. The team designed a benchmark study to emulate a…


Benchmark Results: RedPrairie Commerce Suite running on SQL Server 2008 R2

The RedPrairie Commerce Suite delivers an integrated shopping experience on the web, in stores, on mobile phones, on Facebook, and anywhere else consumers choose to interact with their favorite retail brands. Using Microsoft SQL Server as a database platform with industry-standard hardware provides the performance and scalability retailers need at a lower TCO than competing…

0

RedPrairie: Removing Unneeded Table Indices

By David Erickson, RedPrairie I wrote some internal notes to our developers recently, that I called “Lessons from the Lab”. I had the pleasure of joining RedPrairie’s WM Product Development team at a Microsoft testing lab in Dallas, Texas, with the intent of benchmarking WM 2009.2 and 2010.1 on SQL Server 2008 with various database configurations. …

2

RedPrairie: Improving performance by using Parallelism

By David Erickson, RedPrairie Most of you know that computer CPUs are not getting faster anymore, instead they are getting more cores. Microsoft SQL Server has two parameters that control whether work goes to one core or to many cores. I’d like to give a simple explanation of these two factors and share my experience…

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

RedPrairie: When cooking in almost 400 restaurants, SQL Server provides prompt service!

Culver Franchising Systems, Inc. has grown to 381 restaurants since 1984. RedPrairie’s Performance Management solution running on SQL Server has given CFSIbetter visibility into the performance of Culver’s restaurants and menu items. The impact on operations was more than just significant: “We were sold on the Performance Management solution when RedPrairie produced in 30 seconds a…

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