An ongong check of various statistics and events, which can be used to spot telltale signs of underlying issues.

learn more… | top users | synonyms

1
vote
1answer
999 views

How do you monitor specific SQL statement of a specific user ?

We have a few standalone users here which cause high server loads for several 11.1.0.7 Oracle's. I spoke with them a few times but it seems that their queries are causing high loads and probably ...
1
vote
1answer
3k views

Oracle Script For Getting Long Active Sessions

Is there any script that you could provide for v$session? I seem to be encountering an issue in which my oracle active sessions are filled up. This is when I do SELECT * FROM V$SESSION WHERE STATUS = ...
1
vote
1answer
611 views

How can I get the maxium number of concurrent connections to MySQL over a specific time interval?

I have a monitoring app that checks MySQL's Threads_connected and Max_used_connections variables every X seconds. Neither of these variables tells me what I want to know: The highest number of ...
1
vote
1answer
40 views

SQLAnywhere: Visualize in real time CPU and RAM consumption of sql connections

I want to keep track of which connection use most of resources. Within Sybase Central (SQL Anywhere 9, 12), for each server and database, we have pane to check in real time All Connected Users and ...
1
vote
2answers
179 views

Running a simple logging program, how to diagnose spikes mongod's CPU activity?

I'm running mongodb 1.4.7 - I've a node server set up which logs incoming requests in a logs collection: {'u':'user123', 'l':'log data'} In addition, once the request happens, the server will check ...
1
vote
1answer
325 views

monitoring mongodb and mysql replications using nagios

I have set replication for mongoDB and mySQL. Now I have to manage them using nagios. I have to write some php-script that will read server status. I am good with nagios setup. Now I want to know ...
1
vote
1answer
383 views

Monitoring real-time statistics on PostgreSQL

I need to monitor the DB performance on a distributed system with multiple databases. Some of the database servers use pgbouncer to pool connections and in those servers I can connect to pgbouncer and ...
1
vote
1answer
565 views

replication warning: transactional replication latency alert not working

I have set up a predefined replication alert (as outlined here) in SQL Server 2008 and the alert for Replication Warning: Transactional replication latency does not appear to work. This is triggered ...
1
vote
1answer
53 views

What should I monitor on the SQL Server machine? [closed]

