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

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

0
votes
0answers
15 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
17 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
17 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
47 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
46 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
33 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
28 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
62 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
64 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
35 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
53 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
38 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
180 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
30 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 ...
1
vote
0answers
30 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
65 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
130 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
232 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
102 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
367 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
232 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
102 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
288 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
800 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
71 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
161 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
217 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
64 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
57 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
51 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
142 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
86 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
137 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
537 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
287 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
59 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 ...
11
votes
1answer
17k 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
94 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
2answers
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
48 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
237 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
271 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#...
5
votes
0answers
624 views

Why does pg_last_xact_replay_timestamp() sometimes return extremely old timestamps?

In PostgreSQL 9.5, to monitor streaming replication lag, I use a combination of: pg_current_xlog_location() pg_last_xlog_replay_location() pg_last_xact_replay_timestamp() The first two functions are ...
0
votes
1answer
41 views

Store wait_stats automatically and query it whenever required

I'm learning wait_stats and came up with thought. Is it possible to store wait stats in a table or create a stored procedure or query which will return wait_stats % when we execute query or stored ...
2
votes
2answers
426 views

Monitoring replication status from the subscriber

I have two databases that are populated by our vendor using replication from their databases. I do not have access to their distributor db. But I want to monitor from our end whether the data has been ...
4
votes
1answer
128 views

“Stored Procedures Invoked/sec” counter always increasing

We've implemented some feature using service broker and deployed recently on production. I am observing that "Stored Procedures Invoked/sec" counter is always increasing. However, I can see that other ...
4
votes
1answer
246 views

Methods to identify/recognise 'bad' parameter sniffing in SQL Server

There's lots of superb information out there about the certain approaches that can be used to mitigate bad parameter sniffing, but there's not a lot of information about how to go about identifying a ...
1
vote
2answers
284 views

Access to performance counters from T-SQL procedure

I want to write a stored procedure, which is returning CPU utilisation, Memory utilisation and Count of rows in table T1. So it should look like: SELECT cpu, memory, (SELECT COUNT(*) FROM T1) as ...