unable to profile SQL Server

Code profiling for .NET Developers

unable to profile SQL Server

Postby trevor lane » Wed Sep 08, 2010 2:02 am

I am getting a warning when I switch to analyse SQL Server saying "No event provider could be located for the SQL server instance 'MSSQLSERVER'"

What does that mean?
trevor lane
Posts: 5
Joined: Sun Aug 29, 2010 1:32 am

Postby AndrewH » Wed Sep 08, 2010 9:52 am

It means that you have an instance of SQL Server that hasn't got a registered ETW event provider. The event provider is implemented incorrectly in SQL Server, so it's not possible for ANTS to detect the real reason there's a problem.

The most likely cause is that the instance is SQL Server Express: Microsoft turned off event tracing in that version, so ANTS can't profile it. The cheapest edition of SQL Server with this feature is the developer edition. You can have both Express and other versions of SQL Server installed, in which case ANTS will profile the other editions but will warn about the Express instance.

If the installer failed to compile the etwcls.mof file for that instance of SQL Server, then you'll also get this error message. You'll find this file in the installation directory for the instance you're interested in (C:\\Program Files\\Microsoft SQL Server\\MSSQL10.SQL2008\\MSSQL\\Binn, for example). You can install it by running 'mofcomp etwcls.mof'.

I think this can also happen if the instance has been renamed at some point in the past. You'll need to edit the .mof file so that the description matches the new instance name (it's at the top, and should be '<instance name> Trace'. The other names don't actually matter.

You can see the installed event providers by running the command 'logman query providers' from an admin command prompt. For any given SQL Server instance that isn't Express, there should be a '<instance name> Trace' entry.
Andrew Hunter
Software Developer
Red Gate Software Ltd.
Posts: 118
Joined: Thu Aug 17, 2006 2:44 pm

Same problem

Postby Josh » Tue Oct 12, 2010 9:33 pm

I'm getting the same problem on Win2008 server with an instance of Sharepoint. Is there another way to remedy this other than editing the mof file?

Thanks, Josh
Posts: 1
Joined: Sat Oct 09, 2010 12:56 am

Return to ANTS Performance Profiler Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests