Red Gate forums :: View topic - Profiler is picking the wrong SQL instance
Return to www.red-gate.com RSS Feed Available

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

Profiler is picking the wrong SQL instance

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



Joined: 17 Apr 2011
Posts: 3
PostPosted: Sun Apr 17, 2011 3:59 pm    Post subject: Profiler is picking the wrong SQL instance Reply with quote
I am profiling an ASP.NET web application through IIS. The application is configured to use a local instance of SQL Server 2005 Standard. The instance name is SQLSTD.

When I profile the application and enable SQL profiling, it never collects SQL data and complains about SQLEXPRESS. I do have SQL 2008 express and 2008 R2 express installed as well. Maybe this is confusing it?

I also confirmed that the trace provider is enabled for my SQLSTD instance by running 'logman query provider' and seeing a line for SQLSTD Trace.

Note: SQL 2005 Standard was installed *after* ANTS Profiler. Maybe that's the issue?

I need some help. Thanks.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6348
Location: Red Gate Software
PostPosted: Mon Apr 18, 2011 9:13 am    Post subject: Reply with quote
It's probably nothing to do with SQLEXPRESS and more to do with trace not being configured correctly. The Profiler tries to be "helpful" and misidentifies the issue as being related to SQL Express if it finds an instance of SQL Express on the server.

Please see this article.
http://www.red-gate.com/supportcenter/Content?p=ANTS%20Performance%20Profiler&c=knowledgebase%5cANTS_Performance_Profiler%5cKB201101000480.htm
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
Back to top
View user's profile Send private message
jclermont



Joined: 17 Apr 2011
Posts: 3
PostPosted: Mon Apr 18, 2011 1:16 pm    Post subject: Reply with quote
When I check the registry key in the article, it says SQLEXPRESS only.

I definitely have SQL Standard 2005 installed as well, though it's not showing in this registry key.

What do you suggest?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6348
Location: Red Gate Software
PostPosted: Mon Apr 18, 2011 2:10 pm    Post subject: Reply with quote
Sounds like a SQL Server installation issue. Not my forte. Let me see what I can find out.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6348
Location: Red Gate Software
PostPosted: Mon Apr 18, 2011 2:50 pm    Post subject: Reply with quote
Not sure what's going on but the server needs to be named in that key or else Perf Profiler will not set up a trace session for it. Maybe you could just stick it in there using Regedit?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
Back to top
View user's profile Send private message
jclermont



Joined: 17 Apr 2011
Posts: 3
PostPosted: Wed Apr 20, 2011 1:21 pm    Post subject: Reply with quote
That did the trick! Thank you very much. Such a powerful tool.
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