Questions tagged [monitoring]

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

Filter by
Sorted by
Tagged with
0
votes
2answers
45 views

How to monitor performance in application insights of an on prem SQL Server database?

Application Insights has great ways to monitor databases. After some online investigation, I saw an explanation of how to monitor actual queries. Monitoring SQL performance is possible too but what I ...
0
votes
1answer
24 views

How do you monitor PostgreSQL queries?

I have an application which uses PostgreSQL. I want to monitor all the queries that the application sends to the database. Is there a way to monitor the queries sent?
0
votes
1answer
26 views

How to monitor general performance and wellbeing of a database?

I've read @Mike answer to How to tell if database tuning is fruitful (PostgreSQL), and that's the kind of approach I'm thinking about for monitoring the performance of my database (of a web ...
2
votes
2answers
60 views

nulls on pg_stat_get_progress_info('VACUUM') columns on pg_exporter role

I'm trying to export the results of a query select * from pg_stat_progress_vacuum;. The problem is that the only column values I can see from the created user are: pid datid datname Other columns ...
0
votes
0answers
8 views

how big is the server load when client hit information_schema for monitoring

when I create some small application monitor for mariadb, and then I send query like select variable_value from information_schema.global_status where variable_name = 'THREAD_RUNNING' or select ...
-1
votes
2answers
66 views

RDS MySQL top CPU queries

I'd like to know if there is any way to get the top queries in my instance per CPU. I would see which query has more impact in my instance based on CPU usage. Anyone have any idea if it possible in ...
3
votes
2answers
102 views

Monitoring for and dealing with sudden jump in TOAST bloat

I'm trying to diagnose a sudden jump in disk usage in one of my databases (running 11.4). Typically the database grows by ~1 GB per day, but recently in the span of 24h it grew by nearly 100 GB. ...
0
votes
1answer
272 views

TempDB Log File Growth - questions

Problem: On one of the production boxes, TempDB transaction LOG file grew unexpectedly, filling the drive It was 32 GB but now it is 240 GB Questions: What is the mechanism of TempDB log file usage ? ...
0
votes
2answers
72 views

Monitoring slow queries on large database (Percona 5.6)

I am looking for a solution to monitor very large production database (many replicas, over 200 tables, some of tables have 10-50 GB of data) with a lot of traffic (a wide set of query complexity). The ...
0
votes
0answers
30 views

Check end time (last transaction time) of PostgreSQL WAL archive (backed up with pgBackRest)

I have pgBackRest 2.27 receiving WAL archives from PostgreSQL 12.3. Is there a way to find out the timestamp of the latest transaction included in the WAL archives, i.e. what time I could restore my ...
1
vote
1answer
234 views

Script to monitor database growth on daily basis

I am fairly new to databases, I have got a specific requirement to script a Job/Stored Procedure to monitor the database growth. We are currently using MS SQL Server 2016 Standard Edition with ...
1
vote
1answer
234 views

How to see urls of incoming SQL Server traffic?

We are migrating the dns entry for our SQL Server database from an machine name to a C-Name, in preparation for moving it from a bare metal box to a virtual machine. We have switched all the ...
2
votes
1answer
34 views

Which metrics should a product owner look at?

I am the product owner for an on premise, off-the-shelf, application, which relies on a SQL Server DB. My company outsources DB administration to a bunch of very capable folks, and tickets are issued ...
1
vote
0answers
48 views

How to monitor query load, counts, and durations in PostgreSQL

I'd like to understand load (average active), count, and, average time of various queries. This is an AWS RDS Performance Insights dashboard. This is the sort of information that I want, though as ...
0
votes
0answers
20 views

PMM QAN changing time-zone

How can I change the time-zone for the QAN page? The issue is that when I check the first-seen and last seen for any particular query, it shows in my local time (IST) + 5:30hrs. PFA screenshot, the ...
0
votes
0answers
32 views

Why is the Page Life Expectancy (PLE) not increasing?

We have monitored the PLE performance counter for several SQL Server 2016 instances for over a year, and have had alerts which triggered when this value persistently dropped to zero or froze. ...
0
votes
1answer
43 views

