Questions tagged [metrics]
The metrics tag has no summary.
24 questions
-1
votes
1
answer
61
views
Collect OS metrics in Idera [closed]
I use idera for monitoring database servers but recently I noticed that some servers (no all of them) are not monitoring the disk part properly.
The error I get is:
TITLE: Monitored SQL Server ...
- 47
2
votes
1
answer
955
views
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 <database name>
got:
latency average = 9.787 ms <- should i take this as the ...
- 21
-3
votes
1
answer
197
views
SQL Server statistics logical reads negative number
I am trying to understand and analyse a CPU intensive select query in SQL Server, however, I see something strange which is a negative number as logical reads. I wonder if it is a mathematical ...
-1
votes
1
answer
160
views
How do I measure the SQL Database responsiveness
I am load testing my web app which is Azure App Server + Azure SQL Database.
I am looking at the the Azure data dashboard metrics as we load test it and most measures (DTU percentage, CPU percentage, ...
- 189
0
votes
1
answer
574
views
Azure SQL Server Metrics : is 100% CPU percentage is a blocker for all DB operations? [closed]
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 ...
- 1
1
vote
1
answer
777
views
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 ...
- 51
0
votes
1
answer
102
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 ...
- 111
0
votes
1
answer
413
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 ...
- 191
2
votes
1
answer
904
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 ...
- 3,464
0
votes
1
answer
424
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 ...
- 289
5
votes
1
answer
163
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 ...
- 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 ...
1
vote
1
answer
97
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 ...
- 11
0
votes
2
answers
624
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,677
1
vote
2
answers
324
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 ...
- 977