Questions tagged [monitoring]
An ongong check of various statistics and events, which can be used to spot telltale signs of underlying issues.
27 questions
2
votes
1
answer
6k
views
Create a custom log table in MySQL
Is it possible to create a custom log table. For example I have 10 schema and I would like to log if somebody is using the "areva" schema. I want to know the last executed command time and the user. ...
- 1,007
1
vote
2
answers
6k
views
How can you monitor if MySQL binlog files get corrupted?
I was wondering if there was any nice way to continuously monitor mysql master binlog files and detect if get corrupted.
- 21
15
votes
4
answers
22k
views
How can I have SQL Server email me the error details when a job fails?
SQL Server lets you configure a job to send email alerts when it fails. This is a simple and effective way to monitor your jobs. However, these alerts do not include any detail--just a success or ...
- 14.9k
10
votes
1
answer
29k
views
How can I monitor the call count per stored procedure per timespan?
In order to diagnose some performance issues I would like to get a better understanding of the number of times certain procedures are called compared to the system performance. Is there a way to get ...
- 1,027
9
votes
4
answers
16k
views
Monitoring free space in SQL Server data files
I have manually resized mdf/ndf files to a big size to avoid autogrow operations on SQL Server databases.
Since the files are bigger there is very little free space on disk partitions and the ...
- 1,405
8
votes
6
answers
5k
views
Recommendations for MS SQL Server monitoring software or service? [closed]
I have a client with MS SQL Server instances (2000, 2005) scattered across 20-30 servers. I've been engaged to get things organized and will be periodically reviewing the state of the database ...
- 233
4
votes
2
answers
6k
views
LOG all SQL Server queries with their durations
Is there a way to log all Microsoft SQL Server queries executed on a certain server, with their respective durations?
I'd like to be able to analyze all queries will a tool like what PGBADGER does ...
- 235
0
votes
3
answers
4k
views
Metrics for monitoring master-slave replication
Is there some kind of query/view/table available in PostgreSQL that can reflect the actual status of a master-slave replication process? Perhaps the "degree" of sync between the nodes?
The above is ...
- 1,069
0
votes
0
answers
553
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,398
30
votes
3
answers
10k
views
Which PowerShell technique should I use to talk to SQL Server?
I'd ultimately like to use PowerShell to replace the old KornShell scripts we use for SQL instance monitors. I'm having a hard time, though, getting my brain around all the different ways that ...
- 10.1k
11
votes
2
answers
2k
views
alert when any job in a job category fails
Is it possible to set up an alert in SQL Server 2008 that will send an e-mail anytime a job in a specific category fails?
I am wondering because I would like to set up an e-mail anytime an SSRS ...
- 2,884
9
votes
2
answers
10k
views
Monitor MySQL activity per database?
What is the best way to monitor activity on each database of my server ?
I tried mtop/mytop which display activity in real time but aren't very practical to see all the queries executed on it.
I ...
- 243
8
votes
6
answers
9k
views
Creating SQL Server Performance Baseline Monitoring
In order to get an overview and compareable data my current task is to create a performance baseline to get some figures about the different productive SQL Server instances.
My thoughts are:
I want ...
- 4,857
6
votes
2
answers
1k
views
How to verify disk hit by a query
I want to know how to verify disk hits by a select query in PostgreSQL 9.4 on CentOS 6.5. Also please let me know how far enabling the log_statement_stats in the postgresql.conf will help me.
I need ...
5
votes
2
answers
391
views
reporting space consumption to files in filegroup - how to reverse-engineer the algorithm spreading data across files
I would like to know how to calculate the distribution of data consumed per file in a filegroup, back to the index (HEAP, CLUSTERED, NONCLUSTERED) storing it. My intention is to define which I/O goes ...
- 418