SQL Server Performance

Tools similar to QA, EM or Profiler

Discussion in 'SQL Server 2008 General Developer Questions' started by v1rt, Feb 5, 2010.

  1. v1rt New Member

    Good morning folks,
    I just finished installing SQL Server 2008 Express. What is the equivalent of Query Analyzer, Enterprise Manager and Profiler for this version? I can't find it in my installed apps.
    Thanks,
    V
  2. preethi Member

    Hi
    Separate tools Query Analyzer and Enterprise Manager are no more there. They got replaced with unified tool called SQL Server Management Studio, with SQL Server 2005.
    By default you will not get any of the client tools with SQL Server Express Edition. You need to download them separately.
    Microsoft provides Management studio Express at http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
    Even though Microsoft does not provide a tool for profiling on Express Edition, there are third party tools available. We have used one of them and haven't seen any issues with them
    http://sqlprofiler.googlepages.com/
    http://code.google.com/p/sqlexpressprofiler/downloads/list
    Both are freely available. I believe there will be a couple of other tools as well.
    Hope this helps.
  3. v1rt New Member

    Thank you so much!!! :)
    I'm going to try them now.
  4. v1rt New Member

    <p>&nbsp;I'm getting an error connecting to my SQL 2008 server. What is the fix for this?</p><p>&nbsp;<img src="http://img59.imageshack.us/img59/3918/sqlerrore.png" mce_src="http://img59.imageshack.us/img59/3918/sqlerrore.png"> <br></p><p>&nbsp;</p><p>&nbsp;</p>
  5. Luis Martin Moderator

    When you use SQL 2008 Express you don't have some tools like SSMS, Profile, etc.
    But, if you have those tools you can use it with 2000, 2005 and 2008 workgroups version and above.
  6. v1rt New Member

    [quote user="Luis Martin"]
    When you use SQL 2008 Express you don't have some tools like SSMS, Profile, etc.
    But, if you have those tools you can use it with 2000, 2005 and 2008 workgroups version and above.
    [/quote]
    The one I installed today was version 2005. I'm installing 2008 version later.
    Thanks.
  7. preethi Member

  8. v1rt New Member

    The first link I tried this morning, it installed version 2005.
    I'll try the new link on your last post. I'll let you know later.
    Oh, another question, do you have any link I can study MSSQL database administration for 2008 or 2005? I really want to learn to become DBA as well.
    Thank you so much for the help. :) I really appreciate it.

  9. preethi Member

    [quote user="v1rt"]Oh, another question, do you have any link I can study MSSQL database administration for 2008 or 2005? I really want to learn to become DBA as well.[/quote]
    There are plenty of materials available in web.
    Watching the forums like this and www.SQLServerCentral.com will help you much. Additionally, there are some e-books available. Check this site.
    Red-Gate have produced great books. http://www.red-gate.com/about/book_store/index.htm
    "The best way to learn swimming is to start swimming"
    Wish you all the best!
  10. v1rt New Member

    [quote user="preethi"]
    Looks like you have an older version. Can you try this link
    http://www.microsoft.com/downloads/details.aspx?familyid=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en
    On the previous post, I have given you a link, which will work with SQL 2005 only. My bad.
    [/quote]
    Hi Preethi,
    I was able to finally install it. LOL. My db backend is 2008 Express.
    I'm sure that what we have in my previous work isn't the Express version. How do I create SSIS package using this version?
    And also, I'm trying to log in as "sa" but I could no longer remember the password. How do I get around this?
  11. satya Moderator

    I wouldn't recommend the third party tools unless you are not able to achieve (80%) from SSMSE (from Preethi's post above).
    FYI using SQLExpress edition you are limited by feature so you will not get Profiler etc to run, and most of SSMS features are involved in SSMSE.
  12. preethi Member

    Agreed. My suggestion for Management studio is SSMSE. We don't have profiler with express edition and codeplex is still working on database profiler. My suggestion to use third party profiler is only for a new user.
    However, Express edition supports server side trace and it could be used using the same SQL commands. (It is actually a better choice than GUI based tools. I found two interesting articles on this. There could be many more.)
    http://sqlserverpedia.com/wiki/The_Server-side_Trace:_What,_Why,_and_How
    and http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx
  13. v1rt New Member

    Hi Satya,
    If you recall, I think I posted on our 2005 dba forum. I remember mentioning losing my job. Well, I still have no job right now. :(
    Also, on that same thread, you gave me topics about clustering. However, I had a hard time searching for those topic on our site. I was so shy to ask again. :)
    Thanks about the warning about using third party tools. I guess I should concentrate first on the administration side and not worry about profiling first. Right now, I only have 1 Win2003 server running SQL2008 express edition. Can I build another Win2003 server and another SQL2008 server then configure clustering? What are the requirements?
    Since I haven't experienced administering db and tasks related to dba in production, what are most common things that dba does? Those are the things I want to study.
    Oh, I also want to learn about designing, is there a link I can study? I know it's not just creating tables, there is also an art behind it and that's what I want to learn too.
    Hope you can help me. :)
    Have a great day!
  14. satya Moderator

    I believe you need to slowdown in terms of what you want to learn and get to know on the topics, do not mix up or speed out the learning in SQL Server. So once you are sure and learned so far, in this case you are diverting towards the development & design.
    I would recommend visiting old pages on the site and one more suggestion, never be shy to ask a question [:)] and be specifc on what you are looking here.

Share This Page