Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Collect SQL Server/Process Information - Quickly Expand / Collapse
Author
Message
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: 2 days ago @ 1:14 PM
Points: 312, Visits: 1,106
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 www.sqlskill.com as Paul Randal will have the answer.

I will have a look and post them later.

Thanks,

Rudy



Post #1097071
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse