[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 99
  • Last Modified:

Average/Maximum Read/Write I/O Waits for tables

Hello,

How can I collect Average/Maximum Read/Write I/O Waits for tables in db sql server?
Thanks
0
bibi92
Asked:
bibi92
  • 4
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You can query the performance counters dmv:
SELECT * 
FROM sys.dm_os_performance_counters
WHERE counter_name LIKE '%IO wait%'
   OR counter_name LIKE 'write%'
   OR counter_name LIKE '%reads%'

Open in new window

0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Or if you are talking only in disk thresholds, then check if this query is what you want:
SELECT * FROM sys.dm_io_virtual_file_stats(default, default)

Open in new window

0
 
bibi92Author Commented:
Hello,

I search the IO wait on tables.

Thanks

Regards
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
For that you have the sys.dm_os_wait_stats view.
Here the MSDN article about that view and information about all the wait types.
0
 
bibi92Author Commented:
Ok thanks but I have not found how I can check io waits per tables.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You need to understand the wait types so you can know which ones are you looking for.
Paul Randal's made a survey and he compiled the results of the most worrying wait type. You can start with those ones that are more typical for bottleneck issues.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now