How can we find out CPU utilization at query level (which query is
using how much % of CPU ) when multiple queries are running in
parallel.. against DB2 database on AIX. Is there any utility, tool,
method in DB2 itself which can be used for this OR is there any third
party tool, utility which can be used ?
- Sam
3  2033 
On Feb 7, 11:36 pm, "Sam Durai" <reachsamdu...@ gmail.comwrote:
How can we find out CPU utilization at query level (which query is
using how much % of CPU ) when multiple queries are running in
parallel.. against DB2 database on AIX. Is there any utility, tool,
method in DB2 itself which can be used for this OR is there any third
party tool, utility which can be used ?
- Sam
How about Query Patroller.
You can determine the query cost with that.
Swami
On Feb 7, 11:36 pm, "Sam Durai" <reachsamdu...@ gmail.comwrote:
How can we find out CPU utilization at query level (which query is
using how much % of CPU ) when multiple queries are running in
parallel.. against DB2 database on AIX. Is there any utility, tool,
method in DB2 itself which can be used for this OR is there any third
party tool, utility which can be used ?
- Sam
We were facing the same problem in our production environments. But we
have overcome the issue!!
You can create event monitors for statements and then get the CPU
"time". Those when compared relatively will give you an approx picture
of which query is taking how much CPU and then tune those queries
accordingly.
Saurabh
Sam Durai wrote:
How can we find out CPU utilization at query level (which query is
using how much % of CPU ) when multiple queries are running in
parallel.. against DB2 database on AIX. Is there any utility, tool,
method in DB2 itself which can be used for this OR is there any third
party tool, utility which can be used ?
- Sam
Perhaps this utility might help you: http://members.tripod.com/chuzhoi_files/index.html
Note that it is not an official one. The same might be accomplished
using some monitors.
Regards,
Michael This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Patrick Moore |
last post by:
We have a SQL 7.0 Standard Server running on a Windows 2000 Server
machine with 2 800mhz Pentium III with 2GB memory. Our front end is
Access 97 and 2000 with most ADO connections for the scripts but some
DAO for forms and reports. We recently "released" a new version of
the "database" that caused a catastrophic event to start happening
with our SQL server.
Using PerfMon we monitored the CPU utilization on the server and
noticed that...
|
by: Dathon |
last post by:
I have a Windows service that's built with .NET. The process is meant to run
in the background and not suck up too much CPU time. I set the thread
priority for the various threads in the service to Below Normal, but I'm
still getting reports that the service is making a noticable impact on
overall machine performance.
I stuck some Thread.Sleep calls in a various places in the code, but that
doesn't help much, since the service makes...
|
by: Simon Sadedin |
last post by:
Folks,
I’m hoping someone can give me some pointers to resolving an issue with postgres and it’s ability to utilize multiple CPUs effectively.
The issue is that no matter how much query load we throw at our server it seems almost impossible to get it to utilize more than 50% cpu on a dual-cpu box. For a single connection we can use all of one CPU, but multiple connections fail to increase the overall utilization (although they do...
|
by: john |
last post by:
I don't want to know what the CPU utilization is right now. I want to
get the average utilization over the last, for example, hour. So I
came up with a method where I would get a Process object representing
the "Idle" process. I would figure out what percentage of time the
idle process has been running since my function last was called. Then
the average CPU utilization would be 100 - average idle percentage. I
figure out the average idle...
|
by: bimalendug |
last post by:
Hi All,
I'm using the .NET performance counters to calculate the network
utilization. But this value exceeds 100%.
In most of the cases, it is very similar to the one shown in the
task-manager. But when I try to measure the network utilization with a
particular utility that sends large data, then the values that I get
exceed 100%. Even in the task-manager it shows similar graph (graph
goes up above the 100% line and disappears and then...
| | |
by: reachsamdurai |
last post by:
Hello, I'm looking for a method to check the utilization of index by
any SQL (Static and Dynamic) at the database level instead of
generating the access plan for each SQL.
I have inherited a database where index occupies more space than the
data and most of the indexes are looking redundant to me hence I would
like to check each index utilization and drop the same if it is not
used.
Env: DB2 UDB 8.2 /AIX 5.3
|
by: Pawan.Ghildiyal |
last post by:
Hi everybody
As we know that replication process uses 3 threads-
1. Master thread (Binlog Dump)
2. I/O thread
3. Sql Thread
Now I have some confusion regarding these thing --
- In peek hours what will be the cpu and memory utilization of these
threads
|
by: PRR |
last post by:
with WMI class
Win32_Process
i can get most details of Processes running one Pc.. except CPU utilization...
THe class for CPU utilization u need to use
Win32_PerfFormattedData_PerfProc_Process
However it doesnt work in Windows XP... i wanna know wat class to use to get CPU utilization in win xp... also Processid is to be compared to get CPU utilization for Process to get info from both classes?
|
by: Kaheru |
last post by:
memory utilization increase?
This is because when i try to keep track of the CPU utilization and memory utilization of my FTP server process (ftpserver.exe), the CPU utilization increase, but the memory utilization decrease. Why is this happening?
PS:
CPU Utilization is taken from Process\% Processor Time
Memory Utilization is taken from Process\Working Set (I want to measure the physical memory it uses)
Any help is appreciated....
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
