michalek19
asked on
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
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
http://wintelguy.com/raidperf.pl
ASKER
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
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
Are you checking Disk IO performance for the entire DB? What Output you want from the above data ?
ASKER
Correct disk up performance but I am looking for total IOPS
Can you give me the query you are using for above numbers >
ASKER
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_sta ts(NULL, NULL) I
INNER JOIN sys.databases D
ON I.database_id = d.database_id
GROUP BY name ORDER BY 'Number of Read' DESC;
,SUM(num_of_reads) AS 'Number of Read'
,SUM(num_of_writes) AS 'Number of Writes'
FROM sys.dm_io_virtual_file_sta
INNER JOIN sys.databases D
ON I.database_id = d.database_id
GROUP BY name ORDER BY 'Number of Read' DESC;
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
ASKER
I got out put. But what is the IOPS
Read Write
260407117 311814718
Read Write
260407117 311814718
ASKER
I got this result
What these numbers represents?
What would be IOPS
Read Write
260407117 311814718
What these numbers represents?
What would be IOPS
Read Write
260407117 311814718
Wait I shall reply in some time.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thx