CPU utilization by a certain query

Sam Durai

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

Feb 7 '07 #1

Subscribe Post Reply

2017

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

How about Query Patroller.
You can determine the query cost with that.

Swami

Feb 7 '07 #2

spider007

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

Feb 8 '07 #3

Michael Rudolph

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

Feb 8 '07 #4

Similar topics

SQL CPU Utilization goes to 0

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...

Microsoft SQL Server

How to limit CPU utilization in .NET app?

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...

.NET Framework

poor cpu utilization on dual cpu box

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...

PostgreSQL Database

Can I use the "Idle" process to figure out why my processor utilization has been?

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...

C# / C Sharp

.NET performance counters showing more than 100% network utilization

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....

ASP.NET

Index Utilization at Database level

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...

DB2 Database

Replication: Cpu and Memory utilization of threads

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...

MySQL Database

C#: wmi CPU utilization

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 ...

.NET Framework

Windows process CPU Utilization and Memory Utilization

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...

Microsoft Windows

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA