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
54 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
29 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
33 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
18 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
47 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
28 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
90 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 ...
0
votes
1answer
39 views

SqlServer Jobs Not Running - Job Activity Monitor

I have several dozen SQL Server jobs that the Job Activity Monitor displays that do not appear to have executed. Tools used and Version details: Microsoft SQL Server Management Studio 12.0.6024.0 ...
0
votes
0answers
14 views

Advice / Suggestions for Identifying Queries / columns updated in SQL Server 2012, executed by front end application [duplicate]

I have been tasked with putting a web based front end on sections of an SQL Server database. The current front end is cumbersome to use and isn’t very user intuitive. The database is for an old ERP ...
2
votes
2answers
152 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 ...
1
vote
1answer
133 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
21 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
27 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
277 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
72 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 ...
0
votes
1answer
282 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
20 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 ...
0
votes
0answers
28 views

How to know the size of data returned from a select statement using extended event in azure sql MI?

When a select statement is issued I would like to know the the query issued by the user and the number of rows returned along with the bytes/MB of data returned using extended events. With event ...
1
vote
0answers
51 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
885 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
46 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 ...
2
votes
2answers
190 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
345 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
0answers
244 views

Grafana Dashboard for postgres_exporter queries

Who uses postgres_exporter, tell me if you use https://github.com/wrouesnel/postgres_exporter/blob/master/queries.yaml ? if so, what Grafana Dashboard do you use? Thank you
0
votes
0answers
40 views

Is there a “@SkipChecks…” parameter equivalent for sp_BlitzFirst and sp_BlitzCache?

Silly question, how do I skip over certain databases when running sp_BlitzFirst and sp_BlitzCache? I'm on SQL Server 2008 R2 - Enterprise (10.50.4042.0). (I'm not sure how to get the First Responder ...
0
votes
1answer
24 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
37 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
228 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
445 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
1k 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
267 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
56 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
83 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
24 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
49 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
55 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), ...
0
votes
1answer
136 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
54 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
21 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
67 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
168 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
48 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
145 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 ...
5
votes
1answer
2k 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
2answers
245 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
65 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
109 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
54 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
781 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.