One of my collegues tells me that Event Monitors can be used to
understand how much time the application has spent in the database, in
the application, for IO, CPU utilization etc.
I have 'googled' and read a few articles , but still not very clear .
In SQL and Transaction snapshots, some values indicate the total
elapsed time and the total CPU time ? Are these the values to use ? If
yes, how to calculate the values ?
Please guide me
TIA
Victor
4  1491 
No one knows ??????
Vic vi*********@btinternet.com (Victor Reed) wrote in message news:<cb*************************@posting.google.c om>... One of my collegues tells me that Event Monitors can be used to
understand how much time the application has spent in the database, in
the application, for IO, CPU utilization etc.
I have 'googled' and read a few articles , but still not very clear .
In SQL and Transaction snapshots, some values indicate the total
elapsed time and the total CPU time ? Are these the values to use ? If
yes, how to calculate the values ?
Please guide me
TIA
Victor
No one knows ??????
Vic vi*********@btinternet.com (Victor Reed) wrote in message news:<cb*************************@posting.google.c om>... One of my collegues tells me that Event Monitors can be used to
understand how much time the application has spent in the database, in
the application, for IO, CPU utilization etc.
I have 'googled' and read a few articles , but still not very clear .
In SQL and Transaction snapshots, some values indicate the total
elapsed time and the total CPU time ? Are these the values to use ? If
yes, how to calculate the values ?
Please guide me
TIA
Victor
Victor,
I think this is the time referred to. The difference between eleapsed
time and CPU time should be the sum of all waits, including I/O and
multi-threading.
To the best of my knowledge (I'm no expert in this though) there are no
separate counters to measure only I/O time. That woudl be expensive to
collect.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Victor,
I think this is the time referred to. The difference between eleapsed
time and CPU time should be the sum of all waits, including I/O and
multi-threading.
To the best of my knowledge (I'm no expert in this though) there are no
separate counters to measure only I/O time. That woudl be expensive to
collect.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: aa |
last post by:
I am migrating to PHP from ASP where there are the Application Scope variables which are accessible from any page on a website and which are used, in particular, for hit counters.
Is there a similar...
|
by: Mark Fisher |
last post by:
I have a Java desktop GUI application that the user can run multiple
times. In order to keep one instance of the application distinct from
another, I'd like to put the instance number of the...
|
by: Ullas Chadaga |
last post by:
Hi,
Is it possible to develop a .Net app that can monitor response times of
other windows applications (not necessarily developed in .Net) running on the
same PC?
If yes, what would be the...
|
by: VinnieT |
last post by:
I have a load balanced system that consists of 3 production servers. There
are about 20 different applications that are used on these boxes. One of my
applications in particular is used more than...
|
by: Jake |
last post by:
Hi, I originally posted in the db group but thought this might be more
appropriate here.
I have a scheduling application which allows the user to reserve timeslots
for various things but I'm...
|
by: Steven Cool |
last post by:
Hello,
This topic has been 'topic' for several times in this Newsgroup. I
have made an application which use a to c++ dll's (unmanaged), a
managed dll and a c# application. When I run the...
|
by: Chase |
last post by:
I'm pretty new to asp.net and am having problems with my application timing
out.
I've written an application that loops through all of the information on an
excel spreadsheet and does certain...
|
by: Alan Foxmore |
last post by:
Hi Everyone,
I'm new to ASP.NET so maybe this is easy. I'm using ASP.NET 2.0.
I'm finding that the Application object (the HttpApplicationState
object) is allowing me to add the same key...
|
by: jeff |
last post by:
Hi All.
I realize that when my Deployed winforms application starts, Windows needs
to load the .net 2 framework before control is given to my application....
Is there anyway to either ...
-...
|
by: Kristijan Marin |
last post by:
Hi,
I have experianced same wierd behavior by one of my customers .....
Here is the thing .... We have the application for newspaper article
management. so adding end editing etc ....
After...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
|
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,...
| | |
