Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [monitoring]

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

0
votes
1answer
24 views

Using SQL Server Reporting Services for monitoring database performance

I'd like to know whether it is a good idea to use SSRS for db monitoring or not? I want to check different parameters of a db such as Deadlock, page splits, and page reads/sec to improve db ...
0
votes
2answers
29 views

How full is my innodb shared table space?

How can I find out how much data is in the innodb shared table space. I have a massive shared idb file but I suspect that it contains only about 350 Gigs of data. I need to know how full it is so I ...
1
vote
1answer
15 views

Capture Extended Events Histogram only during time window

We have a problematic time window during night on the weekends. I want to set up multiple Extended Events sessions to capture some data and get insight. Most of them will target a file, which I can ...
0
votes
0answers
14 views

How can I connect the mysql enterprise monitor to its repository database with a socket?

By default the Oracle-MySQL-Monitor MEM (used to monitor MySQL Enterprise Instances) connects to its own repository database through localhost. Since we want to reduce the bindings of that database ...
0
votes
1answer
49 views

CPU and Hard Drive Spike for 20-30 Minutes

I'm collecting data on the performance of our Microsoft SQL 2008 server in preparation for moving it to Azure. It's a very low load server (currently max concurrent transactions max out at 3), ...
-1
votes
0answers
7 views

Cluster Control don't import mysql replication

I tried to import four mysql node on Cluster Control. My structure is like this : A <-> B -> C -> D mysql version : 5.7.23 Linux version : Ubuntu 18.04 LTS Cluster Control: Controller: 1.7.0....
0
votes
1answer
38 views

Monitoring Log-Shipping for Multiple Databases

We are setting up log-shipping for multiple databases hosted at different server and while process began, I noticed that only one SQL job is being retained at Monitoring Server. Our plan was to have ...
0
votes
2answers
33 views

MariaDB instance in cloud hit 95% CPU utilisation for 30 mins

I've got MariaDB instance in the cloud which I put live about 2 months ago. I'm new to the DBA business and I got the impression the people at the company who I run it through are learning on the hoof ...
0
votes
1answer
18 views

Monitor volume of data returned to the client application

I've identified ASYNC_NETWORK_IO as our top wait by some distance averaging between 70-77% of wait time for our client application SQL Server. This has been put forward towards the development team ...
1
vote
0answers
48 views

How to check the errorlog for important messages

I would like to receive an email every day from each of "my" SQL Servers, with information from the ErrorLog. I would like an easy way to determine if there is any important new information, that I ...
1
vote
1answer
53 views

Performance Tuning ETL

I administer a datawarehouse running on SQL Server 2016. This datawarehouse has most of its ETL processing done during a nightly load, except for a few SSIS packages that run throughout the day, then ...
0
votes
1answer
34 views

SentryOne timestamp out of sync

We are using SentryOne to monitor the servers and noticed something very peculiar. When looking at the same server data but with SentryOne software running in different timezone, the data seems to be ...
0
votes
1answer
42 views

mytop to monitor multiple mysql servers

I have multiple MySQL servers running on CentOS. I would like to use mytop to monitor real time database query activities, but do not want to install mytop locally on each of my MySQL instances. How ...
1
vote
1answer
170 views

Difference between fetched and returned tuples in postgresql

I'm facing a hard time trying to figure it out some performance problems in my database. I'm using a bunch of resources online to learn what to monitor and how to interpret that information. From ...
2
votes
1answer
71 views

Monitor source SQL code of inserts into table

I have a table with rows which should not be there, means the data is wrong according to business logic. And there is a lot of possible sources the insert statement of the "bad" row is coming from. I'...
1
vote
1answer
39 views

Monitor RAM/Memory

I'm planning to create a job that automatically gets the status of my server's RAM/memory at the time of the job's activation. My job has the command: use master insert into Rec.dbo.MemoryRec ...
1
vote
0answers
58 views

Cost / Capacity Planning: Quantify Data Ingress / Egress

To evaluate the migration of an on-prem SQL Server to a cloud-hosted VM, I want two fundamental pieces of information: The list of clients that access the on-prem DB Server. I'd like to know: client ...
0
votes
1answer
41 views

Any system tables/views to determine query volume per table

I was digging through the SQL Server system views and Windows performance counters and can't find any metrics regarding query volume PER TABLE in a given database. I am looking for any type of ...
0
votes
2answers
259 views

Tracking database and table size growth

Is there way we can get the table size and DB size growth from last one month day-wise? We are able to give the current size of DB and table size.
0
votes
1answer
40 views

Check connection details to SQL Server 2000/2005

I want to migrate some databases hosted in SQL Server 2000/2005 to SQL Server 2014. I don't have direct access to the databases and I want to know all applications connecting to it and connection ...
0
votes
0answers
38 views

Snmp monitoring in mongodb

We are planning to setup SNMP monitoring alert in our prod environment. Is it enough to give subagent field value as "true" in configuration file to start the service ? Or are there any other ...
1
vote
0answers
81 views

MySQL innodb_row_lock_time is more than wall clock time

We recently started graphing the innodb_row_lock_time status variable in our monitoring system. I noticed something I can't understand on a graph for a busy server: Between 04:55PM and 04:57PM, the ...
2
votes
2answers
208 views

Oracle Standard Edition Monitoring Tools

We have 10g and 11g Oracle databases and all of them is Standard Edition. We need monitoring tools like cloud control for standard editions. Do you have any suggestions ?
0
votes
1answer
268 views

SQL Server 2017 Management Data Warehouse: collection_set_1 not working due to database trigger

The problem I have got an issue setting up Management Data Warehouse on SQL Server 2017 CU 5. The job "collection_set_1_noncached_collect_and_upload" keeps failing. It is related to the "Disk Usage" ...
1
vote
1answer
31 views

Select returns users locked or a default value for null rows

I'm don't have much knowlegde on Oracle database and used some questions from here to obtain this query: select case when ((sysdate - timestamp)*24 < 1 and returncode <> 0) then (username ...
0
votes
2answers
120 views

LOG all SQL Server queries with their durations

Is there a way to log all Microsoft SQL Server queries executed on a certain server, with their respective durations? I'd like to be able to analyze all queries will a tool like what PGBADGER does ...
0
votes
1answer
455 views

Why doesn't nodetool work on my Cassandra Cluster?

I have never been able to get nodetool to operate correctly to give me information about my cluster. We have a simple 3-node cluster of Cassandra 3.11.1 nodes running under CentOS 7.3 -- using the ...
0
votes
2answers
254 views

SQL Performance Monitor vs DMV Dynamic Management Views [closed]

We are trying to measure SQL Server Performance metrics. Is it better to record Performance Monitor (PerfMon) or DMV Dynamic Management Views to measure CPU, Memory, Buffer pages, etc? There are ...
2
votes
2answers
129 views

Long running statement not monitored by Oracle

We are trying to find out why a (pretty complicated) statement has an extremely high variance in runtime. Sometimes it just takes "minutes" (around 40-50) and sometimes it does not finish even after ...
0
votes
1answer
374 views

Show recent select queries on Firebird database file

Is there a way to log or query the n recent SELECT queries to an FDB database file? I have already tried using the MON$ and RDB$ tables but I didn't find anything useful.
0
votes
1answer
930 views

Getting Batch Requests Per Second On a Particular Database

Does anyone know how to find Batch Requests/Sec on particular database (database specific, not server level)? This is how to find Transactions/Sec on a particular database. DECLARE @Counter bigint ...
0
votes
1answer
93 views

Why my indexes monitoring status change to 'no'?

On one of my production Oracle database 11g Standard Edition I have a lot (a very lot of) indexes. Some of them (majority) are created by the application installer, others are created by me when I ...
-3
votes
2answers
182 views

SQL Server: How to set time in a human readable format

I found this useful query here and I use it to monitor SQL Server jobs. SELECT sJobHis.[server], sJobStep.database_name, SJob.name, SJob.enabled, CASE WHEN SJob.enabled = 0 THEN '0' WHEN sJobStep....
1
vote
1answer
258 views

Page life expectancy error in sql server

I am new to sql server monitoring.Basically system administrator who worked in organisation set monitoring in window server 2012R2 to monitor memory issues in sql server and I am getting following ...
1
vote
0answers
68 views

Negative values for Wait Time per Core per Sec in sp_BlitzFirst

I'm a developer in a firm that doesn't want to spend money on a DBA so i'm on my own with keeping the SQL servers healty. I checked some of Brent's videos and decided to check how hard the SQL servers ...
0
votes
0answers
59 views

Trying to monitor CPU usage; difference between last_execution_time and total_time_elapsed?

I've been using this Query in order to find the top 20 CPU usages of a day the last 2 hours. SELECT TOP 20 qs.sql_handle, qs.execution_count, qs.total_worker_time AS Total_CPU, ...
0
votes
1answer
38 views

How to get info if any Monitoring tool (DB performance Analyzer) stops working?

What is the Reason behind if SQL monitor for Production stopped working? what is the reason for this? I checked on Licensing, SQL server permissions, No Updates/Patching and Remote admin connections ...
0
votes
1answer
54 views

How to increase the size of query audit log?

I need to find the queries run against an Oracle instance. On running the query: SELECT first_load_time, sql_id, sql_fulltext FROM v$sql ORDER BY first_load_time ASC; Only ...
0
votes
1answer
164 views

Monitor and alerting tool for specific queries [closed]

I need to monitor and alert a MySQL DB which is hosted on AWS. I'd like an alert to trigger if certain SQL query criteria aren't met (e.g. SELECT * FROM my_table returns less than 100 results). What ...
1
vote
2answers
87 views

Stale monitoring errors?

After setting a cluster with 3 shards, 3 config server with 2 mongos. I see these errors in the monitoring agents Failure during discovery. What do they mean I tried to see it on the internet but ...
2
votes
1answer
156 views

Is there a way to get the isolation level from sp_whoisactive out of the xml into the plain result?

While I caught myself re-engineering the functionality of sp_who / sp_whoisactive using the sys.sysprocesses and sys.dm_exec_session views, to get an overview about running sessions and transactions ...
0
votes
1answer
616 views

What could be causing this rogue CPU spike on MS SQL Server running on EC2?

We've just had a rogue CPU spike on one of our main SQL boxes, and we're struggling to work out what caused it. We use Red Gate SQL Monitor to track various performance metrics, and we saw a couple of ...
3
votes
0answers
303 views

Oracle 12c tablespace monitoring tool [closed]

I am looking for a tool to monitor Oracle tablespaces and receive email alerts when they get over a defined percentage. We want to be able to detect the issue before having to react to the problem.
4
votes
1answer
62 views

How to calculate required ressources from a baseline and what should be measured at all?

I have to deal with the following situatiuon: Currently we have 1 cluster with 5 nodes running 10 instances (SQL Server 2008 Enterprise edition), and 1 cluster with 2 nodes running 5 instances (SQL ...
12
votes
1answer
20k views

Number of active connections and remaining connections

I would like to get statistics about the peak number of connections over a period of time. I know the pg_stat_activity view, like select count(*) from pg_stat_activity, but I think this method is not ...
3
votes
0answers
110 views

Failed sp_executesql queries and rpc_completed

I'd like to track which procedures are failing in my database using extended events. Procedures are being executed like that from an application: EXEC sp_executesql 'exec dbo.GetData'; And when that ...
0
votes
3answers
2k views

Metrics for monitoring master-slave replication

Is there some kind of query/view/table available in PostgreSQL that can reflect the actual status of a master-slave replication process? Perhaps the "degree" of sync between the nodes? The above is ...
0
votes
1answer
50 views

weight of replication on SQL Server 2008 R2 instance

How can I see what impact replication is having on a server/instance, replication vs all other things.
3
votes
0answers
260 views

What could empty our cache (plan and buffer)?

If I execute sp_BlitzFirst in my server, sometimes it tells me 2 things: Plan Cache Erased Recently (indeed my plan cache is around a few hundreds MBs) (sometimes) Page Life to low (indeed my page ...
2
votes
0answers
302 views

Options for monitoring Postgres stats on Heroku and sending alerts [closed]

Running a Rails app on Heroku with Postgres as my DB. Heroku outputs the below postgres stats to the the logs periodically. (formatted here for readability) source=DATABASE sample#...