Post reply

SQL Server 2008 SSMS Enhancements - Part I

  • July 29, 2008 at 11:55 pm

    #130420

    Comments posted to this topic are about the item SQL Server 2008 SSMS Enhancements - Part I

    .

  • July 30, 2008 at 7:17 am

    #850461

    Good article, though leaves me wanting to know more 🙂 (I haven't been keeping up that closely w/ SQL Server 2008).

    Any idea if these features are available when connected to 2005 (or earlier) databases?

    Thanks.

  • July 30, 2008 at 7:21 am

    #850465

    Yes, the activity monitor and index hint are available when you are connected to a SQL Server 2005 instance.

    Intellisense, (which I have not mentioned here) was available earlier, but in RC0 it has been removed. Intellisense will work only on a SQL Server 2008 database.

    .

  • July 30, 2008 at 7:51 am

    #850507

    Managment Studio 2008 Activity Monitor is connecting to SQL 2008 and 2005 Servers, but it is giving me a message that it does not support SQL 2000 servers despite Managment Studio allowing all other functions on them.

    Is no ability to monitor activity of SQL 2000 servers with the 2008 Managment Studio or is this a problem with RC0?

  • July 30, 2008 at 9:09 am

    #850591

    Thanks for the INDEX HINT, just used it, pretty cool

    I am sure there are other features we'll find gradually in SSMS 2008

    still getting used to the 'Activity Monitor' versus the 2005 Activity Monitor

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • July 30, 2008 at 12:25 pm

    #850768

    An average article. From the title I expected much more than brief mention of two new features. And no, the splash screen doesn't count.

    Pasting screenshots of cool features does not make a cool article.

  • July 30, 2008 at 10:19 pm

    #850983

    Good article, waiting for the other in the series.

  • July 31, 2008 at 5:54 am

    #851183

    Nice job! Would like to learn a bit more though, looking forward to part 2

  • July 31, 2008 at 3:19 pm

    #851557

    Nice article. Its worth pointing out that (at least so far as I can tell) the very nice missing index feature in the graphical execution plan only works when connected to SQL Server 2008 instance. Turning on the XML showplan feature though will still give you the text (or technically xml) version.

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/

  • July 31, 2008 at 10:12 pm

    #851640

    Its worth pointing out that (at least so far as I can tell) the very nice missing index feature in the graphical execution plan only works when connected to SQL Server 2008 instance. .

    The example in the screenshot is taken from a SQL Server 2005 database. So it looks to me that it works for SQL Server 2005 as well.

    .

  • August 4, 2008 at 7:08 pm

    #852966

    Do you know if their is a 64bit client?

  • August 4, 2008 at 9:51 pm

    #852984

    I dont have a 64 bit server on which I could test it. The RC0 download page has 64 bit download too. http://www.microsoft.com/downloads/details.aspx?FamilyId=35F53843-03F7-4ED5-8142-24A4C024CA05&displaylang=en

    Hence I am pretty sure that there is a 64 bit client as well.

    .

  • February 17, 2009 at 6:56 am

    #945152

    Good to know this Jacob, i was searching for this Activity monitor, thanks for this good explanation 🙂

  • March 12, 2010 at 2:03 am

    #1132519

    Hi,

    Good article, nice & informative to those who're new to SSMS 2008.

    However, ( i know it's a little moan on my part & ) whilst it's nice to have snazzy, fancy i/o, disk usage graphs etc, the extra hints & so forth but what did they do to it, i mean what happened to old separate window approach as now it's all drop down stuff & all compressed onto a single screen, not to adjustable or possible to have in a separate window running in background whilst you do other stuff with a server etc. I noticed that they seemed to have left the job activity monitor alone, old school style....

    Is it just me ?, am i using it wrong ?, can it be de-docked into it's own window ?...somebody please tell me that i'm just being dense & that there's another way to do it ( much like the older way !! )......please !

    Any answers to this would be welcome, otherwise i think i'll be using SSMS 2005 even for managing 2008 instances, which probably means i'll be missing loads of other potentially usefull stuff in SSMS 2008 !

    Be happy to hear other peoples experiences or advance on it

    Tia

    j

  • March 12, 2010 at 3:25 am

    #1132548

    I would suggest take a look at SQL Server Performance Dashboard Reports, which can display all those graphs - io, cpu, memory - and a bunch of other information right in your SSMS.

    .

Viewing 15 posts - 1 through 15 (of 15 total)

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