Sql server 2005 express tools - Profiler

  • 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 .

  • 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

  • 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.

  • 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

  • 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.

  • 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

  • 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/

  • 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

  • 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

  • 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

  • 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.

  • 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.

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

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