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
1 vote
2 answers
135 views

How to measure the cost of enabling Query Store?

Enabling Query Store can have performance benefits, particularly as of SQL Server 2022, but what about the costs? The documentation insists that the costs are small, but I want proof on my own system. ...
0 votes
0 answers
19 views

What are the possible ways to Monitor the state of Log Reader agent job?

Monitoring of Log reader agent job in a way that whenever it is not running/executing it would triggers an alert, or is there any way of registering the state of log reader agent job as an event in ...
1 vote
1 answer
75 views

How can I verify if Read Committed Snapshot Isolation is causing application problems that Read Committed would not?

Suppose that I've turned on RCSI and my server is doing just fine; There have been no spikes in resource usage and the increased load on tempdb has been minimal. This is all good, but how can I tell ...
0 votes
0 answers
111 views

In the past week, SELECT StatMan [...] has run 150,000 times. Is this normal?

I retain a week's worth of Query Store data. I was inspecting it for one database earlier today and found something surprising. This query SELECT * FROM sys.query_store_query AS qsq INNER JOIN sys....
1 vote
1 answer
2k 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
1 answer
11k 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. ...
1 vote
1 answer
49 views

Can the plan cache be used to diagnose a lack of RAM?

I have learned a few good ways to diagnose a lack of RAM on a SQL Server and I am wondering if I should add the plan cache to this toolbox. A sign of lacking RAM is that the plan cache doesn't live ...
1 vote
1 answer
85 views

how to find out the free space inside a database file when the database is not online?

Normally when the database is online I use the following query and get how much space is free inside each file: SELECT CONVERT (decimal(12,2) , (CONVERT(...
1 vote
3 answers
85 views

What is the Postgres Equivalent of SQL Server's Query Store?

I consider Query Store to be the best idea that Microsoft's SQL Server has had in the past ten years. I worry that I will miss it very dearly when I move to Postgres. What equivalents does Postgres ...
0 votes
1 answer
3k views

Replication Monitor Missing Subscriptions in Watch List

In Replication Monitor, for one of our publications (transactional replication), none of the subscriptions are showing up in the Subscription Watch List. This is new behavior that just started ...
0 votes
1 answer
65 views

What are the typical uses of the Data Collector?

The Data Collector is the single most obscure SQL Server concept that I know of. I have never even seen it mentioned in a professional or educational context, never mind used. I don't even think that ...
0 votes
1 answer
90 views

Auditing for direct Object Access (Skipping indirect access)

to isolate internal tables from third party database access, we've created schemas specifically for that use case. Third party Logins/DB Users only have access to those "public" Schemas. The ...
-4 votes
2 answers
121 views

Why Prefer Extended Events to sp_WhoIsActive and Query Store?

If I want to find out what is happening right now, then I use Adam Machanic's sp_whoisactive. If I want to find out what has happened on my server recently, then I will use Query Store. Extended ...
5 votes
3 answers
640 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 @...
2 votes
1 answer
185 views

What are the advantages and disadvantages of inspecting the Plan Cache rather than the Query Store?

The Plan Cache and the Query Store are not the same, even for the same query. When hunting for performance or monitoring information on a specific query or set of related queries, what are the ...
7 votes
0 answers
197 views

Find a previous statement or held locks in a blocking situation

I'm using XE blocked_process_report to detect and analyse the blocking. But since it's a point-in-time situation, I only see the blocking leader's statement currently being run and the incompatible ...
0 votes
1 answer
2k 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.
1 vote
2 answers
96 views

How can we analyze everything an application does in SQL Server? [closed]

I'm not a DBA (yet) but this seems a DBA-type question rather than a programming question. I've been asked: Which queries are called most frequently? How many times are they called during a normal ...
3 votes
2 answers
2k views

Is there a way to get a history of transaction log used space in SQL Server?

I would like to be able to look back and see what the used space was in transaction log over a given period. Not interested in growths or file size as they don't tell me how much space is actually ...
0 votes
1 answer
318 views

Is there a way to monitor indexes in Oracle 19c

Is there a way to monitor indexes in Oracle 19c? I have turned index monitoring on ALTER INDEX my_index_i MONITORING USAGE; Using the queries below to get a rough idea when an index was used: SELECT ...
1 vote
1 answer
135 views

track down which application / procedure / function modified the value of a column in a specific table

in our enterprise application, value in one column of a table is being modified at client side. This happen usually once in a week. i have verified in all stored procedures and other modules, value in ...
2 votes
3 answers
1k views

Database Last Usage

Is there a way to find out when a database was last accessed on SQL Server 2000? By this I mean, had a table read, a stored procedure called etc... I have a list of databases and I am trying to find ...
2 votes
1 answer
1k 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 ...
2 votes
1 answer
1k 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
3 answers
500 views

How to monitor slow queries time on Mariadb

I have multiple MariaDB instances that I monitor with mysql exporter on grafana. I have spotted some slow queries recently which took more than 300 seconds by looking at the process list of the ...
0 votes
0 answers
61 views

How to monitor Postgres workers' utilization?

I have a client who has a legacy application using a Postgres DB. They have SEVERE performance issues, so they figured it might be a good idea to scale their DB server to the GCP's max. Performance ...
0 votes
0 answers
7 views

How to consult the number of connections from specifics clients or ips in my secondary nodes

I need to know how to consult the number of connections from specifics clients or ips in my secondary nodes, I have a replica set composed of 3 nodes (one primary node and two secondary nodes), the ...
2 votes
1 answer
157 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 ...
0 votes
2 answers
155 views

Use extended events to track autoupdate statistics on a specific table

I'm trying to find a way to track a table that has auto update statistics on, I'm trying to track how often it auto updates and at what intervals. The table in question is used quite often and because ...
14 votes
7 answers
9k views

How can I profile SQL Azure?

I am writing a web site that uses SQL Azure heavily. However, it is painfully slow. Is there an easy way to profile the live SQL Azure instance?
1 vote
2 answers
265 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 ...
1 vote
1 answer
70 views

Can I develop a Dashboard Report for Data Allocated vs Max Storage for my Azure Database?

I have an Azure SQL Server Database - Managed Instance I'd like to monitor. Here is the widget that Azure shows me on the database summary page. I'd like to put this widget, or at least the ...
4 votes
2 answers
13k views

What to look for in bad pg_dump log

We want to programmatically detect errors in cron scheduled pg_dumps. Apart from cheking whether or not the log file ends in "pg_dump: saving database definition": What other tell-tale string can I ...
2 votes
4 answers
542 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
1 answer
184 views

How can I monitor and address fragmentation on RDS for Oracle database?

I'm planning to migrate my database from on-premises to AWS RDS for Oracle. However, I'm not sure if Amazon RDS supports tools such as Automatic Fragment Advisor or the Automatic Segment Space ...
2 votes
4 answers
18k views

Counting postgres open connections without SQL query or connecting to postgres itself

For a monitoring script I need to count the number of open connections to a postgres database. This is done easily enough by opening up a client connection and running a count on the pg_stat_activity ...
13 votes
3 answers
17k views

How to properly monitor the number of PostgreSQL database connections?

I tried to use a Nagios script for monitoring the number of database connections on a Postgres database and I reached this problem: these are counted as currently open-connections and measured every 5 ...
0 votes
2 answers
89 views

Only zeros are returned in APPL_IDLE_TIME value from SNAPAPPL admin view

On Db2 v11.5.8.0 on Linux I would like to get how many seconds have elapsed since application issued last request in current connection. Check monitor switches db2 get monitor switches | grep ...
1 vote
1 answer
1k 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 ...
0 votes
1 answer
358 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
0 answers
105 views

Get e-mail addresses of failed subscriptions for SSRS data driven subscription

We are using SSRS Enterprise and have implemented data driven subscriptions. We have implemented a monitoring solution to inform us of failed sends. However, even after increasing verbosity to the max ...
0 votes
1 answer
47 views

How to find which queries are being run at a particular time

I have successfully implemented the tip described here to automate the collection of SQL Server database connections. I am getting the messages when this occurs and I have narrowed down the issues to ...
-1 votes
1 answer
154 views

sp_BlitzCache detecting thousands of executions of CREATE PROCEDURE dbo.CommandExecute (from Ola Hallengren's Maintenance Solution) [duplicate]

I recently implemented the Maintenance Solution as a nightly job in my company's database, via Windows Scheduler. It works as intended, except for one issue - the procedures are being created ...
0 votes
1 answer
90 views

I am trying to monitor Azure managed cassandra nodes using Promethous and Grafana

I have setup promethous and Grafana on Azure VM to monitor Azure managed cassandra using below document. https://learn.microsoft.com/en-us/azure/managed-instance-apache-cassandra/visualize-prometheus-...
2 votes
1 answer
6k 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 Always-...
0 votes
0 answers
678 views

PostgreSQL Database Data and Log size

I am looking for a way to list PostgreSQL Database Data and Log sizes. Using the following command we can check the total database size based on the documentation https://pgpedia.info/p/...
-1 votes
1 answer
66 views

Performance Metrics are missing for a problem timeframe [closed]

There was a problem time frame of 30 mins (22:00 to 22:30) during which queries had performance issues - bad execution plans, which led to high CPU. That's what monitoring tool shows: CPU: Checking ...
5 votes
1 answer
1k views

Method or Counter to track dropped connections in SQL Server?

Our production server is running SQL Server 2008 (non r2). I'm working on investigating and issue that appears to be networking or connection related, where our web server is losing or dropping ...
2 votes
1 answer
1k 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 ...
1 vote
1 answer
223 views

MS SQL Performance Monitoring over longer period

I am having an issue where the DB resources are being used up by someone in the business external to the application. Ignoring how unsafe and incompetent this is as it's not my business, how can I see ...

1
2 3 4 5 6