Post reply

Create SS2005 DMVs in SQL Server 2000

  • June 6, 2008 at 11:08 am

    #72171

    We're using a number of dynamic management views to report on our SQL Server 2005 databases (such as sys.dm_db_missing_index_groups, sys.dm_os_wait_stats), but we can't use these to report on our SQL Server 2000 databases. Has anyone had any luck in capturing this information for SQL Server 2000?

    Thanks,

    Lori

    Thanks,

    Lori

  • June 6, 2008 at 11:11 am

    #825607

    I don't think you can in SS2K. Quite a bit of that information wasn't exposed at all in SQL 2000, so without a debug version, not sure it's capture-able.

    One of the big thrusts with SS2K5 and now SS2K8, is making the operation of the server more transparent. More and more things are exposed, even some execution plans are broken further down, so things like Bookmark Lookups, aren't in SS2K5. They're decomposed to their lower tasks.

  • June 6, 2008 at 11:18 am

    #825610

    Steve,

    Thanks for your reply - not what I was hoping to hear, but kind of what I was expecting to hear.

    Thanks,

    Lori

    Thanks,

    Lori

Viewing 3 posts - 1 through 2 (of 2 total)

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