typeperf, logman and “Call to SQLAllocConnect failed with %1.”

Typeperf and Logman make automating performance counter data gathering much easier. Especially if you use them to log the counters directly to a SQL Server database, so you can then slice and dice, or combine stats across multiple boxs (a god send for complete Dynamics CRM environments).

Generally I’ll use typeperf for checking I’ve got the basic settings right as it’s a bit quicker to check, and then move over to logman for the actual work.

But there are a couple of gotchas to watch out for when setting them up. These examples assume you’ve got a system DSN called perfmon pointed at the correct database, you’re using Trusted Connections and you’ve a list of counters in the file

Stuart Moore

Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

No comments yet.

Leave a Reply