#DateWhereItemComment
1428 Dec 2013 @ 04:57 PSTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Hi Geeta This can be done using existing workload analysis. Please find the steps below. 1. Enable the DBQL with details Log option for the period you feel suitable to represent your workloads. O...
1327 Nov 2013 @ 01:06 PSTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Very much correct. Please rerun the DIPTDWM to fix this problem. Please play with Existing workload analysis feature to define workloads for new 10 users. Save the changes in your ruleset. Please r...
1227 Nov 2013 @ 11:24 PSTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Ohh! You are using new workload recommendations. I am not sure why you are using this option when you have already ruleset active and running. 'New workload recommendations' feature can be used onl...
1127 Nov 2013 @ 10:20 PSTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down 1. FinalWDId should be some number. Should not be string. If some name than it is dbql bug. 2. Cat3 means workload definition. 3. When you deactivate the workload definition rules then queries wi...
1027 Nov 2013 @ 09:30 PSTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down In Existing Workload Analysis, you not supposed to get unassigned requests. All requests are must be part of some workloads including default workload if TASM enabled. This case only arises when yo...
926 Nov 2013 @ 10:13 PSTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Hi Geeta, This is problem with your TDWM database setup. TWA is using some macros to save the ruleset which are missing in your TDWM database. Please rerun the TDWM dip script to creates the TWA m...
827 May 2013 @ 03:45 PDTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down This problem nothing related to Virtual (TD Express) or non-virtual database. The Dip Script did not run correctly on your system. Due to this, sys_calendar.calendar table is empty and Join with th...
708 May 2013 @ 01:15 PDTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Hi,   There is no differance between Date Range 1st April-30th April or 23rd April--30th April if data was logged only 23rd April onward.   I feel some problem with your data dictiona...
602 May 2013 @ 01:08 PDTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down This message is displayed only when TWA did not found any accounts in DBC.DBQLogTbl for given Date Range i.e. if you were logged the DBQL data say for 04/28/2013 to 04/30/2013 and provided the DBQL...
530 Oct 2011 @ 09:40 PDTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Hi Karam, This is problem with TWA 12.0 with latest TD12.0 database. TD 12.0 did some changes for aggregate queries which trigger TWA query to fail with 3504 error. We have fixed this issue in TW...
430 Oct 2011 @ 08:47 PDTToolsAdvanced Concept for Workload Analyzer (TWA) - Workload Drill-Down Let me know what TWA version (patch version number) are you using? What is DBS version (i.e. full DBS version)?
313 Jul 2010 @ 11:05 PDTToolsEasy Statistics Recommendations - Statistics Wizard FeatureThe thumb rule is to recollect the statistics when data changes for table minimum 10 percentages. You have to recollect statistics on column based on data changes in table. However, you can recomm...
230 Jun 2010 @ 09:57 PDTToolsEasy Statistics Recommendations - Statistics Wizard FeatureAgree with Dave. There are recommendations based on general Statistics rules. You must apply only the once that add value. Statistics Wizard also recommended workload based Statistics recommenda...
110 Jun 2010 @ 10:28 PDTToolsCapture and compare plans faster with Visual Explain and XML plan loggingJust try this out. Connect to DBS 13.10 latest. QCD setup is not needed for XML DBQL plan. Captured the plan in DBQL in XML and browse and open the plan form VECOMP for analysis. You can also ca...