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

learn more… | top users | synonyms

2
votes
0answers
88 views

Sudden Mongodb high connections/queues, db stops responding

The issue We have a strange issue on our mongodb setup. Sometimes we get peaks of high connections and high queues and the mongodb process stops responding if we let the queues and connections ...
5
votes
2answers
77 views

How to verify disk hit by a query

I want to know how to verify disk hits by a select query in PostgreSQL 9.4 on CentOS 6.5. Also please let me know how far enabling the log_statement_stats in the postgresql.conf will help me. I need ...
5
votes
1answer
86 views

Monitor table permission changes

I need a solution to monitor table permission changes: how can I implement monitoring of every changes to granted permissions for a specific or any user on a specific table in SQL Server 2008 R2?
0
votes
1answer
170 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 ...
3
votes
2answers
68 views

How can I extract the perfmon counter “Memory: Pages/Sec” using t-sql?

I've googled this and so far, no luck so turning to all you awesome gurus for help. I'm trying to figure out if there's a way to get the perfmon counter "Memory: Pages/Sec" using t-sql as I'm trying ...
4
votes
1answer
190 views

Creating MSSQL Performance Baseline Monitoring

In order to get an overview and compareable data my current task is to create a performance baseline to get some figures about the different productive sql instances. My thoughts are: I want to ...
7
votes
2answers
242 views

When running a script with several commands, how to find out where we're at?

I have some processes that require different steps to be taken before they start. For example: Disable check constraint on foreign key: select 'alter table '+fk.table_schema+'.'+fk.table_name +' ...
3
votes
1answer
1k views

Getting the last executed command time

I have tables stored in a Trucrypt partition and I would like to disconnect that if the users not using the mysql. There is the INFORMATION_SCHEMA.PROCESSLIST but I would like to know the users last ...
1
vote
1answer
538 views

Replication Broken, List Out of Sync Tables

In a master-slave setup on MySQL 5.5 on RHEL 6.1, when db replication breaks (for whatever reason), what is a good way to: check (and alert) replication is broken? get a list of tables that are out ...
1
vote
1answer
251 views

Create user to monitor database activity on Postgres

Postgres 9.3 Debian 7 I want to create a monitor user called monitor that the only permission is to run queries to monitor all the database activity. I created the user and it can select from ...
1
vote
1answer
606 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 ...
0
votes
1answer
148 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
1answer
18 views

Check lock count for PostgreSQL

Up to now we used check_postgres.pl to monitor our database. We used this to check the count of the locks: https://bucardo.org/check_postgres/check_postgres.pl.html#locks We often see more than 150 ...
2
votes
0answers
35 views

Debug PostgreSQL lock count with check_postgres.pl

We use check_postgres.pl to monitor our database. We use this to check the count of the locks: https://bucardo.org/check_postgres/check_postgres.pl.html#locks We often see more than 150 locks. The ...
11
votes
2answers
1k views

alert when any job in a job category fails

Is it possible to set up an alert in SQL Server 2008 that will send an e-mail anytime a job in a specific category fails? I am wondering because I would like to set up an e-mail anytime an SSRS ...
2
votes
2answers
57 views

What parts make up pg_database_size?

I'm trying to write a munin plugin to graph DB sizes. Alongside using pg_database_size I want to graph the components thereof as well. So far, I've come up with the following: SELECT ...
0
votes
1answer
31 views

Monitor SQL TCP traffic on the client

I have a Windows 7 client that has a data driven application that connects to our SQL Server 2008 R2. How can I view all the traffic between this software and the DB? I would mainly like to see ...
0
votes
1answer
20 views

Track MongoDB users operations

What is the best way to track operations done on my MongoDB instance? I want to display a graph with the number of user's operations (insert, update, query etc..) done. I have read about profiling, ...
9
votes
2answers
7k views

Monitor MySQL activity per database?

What is the best way to monitor activity on each database of my server ? I tried mtop/mytop which display activity in real time but aren't very practical to see all the queries executed on it. I ...
0
votes
1answer
24 views

SQL Server - Check for opened Activity Monitor

I'm looking for a way to send an alert when a DBA tool is connected for "too long" on a SQL Server Production database. For most of the tools I listed out, I can find the program name with the ...
2
votes
2answers
11k views

How to monitor backup jobs on Oracle 11g?

Background: I'm trying to monitor that backups run as expected on several databases. Zenoss is used to monitor most other stuff. A couple of KPIs are already monitored using Zenoss in combination ...
1
vote
1answer
56 views

Monitor disk usage with MongoDB Ops Manager

We use MongoDB Ops Manager 1.6.2.251. I searched Activity -> Alert Settings. Is there a way to monitor disk usage? To get an alert if this changes to 90%: # df -h /data/ Filesystem ...
1
vote
1answer
37 views

Why does everyone want me to create an alert for severity 025?

Brent Ozar and others suggest to listen to severity 025 SQL-Server events. I searched for the meaning of all different high severity events, looked through different articles and read the most recent ...
0
votes
1answer
79 views

Postgresql Streaming replication - monitoring

I have setup streaming replication for my postgres servers. I am using PostgreSQL 9.2.6. Replication seems to be working fine. I am monitoring this with two ways using nagios: Log_delay and ...
4
votes
1answer
136 views

How to find out how much i/o resources a task, session, request or transaction is currently using?

How to find out how much i/o resources a task, session, request or transaction is currently using? by task I mean the DMV called DMV sys.dm_os_tasks. by session I mean the DMV sys.dm_exec_sessions ...
0
votes
1answer
29 views

