• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • Last Modified:

How to calculate iops?

Hi

Can you tell me what am I missing to calculate  iops?

I have read  and write trans per second. What else do I need to calculate iops?


Can provide clear example?

Thx, m
0
michalek19
Asked:
michalek19
  • 6
  • 5
1 Solution
 
No MoreCommented:
0
 
michalek19Author Commented:
Based on what I have , what would be IOPs number?

DB      # of Read      # of Write
Axcx      16671511      898145
Axcxsdsd      6575984      913552
qer      8334046      763289
Axcxsdsdqeqwe      47583994      18902153
Axcxwerwerw      1422121      1636107
Axcx      3230227      265539
Axcx      393454      0
Erewrasdf      2555081      2935
Metereasdf      123513      229699
SFrweraSDf      322377      0
Sradsfasfas      1200      12
Srewawfe      1798607      24899186
0
 
Pawan KumarDatabase ExpertCommented:
Are you checking Disk IO performance for the entire DB? What Output you want from the above data ?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
michalek19Author Commented:
Correct disk up performance but I am looking for total IOPS
0
 
Pawan KumarDatabase ExpertCommented:
Can you give me the query you are using for above numbers >
0
 
michalek19Author Commented:
SELECT name AS 'Database Name'      
,SUM(num_of_reads) AS 'Number of Read'      
,SUM(num_of_writes) AS 'Number of Writes'
FROM sys.dm_io_virtual_file_stats(NULL, NULL) I  
INNER JOIN sys.databases D        
ON I.database_id = d.database_id
GROUP BY name ORDER BY 'Number of Read' DESC;
0
 
Pawan KumarDatabase ExpertCommented:
try this


SELECT SUM([Number of Read]) [Number of Read] , SUM([Number of Writes])[Number of Writes]
FROM 
(
	SELECT name AS 'Database Name'      
	,SUM(num_of_reads) AS 'Number of Read'      
	,SUM(num_of_writes) AS 'Number of Writes' 
	FROM sys.dm_io_virtual_file_stats(NULL, NULL) I  
	INNER JOIN sys.databases D        
	ON I.database_id = d.database_id
	GROUP BY name
)k
ORDER BY SUM([Number of Read]) DESC

Open in new window

0
 
michalek19Author Commented:
I got out put.  But what is the IOPS

Read                  Write
260407117        311814718
0
 
michalek19Author Commented:
I got this result

What these numbers represents?
What would be IOPS

 Read                  Write
 260407117        311814718
0
 
Pawan KumarDatabase ExpertCommented:
Wait I shall reply in some time.
0
 
Pawan KumarDatabase ExpertCommented:
These numbers represent Number of Read and Writes happened in all the databases present on the server.

IOPS
-Basically here we need Disc Read IO /Sec and Disc Write IO /Sec. Many people consider IOPS as SUM of  Disk Reads per sec and Disk Writes per sec but many consider other performance counters also. <<read more at - https://social.technet.microsoft.com/Forums/systemcenter/en-US/92ad3a22-49fb-4e60-9573-8b6f629cbbe9/monitoring-sql-iops?forum=operationsmanagergeneral>>

For IOPS please read article from Denny Cherry AC.
https://www.dcac.co/syndication/how-do-i-measure-iops-from-sql-server

Below url will also provide you another query which will provide some IOPS stats-
https://ask.sqlservercentral.com/questions/41131/obtaining-sql-server-specific-iops.html

Hope it helps !
0
 
michalek19Author Commented:
Thx
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now