C
cverbiest
Guest
I had to tweak the code a bit for client server (change the path to db log file) as the issue is only on client-server. I ran it twice, first for value 5 , then for value 1. Resrc Id Type Name Locks Waits Repeats Duration Program n B lruskips L lkhash Notes Progress Host Date 0 --- --- 0 0 1000000 ,14 c:\tmp\p45900_Untitled2.ped 113 1000002 0 150016 ? 11.6 FR-TS3 2016-07-12T12:05:28.881+02:00 0 --- --- 0 0 1000000 ,143 c:\tmp\p45900_Untitled2.ped 113 1000002 0 150016 25621 11.6 FR-TS3 2016-07-12T12:08:34.789+02:00 0 --- --- 0 0 1000000 ,148 c:\tmp\p45900_Untitled2.ped 113 1000002 0 150016 25621 11.6 FR-TS3 2016-07-12T12:11:17.357+02:00 This is on a test database copied from the production db. I did an index rebuild for all index of that table. => no effect I created a new table using the same schema and data => same issue on the new table
Continue reading...
Continue reading...