mxdperfstat for SQL Server with the default instance name

Question

Hi First time I'm trying to use the mxdperfstat on a non-named instance. Normally I would specify ..... -host -instance .... and it works perfectly. However, specifying only the host ..... -host ...... (without the instance name) wouldn't work. According to this :https://stackoverflow.com/questions/3449397/connection-string-for-default-instance-like-for-named-instance Specifying MSSQLSERVER as the instance name wouldn't work, and in fact it doesn't. Has anybody used mxdperfstat with a default instance name?

CalinArens · Answer

I had the same problem. To fix, use: -host <myhost> -instance " "

MarcoBoeringa · Answer

I don't know if it is a good replacement, but this ESRI tool:

Calibrating ArcGIS Performance with PerfQAnalyzer: New Build Available for Download

seems more recently maintained (recent update this month), and may do what you want.