Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Collect SQL Server/Process Information - Quickly Expand / Collapse
Posted Thursday, April 21, 2011 9:24 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 8, 2016 1:21 PM
Points: 345, Visits: 1,279
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 as Paul Randal will have the answer.

I will have a look and post them later.



Post #1097071
Posted Tuesday, May 24, 2016 6:46 AM


Group: General Forum Members
Last Login: Thursday, August 25, 2016 5:26 AM
Points: 7,969, Visits: 785
Thanks for the script.
Post #1789227
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse