Tag Archives | performance

Hunting for select * with Extended Events

After a question from Alex Whittles (t|w) during my Extended Events session at the Leicester SQL Server User Group

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

Stuart Moore

About 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

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

Stuart Moore

About 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

Any days a good day if you can learn something

Had one of those days where I didn’t do anything stunningly impressive as every job seemed to be just some tinkering to fix other people’s problems.

But looking back on it the day has bee a great success as each one of the three problems lead to me revising some old skills or learning more about something I’ve not had to play with as much before hand

One of them was a classic developer’s SQL Server performace problem with parameter sniffing. One set of parameters pushed for a full scan and a spooled sort,

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

Stuart Moore

About 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