Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [metrics]

The tag has no usage guidance.

1
vote
1answer
36 views

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 ...
0
votes
2answers
68 views

Log flushes per second appears low

I've newly taken over administration of a system with about 25 databases. Using Redgate Monitor to chart some metrics, I see that each day, one database shows values for log flushes / second that look ...
1
vote
1answer
71 views

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 ...
0
votes
1answer
428 views

DBA_TABLESPACE_USAGE_METRICS is empty

For one of my 11.2g databases, select * from dba_tablespace_usage_metrics returns no rows. Why is that and how can I fix it? Thank you in advance.
4
votes
1answer
54 views

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 ...
2
votes
1answer
2k views

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

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 ...
7
votes
2answers
581 views

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 ...
4
votes
1answer
1k views

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 ...
2
votes
1answer
256 views

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 ...
15
votes
1answer
304 views

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,...
1
vote
1answer
518 views

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 ...