2021. 11. 24. 16:39
SQL SERVER
https://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/
SQL Server IO Latency
How to easily pinpoint I/O bottlenecks from within SQL Server.
www.sqlskills.com
read_write_latency-sys.dm_io_virtual_file_stats.sql
Find out read write latency - sys.dm_io_virtual_file_stats
Find out read write latency - sys.dm_io_virtual_file_stats - read_write_latency-sys.dm_io_virtual_file_stats.sql
gist.github.com
'SQL SERVER' 카테고리의 다른 글
| DB 이관시 설정상태 체크, 변경 (0) | 2022.02.07 |
|---|---|
| Lock Or Expired된 계정 찾기 (0) | 2021.11.25 |
| SQL Server wait Statistics (0) | 2021.11.23 |
| linked server Disable하기 (0) | 2021.10.21 |
| IT/DBORACLE에서 MSSQL 마이그레이션 시 참고사항 (0) | 2021.05.25 |