Red Gate forums :: View topic - unable to profile SQL Server
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
ANTS Performance Profiler 6
ANTS Performance Profiler 6 forum

unable to profile SQL Server

Search in ANTS Performance Profiler 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
trevor lane



Joined: 29 Aug 2010
Posts: 5

PostPosted: Wed Sep 08, 2010 3:02 am    Post subject: unable to profile SQL Server Reply with quote

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?
Back to top
View user's profile Send private message
AndrewH



Joined: 17 Aug 2006
Posts: 137

PostPosted: Wed Sep 08, 2010 10:52 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Josh



Joined: 09 Oct 2010
Posts: 1

PostPosted: Tue Oct 12, 2010 10:33 pm    Post subject: Same problem Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group