Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shiloh
Starting Member
48 Posts |
 Posted - 2008-03-27 : 11:46:45
|
| I am wondering where the DMVs are stored? In tempdb? or resourcebd? or somewhere else? |
|
|
shiloh
Starting Member
48 Posts |
Posted - 2008-03-27 : 22:55:30
|
| no one? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-27 : 23:08:42
|
| Some in views of Master database and some in Views of MSDB database. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 23:25:05
|
| In fact you can find them in every db. |
|
|
|
shiloh
Starting Member
48 Posts |
Posted - 2008-03-29 : 12:26:23
|
quote:
Originally posted by rmiao
In fact you can find them in every db.
There are system level DMVs and database level DMVs right..So you are saying all DB level DMVs for each db are stored in their respective Db's? and system level in master db? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-29 : 22:01:42
|
| They are same. Sql2k5 has all those in system resource db and copy to every user db. |
|
|
|
|
|
|
Where are DMVs stored