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
20
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
1
vote
1
answer
21
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
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
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
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 ...
-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
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
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
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
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
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
0
votes
1
answer
126
views
Track the connection history to a certain table in SQL Server
Is there a way to keep the connection history to a certain table in SQL-server?
Not just the database because that's easy using the DMV's but just one particular table.
- 151
0
votes
0
answers
175
views
How can you determine if the Service Broker is in use?
I've inherited a server where all databases have the Service Broker enabled. I suspect that only SSRS uses it. Given a database where the Service Broker is enabled, what signs indicate that it 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
0
votes
0
answers
42
views
Monitor delay for updating index on deletion
I'm aware than adding / removing data to a table that has one or more index can slow down the operation.
However, I'm wondering how I could monitor that (on postgresql).
When I delete data in one ...
- 101