Bit of background – My client uses an internal Certificate Authority for SSL certificates.
Due to the delay in getting the SSL certificates, I created and used self-signed certificates and documented and advised the client to update the SSL certificates once they receive the “real” certificate.
row *************************** Id: 7929352 User: system user Host: db: NULL Command: Connect Time: 69899 State: invalidating query cache entries (table) Info: NULL replication shows Seconds_Behind_Master: 70429 Once the invalidating query cache entries (table) process has finished the slave catches up.
How to repeat: I believe this might have something to do with row based replication of large tables.
I was quite puzzled at this point and decided to check if I can still access Adxstudio Portal site from within Dynamics 365 (CRM) server.
For a much better view of the Windows XP Filesystem Cache - try ATM by Tim Murgent - it allows you to see both the filesystem cache Working Set size and Standby List size in a more detailed and accurate view.You may have noticed that the DATAID column values in CACHEIVL do not always exactly match the dependency IDs that are present in the cache monitor.Take for example this entry in the cache monitor: You may notice that this CACHEIVL record does not match any of the dependency IDs that are listed in the Cache Monitor for this particular catalog entry cache.When Dynacache Invalidation runs, the following CATENTRY invalidations will be processed from this CACHEIVL row: You may see more dependency IDs being invalidated, but in this example I am using reduce Invalidation Ids on this site.In part 1 of this series we explored ways to extract undocumented packages, hints, utilities and executables from Oracle.