My ASE server (16.0 SP04 PL04) reports it's using about 22.4 gbytes of memory (value of "total logical memory"), but the total of the memory config options is much less than that:6.8 gbytes data cache configured0.57 gbytes of procedure cache configur...
We've been having some deadlock problems where we get deadlock messages like this in the ASE server errorlog file (note the shared/exclusive address locks): Deadlock Id 8827: Process (Familyid 0, Spid 278) was waiting for a 'shared address' lock at 0...
I wanted to experiment with Java in ASE (no extra license required for new versions of ASE)But when I tried to install a .jar file (containing a Java class) into ASE using the installjava utility, I got the error:The file '*.class' contained in the j...
There's been a long term trend for disks and disk controller to move to larger sector sizes (from 512 bytes to 4096 bytes):https://www.dell.com/support/kbdoc/en-us/000146908/why-4k-drive-recommended-for-os-installationWestern Digital’s Advanced Forma...
Looking at SAP Replication Server -> Replication Server Heterogeneous Replication Guide -> SAP Replication Products -> Enterprise Connect Data Access (ECDA)It says "Enterprise Connect Data Access (ECDA) products are Open Server-based software gateway...
I see this memory usage reported by monMemoryUsage:> select SizeMbytes=TotalSize/1024/1024, MemoryPoolName, PoolType, ConfigOption
> into #tmp
> from monMemoryUsage
go
> sp_autoformat "#tmp", "SizeMbytes,MemoryPoolName, PoolType, ConfigOption", null...
Here's a SAP Note about a similar behavior, but with cached statements (automatically precompiled SQL statements) instead of prepared statements: https://me.sap.com/notes/2077161/EQuery takes a long time to complete due to bad table scan when stateme...
Yo Mark, thanks for the "kudo" for this answer. It made me snicker. Especially since I got the notification email saying, "Mark_A_Parsons thinks your post is awesome and just gave you kudos!"
