John Mitchell (11/25/2008)
Bear in mind also that the DMVs are cleared down not only when SQL Server restarts, but also when databases undergo certain changes of state, such as to or from READ_WRITE.John
Cool 😎 That means that I could programatically define a workload by altering the DB status and not have to restart the whole instance.
ATBCharles Kincaid