Mongodb monitoring

I am using a mongodb in my application and i would like to ask if someone here has some tested tools to monitor the servers (similar to tools like heidi sql or mysql workbench). My main needs are ...
10
votes
6answers
4k views

How can I profile SQL Azure?

I am writing a web site that uses SQL Azure heavily. However, it is painfully slow. Is there an easy way to profile the live SQL Azure instance?
2
votes
1answer
60 views

MongoDB Ops Manager - CPU Time - No data available

We have 5 groups and enabled on all groups monitoring agent. We use Ops Manager 1.6.2.251. All metrics get collected and are available in a nice graph. CPU Time is not available on all groups. Our ...
1
vote
0answers
23 views

SSAS - what could I monitor in SSAS to fine tune its memory settings?

This question is a follow up from the SSAS - what could be a good starting point for memory settings? What and how can I monitor the server resources in order to best identify the settings that I ...
1
vote
1answer
55 views

Oracle: How do I add users to the HTTP ACL in Oracle 11?

How do I add a user to the network ACL (access control list)? When running this code declare req utl_http.req; begin req := utl_http.begin_request('http://example.com'); end; I receive ...
1
vote
1answer
197 views

Oracle: How can I track the progress of an index rebuild?

How can I track the progress of a command such as this? alter index myindex rebuild reverse online;
3
votes
2answers
151 views

Find out what columns are in a trace file

while tackling and unexpected CPU spike that was happening every 10 min one of my colleagues prepared a server side trace as follows: -- Create a Queue declare @rc int declare @TraceID int declare ...
3
votes
5answers
4k views

MySQL Performance Monitoring

I already have system availability monitoring for all my MySQL instances in Nagios. I'm looking to get some trending monitoring going for activity. It'd be nice to see how all the information_schema ...
4
votes
0answers
2k 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 ...
0
votes
0answers
40 views

Identifying high load sql

We had an oracle outage some days ago. We have inbetween awr tools. I genarated awrrpt report but dont see anything suspicious. Which report should I generate to see sql, which caused very high cpu ...
2
votes
1answer
55 views

Associate SQL Server Queries with Databases

Is there a way via T-SQL and DMVs to show which database a query was run against? The goal is to look at CPU and I/O by query by database so I can redistribute the databases as I reconfigure the ...
1
vote
0answers
138 views

Redis Cluster monitoring

In some limited testing with Redis Cluster I've identified the following conditions where a failed master would be unable to failover: The obvious, all the slaves have failed All of a master's slaves ...
5
votes
2answers
102 views

Catch event of auto_shrink in SQL Server Log? [duplicate]

I am aware of the disadvantages of AUTO_SHRINK being configured on SQL Server databases. Recently, in a new environment, I discovered several production servers with the Auto Shrink option turned on. ...
10
votes
3answers
6k views

How can I have SQL Server email me the error details when a job fails?

SQL Server lets you configure a job to send email alerts when it fails. This is a simple and effective way to monitor your jobs. However, these alerts do not include any detail--just a success or ...
1
vote
1answer
27 views

least privilege MongoDB monitoring user (no access to customer data)

We use A Nagios plugin to check the status of MongoDB. Howto create a user with least privileges for this plugin? Admin acess would be a security vulnerability. I found the built in role ...
0
votes
1answer
157 views

How to see query executed for a specific user from V$SQL

I am trying to have the queries used for a specific user at the end of the day. But it seems the queries in this view V$SQL are deleted every short time. I am not sure how much time. Also i dont know ...
4
votes
1answer
691 views

Monitoring Amazon RDS with pgtop

I recently migrated a Postgres database to Amazon RDS and I am lacking a good live monitoring tool. I tried pgtop, but I can't get it to work on Amazon. I can see the header with the DB statistics ...
1
vote
3answers
125 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 party tools? As an alternative can anybody recommend any free tool which can monitor ...
3
votes
2answers
490 views

Using Central Management Server to provide convincing performance statistics

Central Management Server The company I work offers dedicated VMware hosted servers to its Windows clients. Among those Windows clients, there are essentially 60 single instance SQL Servers ranging ...
1
vote
2answers
302 views

SQL Server Monitoring Tools [closed]

Can anyone recommend a good SQL server Monitoring Tool? One which will provide info on, server space usage, CPU usage , expensive queries run etc.
3
votes
3answers
2k views

Monitoring free space in SQL Server data files

I have manually resized mdf/ndf files to a big size to avoid autogrow operations on SQL Server databases. Since the files are bigger there is very little free space on disk partitions and the ...
5
votes
2answers
546 views

How to track DML and DDL daily events

I have the following query to track what tables are modified in the current date: SELECT TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, TIMESTAMP AS ...
0
votes
1answer
256 views

Monitoring sql server

This question is related to monitoring of SQL Server. I want to send an email alert with all open transactions on SQL Server in HTML report whenever there is sustained 50-60% CPU usage for more than ...
15
votes
4answers
50k views

How to find the latest SQL statements within the database?

I like to get the latest executed statements within my database, along with performance indicators. As such, I like to know, which SQL statements were most CPU/DISK intensive.
0
votes
0answers
52 views

What is the best way to analyze free space in a postgres database and the grow of usage?

In Oracle you can in datadictinary analyze free space by using SQL like: select b.tablespace_name, b.file_id, b.file_name, b.bytes/1024 total_KBytes, sum(a.bytes)/(1024) sum_free_Kbytes, ...