Does anyone know how to save dynamic management view information so I can
still use some old view info after I stop and restart sql serverSELECT * INTO mytable FROM sys.dm_whatever
?
Or you could create table(s) beforehand with all or a subset of the columns
(and a datetime column), and collect a heartbeat every n minutes by using
INSERT ... SELECT. However, you'd want to keep the table trim depending on
which view(s) you're tracking... because it can grow very quickly.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
news:C6419A39-A084-48B4-B116-57FBDE8688B0@.microsoft.com...
> Does anyone know how to save dynamic management view information so I can
> still use some old view info after I stop and restart sql server
No comments:
Post a Comment