What is the y-axis of this Oracle ASH Viewer?

I am investigating different monitoring software for my database, and I stumbled upon this open source ASH Viewer. I noticed in the main graph on the y-axis for resource usage, it's labeled as "Active ...
0
votes
0answers
196 views

Audit sysadmin activities on SQL Server

because of GDPR we need a system that monitores all activities that administrators does on an SQL Server. First goal is to audit sysadmin activities (selects too), but if possible activities of ...
1
vote
2answers
64 views

Theoretical writes/sec limit

If I have solarwinds which has an alert set whenever we have more than 300 writes per second, and I know 300 writes per second is fine, and the writes per second often goes over 6500, how can I work ...
1
vote
1answer
517 views

Prometheus High Memory and CPU Usage in PMM

We are running PMM v1.17.0 and prometheus is causing huge cpu and mem usage (200% CPU and 100% RAM), and pmm went down because of this. We are running PMM on a VM with 2vCPUs and 7.5G RAM, and are ...
0
votes
2answers
380 views

Microsoft SQL Server equivalent to Oracle Enterprise Manger Top Activity Interface?

My DB performance management experiences is primarily with Oracle and I am looking for an equivalent set of tools in MSSQL. In particular something to easily spot historical SQL peaks and identify the ...
1
vote
1answer
42 views

Audit logins and logouts [duplicate]

I need to trace and monitor client login connections (successful and failure) to our important SQL servers (20 MSSQL Server). What method do you recommend? Note: I think enabling "both failed and ...
1
vote
1answer
150 views

What does RRQMS and WRQMS mean?

I found a possiblity to display Rrqms and Wrqms graphs in AWS RDS Enhanced monitoring page (I use Postgres 9.5.19) but I can't find any detailed explenation about these parameters. By googling I only ...
0
votes
1answer
110 views

Could you monitor all changes made within a postgresql database by somehow subscribing to the replication log?

I've been reading about postgresql replication and was wondering if it was somehow possible to listen to the replication binary log and push that to some tool like sumologic or splunk so that any ...
0
votes
1answer
612 views

Postgres pg_read_all_stats default role cannot read from my schema

I have a postgres user created with the pg_read_all_stats default role permissions which states the user should be able to read as if superuser. This works fine for any of the pg_stat_* tables. ...
1
vote
1answer
118 views

Postgresql similar of SQL Server Query Store

Is there any extension available for Postgresql that is similar to SQL Server query store. So that it can help identify performance bottleneck. SQL Server query store provides information on how many ...
0
votes
1answer
361 views

MySQL least privileges to get database/tables size

I'm using centreon_plugins to monitor some mysql databases. As a best practice I create a dedicated user for monitoring and I give it the least possible privileges. For simple monitoring I usually ...
2
votes
2answers
165 views

Usage of NON Clustered Index in SQL Server

I have 2 Index: CREATE NONCLUSTERED INDEX [IX_1] ON [dbo].[TableA] ( [Column1] ASC, [Column2] ASC ) CREATE NONCLUSTERED INDEX [IX_2] ON [dbo].[TableA] ( [Column3] asc ) Now I have 2 ...
2
votes
1answer
1k views

Understanding BinLogDiskUsage Metric behavior

We are using AWS-RDS. The following is the screenshot of how the binary log disk usage has varied over the last 6 weeks. The log retention period is 3 days. Tables are optimized and archived once a ...
1
vote
0answers
36 views

queries to active live test health of a galera cluster

What queries could be used to foresee or better fine tune alerts to check the health status of a Galera (MariaDB) cluster? The problem I am facing is that randomly the cluster gest stalled because of ...
0
votes
1answer
30 views

Temboard: when monitoring a server modifying postgresql.conf on the server is not effective?

I've installed the Temboard tool (http://temboard.io/) to start monitoring my postgresql server. I've noticed that when I modify the postgresql.conf on the server and I restart it, the change is not ...
0
votes
1answer
2k views

Which MySQL shows CPU usage?

