search

microsoft / SqlNexus

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.
MIT License
348 stars 99 forks source link

Create a rowset to import High IO stats from sys.dm_io_virtual_file_stats #222

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago 
Column_name               Type           Length      Prec
------------------------- -------------- ----------- ----
runtime                   varchar        30              
runtime_utc               varchar        30              
database_name             varchar        40              
Physical_Name             nvarchar       520             
File_Size_MB              numeric        13          26  
Average_Read_Latency      numeric        9           10  
Average_Write_Latency     numeric        9           10  
Average_Bytes_Read        bigint         8           19  
Average_Bytes_Write       bigint         8           19