Temdb PageIO_Latch issue

• Less than 10 ms - very good
• Between 10 - 20 ms - okay
• Between 20 - 50 ms - slow, needs attention
• Greater than 50 ms - Serious I/O bottleneck

 if the disk write Transfer/ms greater than 50 ms , then we will need t

select db_name(database_id),

io_stall_read_ms/num_of_reads AS 'Disk Read Transfer/ms',

io_stall_write_ms/num_of_writes AS 'Disk Write Transfer/ms'

from sys.dm_io_virtual_file_stats (2,1)