Questions tagged [monitoring]
An ongong check of various statistics and events, which can be used to spot telltale signs of underlying issues.
289 questions
1
vote
1
answer
22
views
What does the Dedicated Admin Connection offer that Resource Governor does not?
The Question
What resources does the Dedicated Admin Connection reserve that I cannot reserve myself with Resource Governor? If I were a genius with Resource Governor, could I turn the Remote DAC off ...
- 1,398
1
vote
1
answer
24
views
How can I use Resource Governor purely as a monitoring tool?
It is clear that Resource Governor monitors how much work each group is doing. sys.dm_resource_governor_workload_groups makes this utterly obvious.
Suppose that:
I don't yet trust my ability to ...
- 1,398
2
votes
1
answer
419
views
Do canary tables make sense for Availability Groups?
For all HA or DR solutions in SQL Server, I have heard that it is smart to have a table with a timestamp column in each database and to have an Agent Job run every minute to update that timestamp with ...
- 1,398
3
votes
2
answers
637
views
Tracking stored procedure performance metrics
I’m trying to track impacts of stored procedure executions - CPU time, execution duration, logical/physical reads, memory grants, etc. - in order to visualize them. In particular, I'm looking for ...
2
votes
2
answers
220
views
How can I tell if my BPSORT waits are the result of spilling batch mode sorts?
BPSORT sort waits mean that I have batch mode sorts. This is okay. However, I'm aware that batch mode sort spills are very slow. How can I tell if a query that appears to have high BPSORT waits is ...
- 1,398
0
votes
3
answers
253
views
Auditing/Monitoring the DBA
We have a customer that would like to make sure that certain tables are not tampered with by their DBAs for compliance reasons.
From my understanding their DBAs either do have or are able to run with ...
- 23
2
votes
1
answer
164
views
pg_stat_statements displays only useless 9 queries despite tens of queries are executed per second
In PostgreSQL v15.10 I have installed pg_stat_statement extension and \dx shows it is at version 1.10. I have restarted the postgres cluster after install and extension settings setup.
I reset ...
- 550
-1
votes
1
answer
61
views
Collect OS metrics in Idera [closed]
I use idera for monitoring database servers but recently I noticed that some servers (no all of them) are not monitoring the disk part properly.
The error I get is:
TITLE: Monitored SQL Server ...
- 47
2
votes
2
answers
375
views
Azure MS SQL: grant sys.* and msdb.dbo.* select permissions for Grafana monitoring
I'm trying to monitor Azure MS SQL databases using this Grafana dasboard. It executes several queries to tables whose names start with sys and msdb.dbo.
I've created a dedicated grafana user for this ...
- 141
-2
votes
1
answer
325
views
How can I figure if a query is CPU-bound or I/O-bound?
I have a query that runs regularly. It runs in under a second, but I consider it too slow and I would like to tune it. I can either monitor it as it runs live or copy the query text and run it myself. ...
- 1,398
0
votes
1
answer
57
views
Can you 'monitor' curl/ HTTP requests to Snowflake API to see issues?
I'm using a 3rd party tool that can 'connect' to Snowflake API but is throwing errors. They are translating/ botching something on their end, as I can get the Snowflake API easily working with about 5 ...
- 1,739
1
vote
1
answer
557
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 ...
- 1,398
-1
votes
2
answers
2k
views
How can you monitor for schema changes?
In short, I want to monitor for schema changes to a database, specifically SQL Server.
I know there are tools which can compare a database to source control, but this is not what I am looking for. I ...
- 1
0
votes
0
answers
59
views
Is there any top-similar command to monitor mysql processes?
I would like to know if exists any command to live monitor processes of a mysql server.
I currently use show processlist; but this is a mysql command (not a bash command) and it doesn't refresh ...
- 211
2
votes
3
answers
923
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 ...
- 1,398