#DateWhereItemComment
14525 Mar 2016 @ 11:17 PDTcarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeCarrie, I am seeing both the documentation and the view definitions reflecting the units as "centiseconds" in 14.10.  That is where exactly my confusion began. I am sending the d...
14421 Mar 2016 @ 02:01 PDTcarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeThank you for your comments Carrie, On my 2nd question, here is what i am trying to understand. Until 13.10 Version,  I used to see the CPUTime column result in Milli seconds (which is also ...
14317 Mar 2016 @ 04:08 PDTcarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeHello Carrie, Recently, I have noticed the CPUTime Column is not available on 14.10 ResUsageSPS table (which was there in 13.10 SPS Table).  Please have a glance on my understanding is ...
14222 Feb 2016 @ 06:35 PSTViewpointAn Overview of the new Viewpoint 15.11 DashboardNice article. From the Viewpiont 15.10 version, via Alert Viewer portlet we cannot go back more than "Last 1 Week". Is that limitation still applicable in 15.11 version? And is the...
14108 Nov 2015 @ 09:25 PSTcarrie's blogSpecial Treatment For Users DBC and TDWMThank you for the advice.
14003 Nov 2015 @ 08:08 PSTcarrie's blogSpecial Treatment For Users DBC and TDWMhi Carrie, I am trying to see the feasibility of defining the PROFILE for the system ids like DBC,TDWM,Crashdumps,Systemfe,SysAdmin,LockLogShredder...etc. As you said for DBC being a super-user ...
13902 Nov 2015 @ 06:22 PSTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadGreat, thank you.
13802 Nov 2015 @ 01:59 PSTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadGood to know this.Thank you. Are there any other statements applicable for falling always in SessionWDID? I think there are few other statement types where they consume 0 CPU, just wanted to know...
13730 Oct 2015 @ 12:25 PDTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadHi Carrie, Today i noticed an interesting case where SessionWDID=WDID=FinalWDID=Same Workload id number. We have parser only workload, let us say the WDID of PARSER-only workload=1. For one o...
13626 Oct 2015 @ 09:50 PDTDatabaseTeradata Virtual Storage: The new way to manage Multi-Temperature dataThank you.
13524 Oct 2015 @ 10:27 PDTDatabaseTeradata Virtual Storage: The new way to manage Multi-Temperature datahello Mark, we have EDWs for PROD systems and Appliances for NON-PROD systems (Dev/Test..). I was comparing the TVS options (from ctl--->tvs switch=on). For the PROD systems we have  &quo...
13406 Oct 2015 @ 03:12 PDTDatabaseTo Peek or Not to Peek, That is the Question Hello Carrie, I am seeing lot of EMPTY SPACES in the CACHE FLAG field. I understood that we cannot do anything if the queries are non-parameterized. Do you think too many empty spa...
13301 Oct 2015 @ 06:13 PDTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadThank you. With that classification on all the users (via Profile*), we are seeing multiple issues (like same session id using POW and other Workload for parsing phase under SESSIONWDID), working ...
13221 Sep 2015 @ 11:02 PDTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadCarrie, Finally the criteria below making the POW to be recorded in SessionWDID. And I am trying to understand the extreme impact of including PROFILE *. We have every user on the system assigned ...
13117 Sep 2015 @ 05:01 PDTcarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadActually, we tried this criteria (where we used exactly same dummy characteristics as shown in your screenshot) on only single UserID which was reporting higher Parser Time. But it was not making u...
13016 Sep 2015 @ 06:36 PDTcarrie's blogA Closer Look at How to Set up a Parsing-Only Workload Hi Carrie,   We recently introduced the PE-Only Workload (POW) on a special system (14.10+SLES10) to have all user PE-work  to be classified into that POW.  ...
12917 Jul 2015 @ 03:07 PDTViewpointOverview of Teradata Viewpoint 15.10Thank  you for patiently answering my questions.
12816 Jul 2015 @ 06:38 PDTViewpointOverview of Teradata Viewpoint 15.10We are not following the TD recommended Queryband for the applications, rather we have part of the queryband for specifying the Application Name, and for Viewpoint we did not define any queryband a...
12716 Jul 2015 @ 02:34 PDTViewpointOverview of Teradata Viewpoint 15.10Shrity, If i do not set up a specific QUERYGROUP for each application, i cannot make use of APPLICATION QUERIES portlet based on the APPID of each application that is available in DBQL? Becuase...
12615 Jul 2015 @ 04:53 PDTViewpointOverview of Teradata Viewpoint 15.10Got it. So the sample rate of the sessions data collector is the sample rate of SNAPSHOT INFO. Thank you for the quick answer.
12515 Jul 2015 @ 11:02 PDTViewpointOverview of Teradata Viewpoint 15.10Shrity, Regarding the SNAPSHOT INFO section in QueryMonitor/MYQueries, it gives us the session details in last sampling period, sampling period means for last 600 seconds OR for how much time it ...
12413 Jul 2015 @ 10:20 PDTViewpointOverview of Teradata Viewpoint 15.10Yes, we do have PDCR. I will raise this GSC, but before that I just wanted to make sure to the driver supportability in terms of the version. Do we need to have JDBC 15.10?
12312 Jul 2015 @ 11:48 PDTViewpointOverview of Teradata Viewpoint 15.10Shrity, I was trying to access the Query Log portlet, but it is showing No Data Available, after checking the QueryLog Data Collector, I've noticed that there are no enough rights (Error Chec...
12230 Jun 2015 @ 12:27 PDTViewpointTeradata Alerts (CAM) 14.10 ReleaseGood to know that. Thank you.
12128 Jun 2015 @ 09:40 PDTViewpointOverview of Teradata Viewpoint 15.10Hi Shrity, I saw the issue when the system was is busy. But apart from the credentails are wrong fo the ID that you are using, it is also possible to see this error if there are any potential ...

Pages