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

learn more… | top users | synonyms

5
votes
2answers
82 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 ...
2
votes
0answers
97 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 ...
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 ...
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
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 ...
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
32 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, ...
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 ...
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
31 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 ...
0
votes
1answer
80 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
137 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 ...
7
votes
2answers
243 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 +' ...
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
56 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 ...
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
1answer
199 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
153 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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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
159 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 ...
5
votes
2answers
550 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
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, ...
2
votes
0answers
41 views

How to prevent misuse of rights in monitoring application?

I have a monitoring application that runs on the computer of each user in my organization. This application needs to insert some monitoring data in several tables of a database (MS SQL Server 2008 ...
1
vote
1answer
256 views

Log Shipping -Monitor Server Down - Copying happening but not restoring on secondary

I have set up a few log shipping instances, but I am not a DBA. This weekend something happened for the first time - the log shipping Monitor Server went down temporarily due to electrical issues ...
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 ...
0
votes
0answers
52 views

Monitoring active query step using only pure sql

I would like to monitor actively running query on Oracle. What I mean is to gather info about: Actually running step. (What is currently db engine doing in this query) Actual query plan used in ...
2
votes
2answers
460 views

Sybase ASE find running process

I run UPDATE INDEX STATISTICS on some HUGE table. And it runs already about 1 hour. Is there some procedures/ways to find the percentage of executing this command? sp_who, sp_sysmon don't help. ...
3
votes
1answer
113 views

enabling snapshot isolation level on a database - what to monitor?

I am having problems with frequent deadlocks on a subscription database. I am considering enabling the snapshot isolation level for that database. I am aware that there is an overhead on the tempDb ...
1
vote
1answer
157 views

Monitor unusable indexes on oracle

I have a lot of database, a ton of partitioned tables and many processes running on them. In a couple of occasions I hade problems for unusable indexes or partitions of them. A bugged procedure, or a ...
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
0answers
41 views

Please explain log-shipping delta

I am trying to understand how Delta is monitored in log-shipping. We have log-shipping monitoring in place and I am seeing delta increases sometimes for random instances and it drops once database is ...
2
votes
1answer
755 views

Is someone trying to hack into my SQL Server Database?

I was asked by a friend, who isn't technical at all, to help her with her application. I thought I would just being doing a little C# development and some SQL queries. Turns out it has been a lot ...
3
votes
1answer
109 views

reporting space consumption to files in filegroup - how to reverse-engineer the algorithm spreading data across files

I would like to know how to calculate the distribution of data consumed per file in a filegroup, back to the index (HEAP, CLUSTERED, NONCLUSTERED) storing it. My intention is to define which I/O goes ...
1
vote
1answer
238 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 ...
0
votes
1answer
470 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 ...
1
vote
1answer
88 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 ...
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 ...
0
votes
0answers
28 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 $ ...
3
votes
3answers
225 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
85 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
181 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 ...
1
vote
1answer
253 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 ...