I am monitoring MySQL server using phpMyAdmin [Status => Monitor] function. And it shows a number of useful graphs. Which variables (or which mechanism) is phpMyAdmin using to pull this data? ps. ...
0
votes
1answer
156 views

Monitoring PostgreSQL backup

I am new to PostgreSQL and have questions regarding the backup procedure. How do I check whether a PostgreSQL database was backed up successfully? And how do I monitor the backup? I have tried the ...
1
vote
1answer
1k views

How to get CPU usage in MySQL per user?

I want to know is there anyway to get CPU usage per user in MySQL? for example I have 3 different users 'user1', 'user2' and 'user3'. I want to get the average/real time memory usage and CPU usage of ...
0
votes
0answers
21 views

MYSQL need log executed query in table along with executed user name

I would to like the executed quires with entire database tables for some mysql users only. Because some of users executed wrong query in production environment. And needs to store this log in new ...
1
vote
0answers
56 views

How to Measure data consumed by an user in Azure sql server database?

For an Azure sql server MI, we have multiple external users consuming data, I would like to know how much data an user is consuming/extracting from the DB? Can this be checked from, 1.) From SSMS ...
-1
votes
1answer
21 views

Query showing which queries are processing with info about it in PostgreSQL

I'm pretty sure there is a query that shows which queries / processes are running in realtime. It shows which machine or user are running it, when they started and when they finish, and info like that ...
1
vote
1answer
3k views

How to monitor a file share witness for accessibility

In the context of a SQL Server Availability Group, what's the best way to monitor a file share witness for accessibility? I want to make sure the witness can be accessed by the Availability Group ...
0
votes
2answers
189 views

Monitoring Maintenance Tasks in AlwaysOn Clusters

I have an environment with multiple AGs on a single server and they encounter a split situation in which some end up on one node and some end up on the other node (in a failover event, perhaps). When ...
3
votes
2answers
374 views

How to minimize\plan ahead the effect of running sp_delete_backuphistory? Measure the gains too!

while running the following query: -- DATEADD (datepart , number , date ) DECLARE @dt DATETIME SELECT @dt = DATEADD(month,-6,getdate()) select @dt EXEC msdb.dbo.sp_delete_backuphistory @...
4
votes
1answer
1k views

how does CXPACKETS relates to CXCONSUMER wait types?

when running a delete query to a table that has many foreign keys I get the following waits. I noticed that I have both CXPACKETS and CXCONSUMER wait types at the same time during of the execution ...
0
votes
1answer
28 views

Find Source & Details of APL Heap Table Insert

I have been running system monitor(sysmon) on Sybase ASE 15.7(SP139) on HP-UX(Itanium) with below command: sp_sysmon "00:10:00" go Observed that number of inserts are very high in any time of a day, ...
0
votes
1answer
262 views

SQL Server: how to monitor activity in several databases

I have several dbs in production and I'd like to have a high level overview of the activity. Ideally I'd like to know: number of users accessing the db per day number of inserts per table per day ...
5
votes
3answers
946 views

Is there any way to determine how many rows a transaction has modified (before the transaction ends)?

I have a ~320 million row table on which I run the following query: UPDATE my_table SET state = TRIM(state) Needless to say this has been running for 90+ hours (since thursday afternoon) and has not ...
0
votes
1answer
821 views

How to trace security_error_ring_buffer_recorded errors in SQL Server 2014 Express

Just so everyone doesn't have a high expectation of my level of knowledge on this topic, I'm not a DBA; I'm a .NET developer who has to try and figure this out by virtue of being "the one most likely ...
5
votes
2answers
2k views

MySQL crashing at about 70k open files

Server running community 8.0.14, we hit the number of open files a few days ago, so I increased the limit but after a while the server crashed with this in the error log: InnoDB: We intentionally ...
0
votes
1answer
462 views

Integrating MongoDB metrices with Cloud watch

We are hosting mongodb in AWS environment and planning to create incident in Servicenow using AWS Cloud watch alarm facility Has anyone integrated MongoDB Monitoring metrices with Cloud watch to ...
0
votes
1answer
60 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
101 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
44 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 ...

1
2 3 4 5