Currently , i'm facing issue with Load job which is running slow. This load job run during peak hour concurrently 9 load jobs. this load job other time also but never face any issue it's complete in time but peak time earlier it complete in time but now these days it's taking long time. As per my investigation and finding disk I/O wait is there, so kindly suggest which snapshot I need to generate which will give us exact picture of disk i/o wait.
Also suggest which statistics will help me to diffrentiate that peak time statistics is bad means heavy load on disk and during normal time it's good.).
Looking your answer ASAP. because it's prod issue.