Well folks, I didn't heed the warnings (that excessive monitoring,
statistics, etc. can cause a performance hit) and I have been playing
around with all kinds of monitors, snapshots, especially with the gui.
BUT! Performance has dropped 70%! The monitors show that the the most
system overhead is caused by these selects themselves.
Question 1: Is there a big red switch that turns OFF *all* of this type of
activity!
Question 2: If so, can I flip em all on again (just for temp test)?
I definitely need monitoring, but I guess I need to do it one at a time
and measure the impact of that monitor itself, before doing another.
Please advise. Thanks.
nat 4 1537
update the dbm cfg to turn off the monitoring...
ex:
update dbm cfg using DFT_MON_BUFPOOL off ...etc
use monitor switches for temp. monitoring, it will end once you
terminate your session.
ex:
update monitor switches using BUFFERPOOL on LOCK on SORT on STATEMENT
on TABLE on UOW on global;
natG wrote:
Well folks, I didn't heed the warnings (that excessive monitoring,
statistics, etc. can cause a performance hit) and I have been playing
around with all kinds of monitors, snapshots, especially with the gui.
BUT! Performance has dropped 70%! The monitors show that the the most
system overhead is caused by these selects themselves.
Question 1: Is there a big red switch that turns OFF *all* of this type of
activity!
Question 2: If so, can I flip em all on again (just for temp test)?
I definitely need monitoring, but I guess I need to do it one at a time
and measure the impact of that monitor itself, before doing another.
Please advise. Thanks.
nat
Besides monitoring is there other stuff? I am sure I told it to do other
fancy stuff, just don't remember what at this [nerve racking] moment.
Thanks.
On Wed, 23 Aug 2006 13:37:06 -0700, Raj wrote:
update the dbm cfg to turn off the monitoring...
ex:
update dbm cfg using DFT_MON_BUFPOOL off ...etc
use monitor switches for temp. monitoring, it will end once you
terminate your session.
ex:
update monitor switches using BUFFERPOOL on LOCK on SORT on STATEMENT
on TABLE on UOW on global;
natG wrote:
>Well folks, I didn't heed the warnings (that excessive monitoring, statistics, etc. can cause a performance hit) and I have been playing around with all kinds of monitors, snapshots, especially with the gui. BUT! Performance has dropped 70%! The monitors show that the the most system overhead is caused by these selects themselves. Question 1: Is there a big red switch that turns OFF *all* of this type of activity! Question 2: If so, can I flip em all on again (just for temp test)?
I definitely need monitoring, but I guess I need to do it one at a time and measure the impact of that monitor itself, before doing another.
Please advise. Thanks. nat
Fwiw, it seems like it was the STATEMENT monitor. Man, that accumulates
data!
-nat
On Wed, 23 Aug 2006 13:37:06 -0700, Raj wrote:
update the dbm cfg to turn off the monitoring...
ex:
update dbm cfg using DFT_MON_BUFPOOL off ...etc
use monitor switches for temp. monitoring, it will end once you
terminate your session.
ex:
update monitor switches using BUFFERPOOL on LOCK on SORT on STATEMENT
on TABLE on UOW on global;
natG wrote:
>Well folks, I didn't heed the warnings (that excessive monitoring, statistics, etc. can cause a performance hit) and I have been playing around with all kinds of monitors, snapshots, especially with the gui. BUT! Performance has dropped 70%! The monitors show that the the most system overhead is caused by these selects themselves. Question 1: Is there a big red switch that turns OFF *all* of this type of activity! Question 2: If so, can I flip em all on again (just for temp test)?
I definitely need monitoring, but I guess I need to do it one at a time and measure the impact of that monitor itself, before doing another.
Please advise. Thanks. nat
natG wrote:
Fwiw, it seems like it was the STATEMENT monitor. Man, that accumulates
data!
-nat
On Wed, 23 Aug 2006 13:37:06 -0700, Raj wrote:
>update the dbm cfg to turn off the monitoring... ex: update dbm cfg using DFT_MON_BUFPOOL off ...etc use monitor switches for temp. monitoring, it will end once you terminate your session. ex: update monitor switches using BUFFERPOOL on LOCK on SORT on STATEMENT on TABLE on UOW on global; natG wrote:
>>Well folks, I didn't heed the warnings (that excessive monitoring, statistics, etc. can cause a performance hit) and I have been playing around with all kinds of monitors, snapshots, especially with the gui. BUT! Performance has dropped 70%! The monitors show that the the most system overhead is caused by these selects themselves. Question 1: Is there a big red switch that turns OFF *all* of this type of activity! Question 2: If so, can I flip em all on again (just for temp test)?
I definitely need monitoring, but I guess I need to do it one at a time and measure the impact of that monitor itself, before doing another.
Please advise. Thanks. nat
*lol*Yes it does.
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Alex Martelli |
last post by:
All my mailboxes have been filling up with files of about 130k to 150k, no
doubt copies of some immensely popular virus. So, I've no doubt lost lots
of real mail because of "mailbox full" conditions (the proliferating fake
bounce messages more or less ensure nobody knows their mail to me has
bounced, either).
As an emergency response I and Anna developed, over the last half hour, a
small Python script to be run from cron every few...
|
by: Chris |
last post by:
For the IBM DB2 Development following this group. SNMP is coming back
in a big way. Changes in Version 2c and adoptions of Version 3 are
ushering in the adoption of SNMP back into the enterprise.
Your customers are going to be asking for the inclusion of SNMP back
into the monitoring suite. I'm not just talking about sending piddly
SNMP traps. I mean the "real meat" stats you get out of your DB2
instances (physical-to-logical layout,...
|
by: nsh |
last post by:
running access 2k;
I have some stats (bowling) that I want to print in columns on a
report.
The top portion of the report will have a team-members name, and the
bottom of the report will have a
sub-report that presents the stats in UP-TO 4 columns.
|
by: Ian Frawley |
last post by:
Anyone used WMI to get stats back on MS SQL Server?
Any good articles anywhere?
--
Ian (Freebasing On Boredom.......)
BEING IN THERAPY
And yet, having therapy is very much like making love to a beautiful
woman. You... get on the couch, string 'em along with some half-lies and
evasions, probe some deep dark holes, and then hand over all your
|
by: Rick Gigger |
last post by:
I am running a few web based applications with postgres on the backend.
We have a few app servers load balanced all connecting to a dedicated
postgres server. As usage on the applications increases I want to
monitor my resources so that I can anticipate when I will hit
bottlenecks on the db server. That way we can do upgrades or
optimizations before our performance get's unacceptable.
We are monitoring cpu usage, memory usage, and...
| |
by: Chuck Bearden |
last post by:
I am building from a freshly downloaded tar.gz of 7.4.3. The machine is
a 4CPU Dell with an unsupported RH 9 install. (FWIW, I didn't set it
up, and to do anything requiring root access I have to go sit at the
IT guy's console from which he SSHs in to the box. The IT folks are
smart but not Linux cogniscenti.)
When I ran the regression tests, two failed: horology and stats. I'll
append the content of the regression.diffs file to the...
|
by: robert |
last post by:
I'm using latest numpy & scipy. What is this problem ? :
RuntimeError: module compiled against version 1000002 of C-API but this version of numpy is 1000009
Traceback (most recent call last):
File "<interactive input>", line 1, in ?
File "C:\PYTHON23\Lib\site-packages\scipy\stats\__init__.py", line 7, in ?
from stats import *
File "C:\PYTHON23\Lib\site-packages\scipy\stats\stats.py", line 191, in ?
import scipy.special as special
File...
|
by: emrodge |
last post by:
Hi,
Any help appreciated on this one. I've set up a simple database with 4 tables & 3 forms. The tables link together on a field called "client id" which is the ID in a table called "Clients".
I am trying to write some code behind a button on a form called "Membership & Fee Stats" which navigates to the associated Client record on the Clients form. I was getting an error when clicking the button where the . wasn't populated for some records...
|
by: mattehz |
last post by:
Hey there,
I am trying to upload old source files and came across these errors:
Warning: Invalid argument supplied for foreach() in /home/mattehz/public_html/acssr/trunk/inc_html.php on line 59
Notice: Undefined index: args in /home/mattehz/public_html/acssr/trunk/inc_error.php on line 92
Warning: Invalid argument supplied for foreach() in /home/mattehz/public_html/acssr/trunk/inc_error.php on line 92
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: 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: 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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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.
| |