SQL Server 2005 and DMV’s

One of the first thing I usually do after having installed a new version of SQL Server is to snoop around at the system tables to see what new tables there are and what they can give me information about.

As you may know by now, in SQL Server 2005 the system tables are not longer visible. The information from the system tables are instead exposed as Dynamic Management Views (DMV). These DMV’s gives you a lot of information about the state of your SQL Server, the problem is how to interpret the view’s and what view’s to look at when you try to solve a specific problem.

Fortunately Slava Ok from Microsoft is planning to post a series of blog entries about DMV’s where he emphasizes on what actual problems the DMV’s can be used to solve. The first installment is now up, and you can find it here. Happy reading!!

Advertisements

4 Responses to “SQL Server 2005 and DMV’s”

  1. dineshv Says:

    give more clear view

  2. Interprete Traducteur Says:

    Interprete Traducteur…

    […]SQL Server 2005 and DMV’s « managed data[…]…

  3. massage tips to induce labour Says:

    What’s up everyone, it’s my first pay a visit at this
    web site, and article is genuinely fruitful for me, keep
    up posting these posts.

  4. Https://twitter.com/2min2book Says:

    Howdy I am so excited I found your blog page, I really found you
    by accident, while I was searching on Google for something
    else, Nonetheless I am here now and would just like to say thanks
    for a incredible post and a all round enjoyable blog (I also love the theme/design), I don’t have time
    to look over it all at the moment but I have saved it and
    also added your RSS feeds, so when I have time I will
    be back to read much more, Please do keep up the fantastic jo.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: