2
Vote

"Specify Microsoft SQL Server named instances" Only Named Instance

description

  1. Threshold Files.
  2. Select Microsoft SQL Server 2005/2008 File.
  3. Click Export to Perfmon Template File.
  4. Enter filename in Save As dialogbox and click OK.
  5. Enter instance name in "Specify Microosft SQL Server named instances".
  6. Now if you open up the XML file it generated we see counters for both Named Instance and Default Instance; when I only wanted/needed Named Instance.

file attachments

comments

splark wrote May 16, 2012 at 4:48 AM

I agree this is an issue. It would be nice to have a better interface to the SQL interface option than having that popup box come up every time you try to export.

It also doesn't seem possible to specify multiple instances with that popup, so it would be nicer to have something integrated into the rest of the GUI than have that popup.

mogupta wrote May 16, 2012 at 6:51 AM

Agreed, but I am still thankful for having this. Client does great job on this; as for the multi-instances. The functionality works fine ...

In the dialog box enter Inst01;Inst02;Inst03 and we get all three instances+default added to the counter list :).

ClintH wrote May 29, 2012 at 5:48 AM

I just fixed the bug where it always prompts for SQL named instances. I will release the new build later this week. It will probably be v2.3.1.
Regarding the including or excluding the SQL default instances, right now I use a simple InputBox to get the named instances into the export. To have the option of including or exclusing the default instance would require a custom form with an input box for the named instances and a checkbox to include the default instance or not, or I could just create a separate prompt for it. In any case, how would you prefer it ask about the default instance? Please keep in mind that I am not a professional developer. I know just enough VB.NET to get by, so please be gentle. :-)

mogupta wrote May 29, 2012 at 3:01 PM

Ha. Neither am I. You're still better than me :).

I was thinking of a similar solution.

What if your dialog box had a default value of "Default". If users wanted to add named instances they would just say "Default;Instance01;Instance02;" Or if they only wanted named instance they would say "Instance01;Instance02;". So your program only outputs default instance counters id the keyword Default is there?

ClintH wrote May 29, 2012 at 11:40 PM

Ah, that will work. I'll do that. Thanks!