For the OLTP Transaction database what could be best sample interval for SQL Live Monitor tool?
As below - SQL Live Monitor sample interval for offline investigation in csv file
I am monitoring sample interval 5 seconds, is it sufficient for OLTP database? please suggestion me.
The sample interval will depend on the granulaity you want from the tool. 1 second would be the same as viewing perfmon in real time, 15 seconds if the default for permon captureing data to a file. Typically if you are capturing over time, then
you are looking for trends in the daya, so 5 secs to 15 secs should be fine. If however you want to see specific spikes at finer intervals then drop the sample interval down to 1 second.
The tool samples the data every seconds to display on the main form, so there is very little additional overhead in writning it out to aCSV at the same time.