Pick out your favorite sound bites,
47 hours down to 30 seconds doesn’t suck:
The Results
One critical operation for FSA is month-end processing.
“We’re under a tight
deadline to close our books,” explains Morales. “We need
that overnight process
to run successfully and accurately. When the overnight run
had problems, the
next day we would have to do a manual workaround. That
could take 20 man
hours or more. We’ve eliminated that cost with Symantec
Indepth for Sybase.”
In one case, a critical batch job — a scenario analysis
needed by a unit managing
a specialized investment portfolio — took 47 hours to
complete and had to be
run over the weekend. Using Precise i3 for Sybase,
Morales’ team identified
some Sybase maintenance routines that were not running.
They also found that
the data was not indexed optimally, and corrected that
problem. Morales credits
Soaring Eagle with recommending a different indexing
strategy. “When you can
identify the long-running SQL, it’s a simple matter to
optimize it or reselect
indexes. The trick is finding it in the first place,” says
Garbus.
The result was staggering: The job completed in just 30
seconds, a 99.98 percent
improvement. “We run it many times a day now,” says
Morales. “So that team
can try multiple what-if scenarios and have a high degree
of confidence about
portfolio performance.”
Overall, Precise i3 for Sybase has made a significant
contribution to FSA’s
performance. “We’ve improved performance an average of 20
percent for
several dozen applications,” says Morales. “And on the
development side, our
DBAs are now more proactive. They can test multiple
scenarios and identify
performance problems before they reach production. That
feedback is very
helpful to application developers as well.”