Skip to main content

Questions tagged [metrics]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
72 views

Azure SQL Server Metrics : is 100% CPU percentage is a blocker for all DB operations?

This is with Azure Sql managed Instance, We have observed a case in our database where the CPU percentage is 100% for quite some time but my application are still able to hit & operate over DB, is ...
Manoj's user avatar
  • 1
0 votes
1 answer
50 views

What are good metrics for determining the usefullness/impact of an index in a SQL server database?

Background I'm reviewing a database currently where someone applied indexes to almost everything in the database. Since we are now experiencing performance issues related to updating records, I'm ...
Tolure's user avatar
  • 111
0 votes
1 answer
177 views

Profile Read/Write Traffic to SQL Server

I am tasked with creating a new central database, with an all-new ERD / data schema, to replace a poorly designed database used by a range of applications. To assist with both design and capacity ...
Brent Arias's user avatar
2 votes
1 answer
539 views

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 ...
Brendan McCaffrey's user avatar
0 votes
1 answer
269 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 ...
liori's user avatar
  • 289
5 votes
1 answer
116 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 ...
DBADon's user avatar
  • 325
1 vote
1 answer
3k 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 ...
salmanarshad1999's user avatar
1 vote
1 answer
63 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 ...
Isaac A.'s user avatar
0 votes
2 answers
517 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 ...
youcantryreachingme's user avatar
1 vote
2 answers
246 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 ...
jericzech's user avatar
  • 945
0 votes
1 answer
1k 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.
Jeff Bauersfeld's user avatar
3 votes
1 answer
63 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 ...
Kellyleia's user avatar
2 votes
1 answer
6k 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 ...
Andrew Bickerton's user avatar
11 votes
2 answers
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 ...
Cole W's user avatar
  • 251
4 votes
1 answer
2k 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 ...
mon's user avatar
  • 211
2 votes
1 answer
1k 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 ...
user3681243's user avatar
15 votes
1 answer
367 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,...
Jason Davis's user avatar
0 votes
1 answer
3k 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?
Manjot's user avatar
  • 1,203
1 vote
1 answer
834 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 ...
Dejan's user avatar
  • 685