Skip to main content
Database Administrators

Questions tagged [monitoring]

Ask Question

An ongong check of various statistics and events, which can be used to spot telltale signs of underlying issues.

289 questions
Newest Active Bountied Unanswered
41 votes
1 answer
86k views

I would like to get statistics about the peak number of connections over a period of time. I know the pg_stat_activity view, like select count(*) from pg_stat_activity, but I think this method is not ...
Jack Geller's user avatar
  • 513
30 votes
1 answer
29k views

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 ...
Rogelio Delgado's user avatar
  • 303
30 votes
3 answers
10k views

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 ...
BradC's user avatar
  • 10.1k
27 votes
4 answers
133k views

I like to get the latest executed statements within my database, along with performance indicators. As such, I like to know, which SQL statements were most CPU/DISK intensive.
Sebastian Roth's user avatar
  • 1,356
15 votes
4 answers
22k views

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 ...
Nick Chammas's user avatar
  • 14.9k
14 votes
7 answers
9k views

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?
user380719's user avatar
  • 243
13 votes
3 answers
19k views

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 ...
sorin's user avatar
  • 1,252
13 votes
2 answers
8k views

The issue We have a strange issue on our mongodb setup. Sometimes we get peaks of high connections and high queues and the mongodb process stops responding if we let the queues and connections ...
clopez's user avatar
  • 213
11 votes
2 answers
2k views

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 ...
JHFB's user avatar
  • 2,884
11 votes
2 answers
17k views

I'm running Postgresql on a Ubuntu server and need to be able to monitor its memory usage. Currently I have scripts running in a one-minute cron job that monitor/log various statistics and need to ...
Rauffle's user avatar
  • 213
10 votes
1 answer
29k views

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 ...
olle's user avatar
  • 1,027
9 votes
4 answers
16k views

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 ...
Łukasz Kastelik's user avatar
  • 1,405
9 votes
2 answers
10k views

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 ...
tostinni's user avatar
  • 243
8 votes
6 answers
9k views

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 ...
Magier's user avatar
  • 4,857
8 votes
6 answers
5k views

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 ...
wchrisjohnson's user avatar
  • 233

15 30 50 per page
1
2 3 4 5
…
20