Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [metrics]

24 questions
15
votes
1 answer

Metrics to prove or disprove the need for additional DBA's?

We currently have 2 DBA’s, me and one other guy and we both feel the need for an additional resource (or two). I have had the conversation with my direct manager on this topic a couple different times, but am having difficulty in getting the notion…
Jason Davis
  • 193
  • 7
11
votes
2 answers

Switching to RCSI

The company I work for currently uses SQL Server databases (latest Enterprise version usually) for a product we develop. I would describe it as an OLTP database that is somewhat equally write and read intensive with a lot of time critical apps. In…
Cole W
  • 251
  • 1
  • 4
5
votes
1 answer

Performance Metrics After Enabling Auto-Stats

Short Version After enabling AUTO_CREATE_STATISTICS & AUTO_UPDATE_STATISTICS_ASYNC on a database, what performance metric will best display the changes? Long Version We just realized that the database for a legacy system has never had the…
DBADon
  • 325
  • 2
  • 8
4
votes
1 answer

Cassandra - Why does Read/Write Latency fluctuate?

Question Why does write (read as well) latency fluctuate in Cassandra? Background Running Cassandra Stress Tool on a node (s01) against another node (m01). Run several times but always saw the latency (write as well as read) always flucuating. The…
mon
  • 211
  • 1
  • 7
3
votes
1 answer

Easy way to get DB Measurements?

My senior management would like to have some counts of database objects (databases, tables, rows, stored procedures, etc) to show complexity to the executive committee. Does anyone know of a quick way to get this information? I'm going after system…
Kellyleia
  • 31
  • 1
2
votes
1 answer

Finding execution time of a psql query (without any connection latency/overhead)

How do I find the execution time of a query? I tried these methods: pgbench - pgbench -n -t 1 -f ./query.sql got: latency average = 9.787 ms <- should i take this as the execution time? initial connection time = 12.481 ms tps =…
Prasanna
  • 21
  • 2
2
votes
1 answer

Report Uptime Metrics for SQL Server by Database/Application

I have a requirement to report monthly metrics on SQL Server uptime, by application/database. This would be at the cluster level. I.E., if a secondary replica went offline, but a primary was still available to process transactions, uptime would…
Brendan McCaffrey
  • 3,444
  • 2
  • 8
  • 29
2
votes
1 answer

How long does a failover for SQL Server Availability Groups take?

In trying to determine the most appropriate High Availability option we are focused on reducing downtime (either planned or unplanned). I've been able to gather stats (from reading lots of MSDN documentation and blogs) on Failover Cluster…
Andrew Bickerton
  • 3,254
  • 5
  • 30
  • 38
2
votes
1 answer

Best way to find out read/write distribution in MySQL?

People often say things like "application X is write heavy", 20/80 write vs reads, etc. What metric(s) is most relevant for MySQL when checking if an application is write/read heavy? Is checking Com_insert, etc enough, not taking into account…
user3681243
  • 23
  • 4
1
vote
1 answer

How to track IOPS statistics?

Is there a way to access statistics about IO operations per second in DB2 9.7? I am not interested in the buffer pool hit ratio, just IOPS. Storage managers reported us that a few days ago average IOPS is over 5000 (previously it was 300 they…
Dejan
  • 695
  • 7
  • 20
  • 34
1
vote
1 answer

Database tablespace space sizes and percent used

I am new to Oracle, and I am not quite understanding the size calculations shown in OEM under tablespaces. I know it should be simple and my well be. I need to monitor the table space but not sure what I am looking at. Should I go after the…
jmichaelwDBA
  • 51
  • 6
1
vote
1 answer

How to determine queries per hour executed by a particular MySQL user?

I am trying to implement user based quota system in MySQL to limit MAX_QUERIES_PER_HOUR for a particular user. I have an option to set this limit via MAX_UPDATES_PER_HOUR 10. But my problem is that I want know that how many queries a user has…
salmanarshad1999
  • 11
  • 1
  • 2
1
vote
1 answer

Pages Input per Second Spiking Daily

I'm still learning a lot about SQL Server and pretty green, but doing the best I can as an accidental DBA. We have recently purchased a SQL monitoring software package, and after adjusting the threshold on alerting so I'm not bombarded with false…
Isaac A.
  • 11
  • 1
1
vote
2 answers

Decision concerning RAM limit

What steps would you do to be sure that STANDARD edition with its 128GB RAM limit is enough for your production? My subjective feeling is that we are somehow on the edge and I am looking for strong arguments to do the right decision to the…
jericzech
  • 977
  • 8
  • 22
0
votes
1 answer

T-SQL to find memory, CPU, and IO utilization

I want to identify resource (CPU, memory and IO) usage by a database on a SQL Server 2005 and above server, over a week or a month. Can anyone please help in this?
Manjot
  • 1,213
  • 2
  • 21
  • 29
1
2