145 | 25 Mar 2016 @ 11:17 PDT | carrie's blog | Converting CPU Seconds, Old Node Type to New Node Type | Carrie,
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... |
144 | 21 Mar 2016 @ 02:01 PDT | carrie's blog | Converting CPU Seconds, Old Node Type to New Node Type | Thank 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 ... |
143 | 17 Mar 2016 @ 04:08 PDT | carrie's blog | Converting CPU Seconds, Old Node Type to New Node Type | Hello 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 ... |
142 | 22 Feb 2016 @ 06:35 PST | Viewpoint | An Overview of the new Viewpoint 15.11 Dashboard | Nice 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... |
141 | 08 Nov 2015 @ 09:25 PST | carrie's blog | Special Treatment For Users DBC and TDWM | Thank you for the advice.
|
140 | 03 Nov 2015 @ 08:08 PST | carrie's blog | Special Treatment For Users DBC and TDWM | hi 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 ... |
139 | 02 Nov 2015 @ 06:22 PST | carrie's blog | A Closer Look at How to Set up a Parsing-Only Workload | Great, thank you.
|
138 | 02 Nov 2015 @ 01:59 PST | carrie's blog | A Closer Look at How to Set up a Parsing-Only Workload | Good 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... |
137 | 30 Oct 2015 @ 12:25 PDT | carrie's blog | A Closer Look at How to Set up a Parsing-Only Workload | Hi 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... |
136 | 26 Oct 2015 @ 09:50 PDT | Database | Teradata Virtual Storage: The new way to manage Multi-Temperature data | Thank you.
|
135 | 24 Oct 2015 @ 10:27 PDT | Database | Teradata Virtual Storage: The new way to manage Multi-Temperature data | hello 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... |
134 | 06 Oct 2015 @ 03:12 PDT | Database | To 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... |
133 | 01 Oct 2015 @ 06:13 PDT | carrie's blog | A Closer Look at How to Set up a Parsing-Only Workload | Thank 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 ... |
132 | 21 Sep 2015 @ 11:02 PDT | carrie's blog | A Closer Look at How to Set up a Parsing-Only Workload | Carrie,
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 ... |
131 | 17 Sep 2015 @ 05:01 PDT | carrie's blog | A Closer Look at How to Set up a Parsing-Only Workload | Actually, 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... |
130 | 16 Sep 2015 @ 06:36 PDT | carrie's blog | A 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.
... |
129 | 17 Jul 2015 @ 03:07 PDT | Viewpoint | Overview of Teradata Viewpoint 15.10 | Thank you for patiently answering my questions.
|
128 | 16 Jul 2015 @ 06:38 PDT | Viewpoint | Overview of Teradata Viewpoint 15.10 | We 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... |
127 | 16 Jul 2015 @ 02:34 PDT | Viewpoint | Overview of Teradata Viewpoint 15.10 | Shrity,
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... |
126 | 15 Jul 2015 @ 04:53 PDT | Viewpoint | Overview of Teradata Viewpoint 15.10 | Got it. So the sample rate of the sessions data collector is the sample rate of SNAPSHOT INFO.
Thank you for the quick answer.
|
125 | 15 Jul 2015 @ 11:02 PDT | Viewpoint | Overview of Teradata Viewpoint 15.10 | Shrity,
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 ... |
124 | 13 Jul 2015 @ 10:20 PDT | Viewpoint | Overview of Teradata Viewpoint 15.10 | Yes, 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?
|
123 | 12 Jul 2015 @ 11:48 PDT | Viewpoint | Overview of Teradata Viewpoint 15.10 | Shrity,
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... |
122 | 30 Jun 2015 @ 12:27 PDT | Viewpoint | Teradata Alerts (CAM) 14.10 Release | Good to know that. Thank you.
|
121 | 28 Jun 2015 @ 09:40 PDT | Viewpoint | Overview of Teradata Viewpoint 15.10 | Hi 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 ... |