Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rudy Panigas Collect SQL Server/Process Information - Quickly RE: Collect SQL Server/Process Information - Quickly

  • April 21, 2011 at 9:24 am

    #1314574

    thorkw (4/21/2011)

    @Rudy: Sorry, but I can't find an answer to my question above, in BOL.

    When do the numbers get reset, on a stop/start of Sql Server? or a reboot of the machine?

    thanks, Bill.

    Bill, once you restart the SQL server services or reboot the server the numbers will be reset. You can also reset them with certain DMV. Not sure which ones will do that (off the top of my head). You can just google it. Also, you could go to http://www.sqlskill.com as Paul Randal will have the answer.

    I will have a look and post them later.

    Thanks,

    Rudy

    Rudy