Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DBCC Tune(DES_BIND) determining the correct objects

Guys,

Much has been written about the value of DES_BIND...

In regards to relatively current versions of ASE (15.7 sp(60,104,12x,13x) or 16.0sp ???)

Which MDA columns should be evaluated when picking objects for DES_BIND Tuning?

(I realized good testing should be done,too)

I have heard of three columns as candidates in monOpenObjectActivity...

Operations

UsedCount

LogicalReads

I have also heard of a column in monCachedProcedures...

PlanID

What formula should be used for picking objects for DES_BIND Tuning?

Cory Sane

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question