Marlon

v9.61 is now out on the PROIV website which, PROIV say, fixes the WITH (NOLOCK) issue.

As a matter of interest, would you be experiencing locking issues here because you are not using row versioning?

 

(IIRC, row versioning a.k.a. MVCC is an optional thing in SQL/Server, unlike Oracle, Postgres and MySQL/InnoDB)

Interesting question.  I'll ask the customer what they're doing.  However, as PROIV have made no mention of this and have said they're putting back the auto-insert of WITH (NOLOCK), I suspect it's not relevant.

You can find the v9 documentation on-line.

It's pretty dreadful, though, in relation to the new dashboard.  There's nothing to tell you which dashboard setting relates to which v8 .ini setting and vice versa.

Hi Marlon

 

Is SQL_NOSIG enabled in your v9 configuration?

 

 

Regards

Hi Neil,

I don't know.  The PROIV v9 help only tells you what the equivalent is, proiv.virtualMachine.database.driver.general.enableSQLAlarm, not where to set it so I don't know what we have. (To say I'm not enamoured with the v9 help would be an understatement).

Re SEL-RANGE not working with SEL-RANGE(var1 + var2 etc.), that's not a bug, it's a feature.  PROIV is full of features!

We don't use SEL-RANGE any more as we are totally Oracle/SQLServer, we also use FFSQL in the selection logic.