topic Re: mxdperfstat for SQL Server with the default instance name in Data Management Questions

mxdperfstat for SQL Server with the default instance name

HenWagner — Wed, 12 Feb 2014 10:18:27 GMT

Hi

First time I'm trying to use the mxdperfstat on a non-named instance.
Normally I would specify ..... -host <myhost> -instance <myinstance> .... and it works perfectly.
However, specifying only the host ..... -host <myhost> ...... (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?

Re: mxdperfstat for SQL Server with the default instance name

MarcoBoeringa — Wed, 12 Feb 2014 18:25:10 GMT

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.

Re: mxdperfstat for SQL Server with the default instance name

CalinArens — Tue, 26 Aug 2014 12:05:24 GMT

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