This is a collection of my notes that I most frequently refer back to. Hopefully some of these may come in handy for others. NOTE: I take no responsibility for your systems if you follow these notes. Always do you own research and make sure you understand fully what it is you are doing.
Wednesday, 20 December 2017
Wait Stats MS SQL
Run the following query to see the PAGEIOLATCH wait stats for your database server
select * from sys.dm_os_wait_stats where wait_type like 'PAGEIOLATCH%' order by wait_type asc
No comments:
Post a Comment