About kevin_sherlock

kevin_sherlock · 12-11-2015

Timestamp WaitEventID Descr Waits WaitTime 10:36:40 29 waiting for regular buffer read to complete 111 500 10:36:40 52 waiting for i/o on MASS initated by another task 12...

kevin_sherlock · 10-01-2015

Anyone out there able to start ASE Cockpit using: Adaptive Server Enterprise/16.0 SP02 GA/EBF 24951 SMP/P/x86_64/Enterprise Linux/asecorona/2424/64-bit/FBO/Tue Aug 11 05:28:54 2015I can't get an instance started, getting this (partial) output in the ...

Expectations of Expected Row Size · 05-11-2015

I should have written something down about this 3 years ago. That's when I made a comment to a friend at the ISUG Tech conference that expected_row_size isn't exactly what you might think it is. In fact, even if you set it to it's maximum allowabl...

kevin_sherlock · 02-18-2014

WHAT I'M TRYING TO ACCOMPLISHI've been playing around with the concept of trying to capture some optimizer diagnostics with the tools provided in ASE 15.7. Specifically, the showplan_in_xml() builtin function. In theory, this can allow you to prog...

Remediation for Moderation Frustration · 06-19-2013

A very smart colleague of mine from TeamSybase, Bruce Armstrong posted a very good doc - http://scn.sap.com/docs/DOC-42937 in the PowerBuilder space on overcoming the moderation issues some of us who are new to SCN are having. Check it out! Thanks ...

kevin_sherlock · 02-23-2018

FWIW, I am able to reproduce the error you see, but also noticed that you were led to the LANG env variable solution, which also tests out for me (unset LANG, and all is well). Copy stats is a great application of the code, and again, I admire and ...

kevin_sherlock · 01-18-2018

Hello Raymond, I really appreciate all the work you have contributed to sp__optdiag recently! Really cool stuff. It was always a goal of mine to maintain only one version of the proc that would run on all versions of 15.x, 16.x etc, but that turned...

kevin_sherlock · 11-17-2016

Agreed. My only guess is that it is because this feature was NOT borne from a specific SAP product requirement. I know from the many past Techwaves, ISUG conferences, etc that this feature has been begged for over and over. Many recent feature enh...

kevin_sherlock · 11-16-2016

Table variables, and table based UDF's are a complete grease fire at this point. I would never recommend their use for anything other than non-production use

kevin_sherlock · 11-04-2016

Raymond,Thanks for your work on sp__optdiag. As Mark points out, this forum is no longer useful for exchange of sharing experience with ASE. I"m no longer contributing to SCN after the really pointless and awful changes made to this platform (this...

User Statistics

User Activity

What am I waiting for again?

ASE Cockpit Problems on Linux

Expectations of Expected Row Size

Capturing Optimizer Diagnostics (internally), ... almost there

Remediation for Moderation Frustration

Re: optdiag in ASE 16.0 SP03 PL02/EBF 27415 on Linux appears to be broken

Re: optdiag in ASE 16.0 SP03 PL02/EBF 27415 on Linux appears to be broken

Re: Table variables don't work with deletes ?

Re: Table variables don't work with deletes ?

Re: sp__optdiag for ASE 15+ / 16