Could you please check if there is an issue when you run the pssdiag for long and it has to recycle the counters, it is failing to do so not at the time of run but when you try to load the data in SQL nexus. It fails with error ,
" multiple roots, xml line reference number ''xxxx'' has an error.
I have to modify the PSSDIA.xml in internal folder delete the extra node created created with <SQLDIag> forms half node with incorrect spelling </SQLDIAG>erform
PerfmonCounter name="\FailedQueries/sec" enabled=
- no ending , no proper formation of XML.
Thanks for the support.