We have a department who has a couple of SQL servers,they said there sometimes maybe disk I/O issues. That is all information I got from them. They would like me to help troubleshooting.
How can I help them to identify the problem using SQL server native tools.
I login to the server and found it has 24 GB memory and max memory set to 20 GB.
What information I need from them to start troubleshooting?
Currently it runs fine.
PS: I know I can use PM, DMV, or any other recommendations to start with?
I think I have to set up real time monitor, otherwise it will collect too many data to save somewhere, or shall I first ask them when the slowness usually happen to monitor a certain time period?