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
42 views

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

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 ...
0
votes
0answers
24 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
31 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
12 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 $ ...
2
votes
3answers
47 views

Monitor SQLAgent

I detected that SQLAgent was not running on one of our servers due to a unexpected memory leak error that caused SQL Agent to shutdown. There were not alerts configured so one main job that was ...
2
votes
1answer
67 views

Is data warehouse monitoring same as database monitoring? [closed]

I have a requirement, where data warehouse population is to be monitored. I am in confusion, and needed a clear picture. Is data warehouse different than database? eg. For monitoring database we ...
0
votes
3answers
97 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 ...
0
votes
1answer
34 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
0answers
33 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 ...
1
vote
0answers
142 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 ...
0
votes
0answers
27 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 ...
2
votes
0answers
115 views

SQL Server Database Mail Log is flooded with errors (20-30 per second) when mail server goes down

We're using SQL Server 2005. Every so often our mail server goes down, and when this happens, as soon as our SQL code tries to send dbmail, the Database Mail Log has an item which looks like this: ...
0
votes
1answer
59 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 ...
2
votes
2answers
122 views

Running query progress indication

I have a query: SELECT * FROM OPENQUERY ( oracle, 'SELECT * FROM [some_table]' ) It runs for about 7 hours. I only need to run this query once to import data into a new system when we ...
5
votes
1answer
113 views

Method or Counter to track dropped connections in SQL Server?

Our production server is running SQL Server 2008 (non r2). I'm working on investigating and issue that appears to be networking or connection related, where our web server is losing or dropping ...
4
votes
1answer
383 views

SQL Server CPU spikes - possibly non-query related - suggested indicators

I'm looking for suggestions for indicators I could monitor to discover what is causing these cpu "blunted spikes". Some known information: sqlserver.exe is confirmed as the process consuming the ...
3
votes
0answers
381 views

How to properly monitor the number of PostgreSQL database connections?

I tried to use a Nagios script for monitoring the number of database connections on a Postgres database and I reached this problem: these are counted as currently open-connections and measured every 5 ...
2
votes
3answers
2k views

Counting postgres open connections without SQL query or connecting to postgres itself

For a monitoring script I need to count the number of open connections to a postgres database. This is done easily enough by opening up a client connection and running a count on the pg_stat_activity ...
3
votes
1answer
128 views

Determine the currently executing statement in a long running PL/pgSQL stored procedure

I have a long running PL/pgSQL stored procedure in PostgreSQL. How can I determine the currently executing statement in it?
3
votes
5answers
186 views

Does DBA need (a read) access to virtualization infrastructure? And why?

I am in charge of monitoring, troubleshooting, tuning and optimizing a few dozens production SQL Servers 2008 R2/2012 in my company that are being run inside VMWare virtual machines. I've requested ...
0
votes
0answers
118 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
1answer
49 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 ...
1
vote
2answers
439 views

How to give the least permissions for CRUD-managing and running SQLServerAgent jobs as well as Maintenance Plans?

Follow up to my question "What's the owner of SqlServerAgent job for?" Basically, I am trying to understand how to create a user-login with least privileges for CRUD-maintaining SQLServerAgent jobs ...
0
votes
2answers
136 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
0answers
93 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 ...
0
votes
1answer
2k 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 ...
1
vote
1answer
821 views

What to look for in bad pg_dump log

We want to programmatically detect errors in cron scheduled pg_dumps. Apart from cheking whether or not the log file ends in "pg_dump: saving database definition": What other tell-tale string can I ...
2
votes
1answer
74 views

How identify tables with millions of entries

On a debian server with apache and mysql, how can I find out if any one table gets spammed? I have lots of different blogs, wordpress, wikis,... on my server of different customers. It seems like ...
3
votes
3answers
2k views

How do I monitor bandwidth used by SQL Server on port 1433?

I have a single server running a .NET web application and a SQL Server database (2008 Standard). I'm planning to move the database onto a separate server but in order to provision the network hardware ...
1
vote
0answers
126 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
311 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 ...
-7
votes
2answers
594 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 ...
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 ...
1
vote
1answer
371 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
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?
0
votes
0answers
580 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 ...
1
vote
1answer
904 views

How to get CPU usage of PostgreSQL server?

I'm reading about PostgreSQL monitoring tool. I get a lot of information like database size etc. but can't find info about CPU and memory usage. Are these informations provided by PostgreSQL server or ...
1
vote
3answers
96 views

Live monitoring SQL statements on SQL Server

How can i monitor running SQL Statements for my SQL-Server, is it possible using only SQL Server without 3rd part tools? As an alternative can anybody recommend any free tool which can monitor ...
1
vote
1answer
631 views

Bandwidth usage in Sql Server

Our compagny has a central Sql Server Database which is connected to many applications (Web, Backend/Frontend services, backoffice, ..) This database is hosted in a small country (for taxing ...
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.
2
votes
1answer
1k views

Collect performance information on high CPU condition in SQL Server

I have a SQL server cluster that is often reaching 100% CPU out of working hours. I want to gather some information to help troubleshooting when the actual condition is taking place. I'm thinking of ...
2
votes
1answer
1k views

How to monitor INSERT failures?

An application INSERTS a parent record then child objects. Both these procedure call different stored procedures. Parent can have many child objects. Typically both parent and child would be inserted ...
1
vote
1answer
368 views

Using sys.dm_os_performance_counters and DIFF to display logins per second

PROBLEM Running my script below i can see the number of logins as an accumulated number to my instance: SELECT cntr_value AS [LoginsPerSec] FROM sys.dm_os_performance_counters WHERE ...
4
votes
4answers
370 views

Recommendation for free event monitoring software

I'm seeking recommendations for free / open event monitoring tools. HPOV costs continue to multiply like so many wet gremlins, and we've had enough. There are some interesting suggestions in this ...
6
votes
1answer
582 views

Can SQL Express be used as a Log Shipping monitor server?

I'm keen to setup a "Monitor Server". We have SQL 2008 R2 Enterprise edition on both primary and secondary servers. Can we use SQL Express in monitoring server setup for licencing purposes?
3
votes
1answer
512 views

How to break out of error loop in transactional replication?

I was running some simple tests on a publisher and subscriber on the same instance: I inserted 50,000 rows into a published article and the data was correctly pushed to the subscriber. I ...
1
vote
1answer
410 views

What is connection time?

We are currently trialling ManageEngine SQLDBManager Plus. On the dashboard for a server it shows connection time in milliseconds (currently 15ms). Can anyone tell me what Connection Time represents ...
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. ...
1
vote
1answer
545 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 ...