Kronos: One Server or Two?

This is another “Best-of” reposting from our older website. I should add an clarification that by “server” we mean physical boxes and not virtual machines on the same physical server. The original post is here. Here is an easy-to-implement suggestion to optimize your setup right out of the gate: SQL Server runs best on a computer…

0

Kronos: Fifth Third Bank managing 21,000 employees on SQL Server

Fifth Third Bancorp is one of the largest banks in the U.S. with over $111 billion in assets and operates in the mid-west. Fifth Third is using Kronos’ managed services with full hosting based on Microsoft SQL Server to support 21,000 employees in 12 states at over 1200 locations. The following solutions will be running on SQL Server: time…

0

Kronos: Scalability Whitepaper for SQL Server 2005

I have been going though posts on our old blog to select a few “Best of” repostings. While SQL Server 2008 R2 is clearly the best choice, with some recent studies suggesting a 10% performance improvement over SQL Server 2005, often corporate policy may not allow its selection. The white paper may be downloaded from here. SQL Server: The Scalable,…

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

Kronos: Improving the performance of ad-hoc reports up to 3600%

One of Kronos’ features is the ability to build ad-hoc reports. With SQL Server, the ability for a power-user to generate almost any type of report exists. The issue often arises that while you get your report — eventually; the performance time is not ideal.  One part of the solution is the use of read-committed snapshot…

0

Kronos: Oracle to SQL Server Migration – The Clock – Part 4

[Prior Post in Series] A reader sent an email asking how long does migration take. A good migration consists of at least three passes: Prototype migration: the purpose is to learn the steps required for your migration. Discover and resolve unexpected issues. The outcome should be a checklist of what should happen for the migration….

0

Kronos: Oracle to SQL Server Migration – SQL Server Agent hiccup – Part 3

[Prior Post in Series]    [Next Post in Series] In our prior posts we described some of the human-ware issues encountered dealing with the degree of access that Javed Iqbal, a Kronos employee and migration expert, was granted. Javed is using SQL Server Migration Assistant for Oracle (SSMA4O) version 4.2. During the Krono migration, Javed encountered…

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

Kronos: Oracle to SQL Server Migration – Performance – Part 2

Author: This article is written by our contributing author Ken Lassesen. His bio can be found here [Prior Post in Series]    [Next Post in Series] This is part of the post-arc started by this overview of Migrating from Oracle to SQL Server, and deals with experiences with Kronos migrations. Javed Iqbal, a Kronos Migration specialist…

3