Questions tagged [metrics]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
12 views

Is it good to monitor cluster or instance for RDS?

For these specifications, which unit should be monitored for good status checking? CPUUtilization DatabaseConnections FreeStorageSpace For example, this NRQL(New Relic Query Language) can query data ...
0
votes
1answer
59 views

Get current execution metrics from sys.dm_exec_sessions

I've got a pretty complex batch processing procedure that takes hours to run on real data. I've found that some CPU and I/O counters are stored in the master.sys.dm_exec_sessions table, and so thought ...
5
votes
1answer
84 views

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

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 ...
1
vote
1answer
49 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
271 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
2answers
154 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
967 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.
3
votes
1answer
55 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
5k 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 ...
9
votes
2answers
2k 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
774 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
349 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,...
0
votes
1answer
1k views

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?
1
vote
1answer
740 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 ...