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
SELECT * 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