Sql server 2005 express tools - Profiler

Question

Sql server 2005 express tools - Profiler

Ninja's_RGR'us

SSC Guru

Points: 294069
More actions
August 24, 2006 at 12:37 pm

#67623

Is there any way to install the profiler with sql server 2005 Express?.. Or do I have to install the full eval edition?
I could really use it to flush out a bug in an app .

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Ward Pond SSC Eights! Points: 999 More actions · Answer 1

Hi RGR..

According to this link (scroll down to the Manageability topic), Profiler is only shipped with the Standard and Enterprise Editions.

Hope this helps.

Take care..

- Ward Pond
blogs.technet.com/wardpond

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Ya learned that the hard way...

Installed the full evaluation version over express but the profiler didn't get installed. Tried uninstalling the tools and reinstalling but that failed too. So I uninstalled everything, reinstalled the eval version + SP1 and now I started debugging the connection troubles .

Thanx for the help.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

That link is actually for businesses not for developers, the developer link includes management studio. That said I don't understand what a SQL Server person is doing with Express when the no deployment developer edition is only $33 dollars. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

Kind regards,

Gift Peddie

Kind regards,
Gift Peddie

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

I just started a new job in a small company. It's the first time they work with to sql 2005. No one there was aware of that this version existed. I'll pass it along so they can consider it for later use. But for now the full 180 days evaluation version will do just fine for this project.

Thanx for the help.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

hey,

Here is link for the developer's edition.

http://www.provantage.com/microsoft-e32-00575~7MCSB0EX.htm

Kind regards,

Gift Peddie

Kind regards,
Gift Peddie

David Luu SSC Veteran Points: 231 More actions · Answer 6

Now there's an alternative without having to install the commercial or developer editions of MS SQL Server 2005.

And this alternative is standalone as well. No need to do any installation. Not necessarily as full featured as MS version but will do for the basics.

http://sqlprofiler.googlepages.com/

Julia George SSC-Addicted Points: 400 More actions · Answer 7

Hi

has anyone successfully used this Profiler tool, coz I am having problems with it.

http://sqlprofiler.googlepages.com/

I have SQL 2005 Express on my PC & using this product it give an error message as soon as i click test connection... have you any issues with this..?

Regards

Julia

sunny-141957 Right there with Babe Points: 796 More actions · Answer 8

Hi Julia,

I have successfully used this profiler tool. At first even I got the error message as soon as i clicked test connection. But it worked perfectly when I added \SQLEXPRESS to the name of the Server, where "SQLEXPRESS" is the default instance name.If you have given any instance names at the time of installation,replace it with SQLEXPRESS or else the format would be

Server Name\InstanceName (considering this is a Windows authentication)

eg: TestServer\SQLEXPRESS

Thank You

Sunny

Victor Carlos SSC-Addicted Points: 430 More actions · Answer 9

well i am having a problem with this profiler, i dont get any results, even though it connect well, i dont know why i dont get anything

David Luu SSC Veteran Points: 231 More actions · Answer 10

There's also xSQL Profiler which you can get at

http://www.xsqlsoftware.com/

It's not as free as the open source SQL 2k5 express profiler but it has some other useful features like export profile results to Excel (or was it CSV? I forget).

It might not have the same interface as MS SQL Profiler or the open source one but this one is a viable alternative.

Charlie-120533 SSCrazy Points: 2187 More actions · Answer 11

Victor - be sure to select the events tab and filters if you want. I just installed and am pleased with the performance. As mentioned, not as robust as MS but the price is right and it installed in a flash.