I need to create some alerts, logging jobs and monitors on a machine that is going to run SQL Server 2012 Standard for an ERP system. The OS will be Windows Server 2008 R2 Standard/Datacenter (if it ...
1
vote
0answers
162 views

MongoDB communication issues on Azure

I have a Python uWSGI app running behind Nginx using pymongo to communicate with a 4 machine replica set running Mongodb 2.6.3. The replica set is configured using domain names for each machine ...
1
vote
0answers
102 views

problem installing mytop , need a up to date tools for monitoring mysql

so i'm trying to installl mytop to monitor the database i'm following this instruction : http://www.sohailriaz.com/how-to-install-mytop-a-top-clone-for-mysql/ when i try to install it with yum i get ...
1
vote
0answers
133 views

Monitoring multiple Oracle databases on a single screen

We would like to monitor database activity of multiple Oracle databases on a single screen (10g and 11gR2), divided by the number of databases. Some tools are offered here: Tools to monitor Oracle ...
1
vote
1answer
3k views

What are some best monitoring tools available for mysql? [duplicate]

I have a setup a linux mysql server and would like to monitor it. I found percona plugins for nagios and cacti. Are there any other tools available?
1
vote
1answer
1k views

Realtime SQL Server Monitoring Tools? [closed]

We been having a lot of sql server performance problems lately. I've recently been digging into performance analysis using the variety of DMVs. I've definitely found some interesting things. ...
0
votes
1answer
51 views

What's the point in mapping users in SQL Server Data Collection?

In SQL Server 2012 R2 Enterprise, whenever I check Management\Data Collection, right-click --> Configure Management Data Warehouse , I see whatever users-accounts-logins except the one I am logged in ...
0
votes
1answer
28 views

Customizing OEM notification title and body

I am writing a reporting tool that accepts email notifications for incedents , alerts and events coming from the OEM. The tool parses the email title and body to extract information from it. I was ...
0
votes
1answer
38 views

How to find the last error codes and messages of failed statements executed by a user?

Hopefully, a program that connects to a Oracle DB does sufficient logging of errors on its own, e.g. when doing a bulk insert the error reporting of a program could produce something like this: ...
0
votes
1answer
62 views

Is a single batch request equivalent to a single tsql request?

I'm looking into some performance metrics and every recommendation includes monitoring Batch Requests/sec. But, maybe a silly question, does a singe batch request correspond to exactly one tsql ...
0
votes
1answer
3k views

High average load due to the High mysql cpu usage

i've got 2 warnings about my average load being high in the past week and apparently it has to do something with the mysql my daily visit has been increased about 10-20 thousand (total of 180-150 ...
0
votes
1answer
52 views

How to create via sql and detect via ERRORLOG SQL Server 2008 Deadlocks

I am designing a monitoring program using HP Sitescope SIS. The goal is detect deadlocks. In doing so, I created a deadlock on an existing but nearly unused SQL Server 2008. I used the following ...
0
votes
2answers
1k views

How can you monitor if MySQL binlog files get corrupted?

I was wondering if there was any nice way to continuously monitor mysql master binlog files and detect if get corrupted.
0
votes
0answers
29 views

MySQL Enterprise Monitor - Query Analyzer configuration problem

I'm using MySQL 5.1.69. protocol_version 10 version 5.1.69-log version_compile_os redhat-linux-gnu I have a problem with configuration/using MySQL ENTERPRISE MONITOR. I don't see data in ...
0
votes
1answer
36 views

What to monitor (key indicators) for MySQL server

I have installed Munin for monitoring my MySQL database server. It enabled a large amount of MySQL plugins out of the box. Since running these plugins can be CPU expensive I want to limit them to the ...
0
votes
0answers
13 views

Unable to open MONyogs

I was trying to run through the docs for manually working with the MONyog internal sqlite dbs for purposes of configuration automation. At the point trying to open the data file I get an error $ ...
0
votes
0answers
42 views

Bucardo status does not feel if the slave is down

I am using bucardo as third party to postgresql replication between two sites. everything ok except buacrdo status <sync_name>. I have a Master-slave sync on master server. when I poweroff the ...
0
votes
0answers
30 views

how to clean huge Dbwarden QueryHistory table

dbwarden is Comprehensive database monitoring solution for SQL Server 2005+ which i am using. i found that dba_LongRunningQueries – Runs every 5 minutes. This will run usp_LongRunningQueries to ...
0
votes
0answers
12 views

High bandwidth on virtual IP

Description of the environment : An apache server (Drupal) connected to mysql server using a virtual IP. The problem : The (outgoing) bandwidth on VIP has exploded (after a new site version ...
0
votes
0answers
123 views

Replication Monitor Missing Subscriptions in Watch List

In Replication Monitor, for one of our publications (transactional replication), none of the subscriptions are showing up in the Subscription Watch List. This is new behavior that just started ...
0
votes
0answers
612 views

How to display Oracle Enterprise Manager 11g (OEM) alerts and reports in Nagios?

I am working on a project that requires an unobtrusive integration of OEM data into a Nagios front-end. I know there are ways to use SNMP traps to do this, but I am not completely familiar with how ...
0
votes
3answers
103 views

Oracle monitor tool [closed]

Our Oracle server continues with out of memory problem, and we don't have an Oracle DBA in our team. Is there any Oracle monitor tool or ways to find the reason? We have a lot of stored procedure ...
-7
votes
2answers
619 views

How can I check for SQL Server performance problems using T-SQL? [closed]

I know how to use the Profiler, Performance Monitor, and Activity Monitor. I want to find a way to troubleshoot performance using T-SQL. How can I check for Microsoft SQL Server performance problems ...