Post reply

SQL Server 2005 Performance Dashboard

  • January 10, 2009 at 8:23 am

    #129048

    Does anyone know of a way of resetting the counters that the SQL Server 2005 Performance Dashboard uses without resetting SQL Server?

    Thanks,

    John

  • January 10, 2009 at 8:57 am

    #924830

    That's a great question, but I don't think many of them can be reset. They all come from counters stored in virtual tables in SQL Server and most of those can't be reset without a restart, at least I've not heard of that.

    What are you looking to reset?

  • January 10, 2009 at 9:02 am

    #924833

    We use the aggregate counters for performance statistics after changes are made to the application databases. We would like to reset them after changes are deployed. It would be best if we could reset it without restarting the services. This way we can compare the previous dashboard results with results after the change and there's no down time to the customer.

    Thanks,

    John

  • January 12, 2009 at 2:03 pm

    #925575

    You can reset the latch and waiit stats counters.

    DBCC SQLPERF

    (

    [ LOGSPACE ]

    |

    [ "sys.dm_os_latch_stats" , CLEAR ]

    |

    [ "sys.dm_os_wait_stats" , CLEAR ]

    )

    [WITH NO_INFOMSGS ]

    http://msdn.microsoft.com/en-us/library/ms189768(SQL.90).aspx

    MJ

  • January 12, 2009 at 2:17 pm

    #925584

    Thanks for the info, I'm kind of surprised there's not some DBCC command to just reset them all. Perhaps there's a good reason...

Viewing 5 posts - 1 through 4 (of 4 total)

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