Ending Recurring Slowdowns With Tempdb & Cache Tuning
A manufacturing group's ASE 16 instance suffered a daily slowdown during shift-change reporting caused by tempdb contention and a shared default cache. Named-cache separation and tempdb resizing stabilized performance for good.
Read case study