|
|
Browse by Tags
All Tags » 2008 R2 » DMV (RSS)
-
From time to time happens that I need to extract metadata informations from Analysis Services DMVS in order to quickly get an overview of the entire situation and/or drill down to detail level. As a memo I post the link I use most when need to get documentation on SSAS Objects Data DMVs:
SSAS: Using DMV Queries to get Cube Metadata ...
-
I’ve updated my SYS2 scripts: Added a new script to see how much buffer cache memory is used by each database Updated the sys2.stats script in order to have only one row per statistics Updated the sys2.query_stats script to use the sys.dm_exec_plan_attributes dmv to get better information on which database was used by the cached plans ...
-
I’ve just released three new scripts of my “sys2” script collection that can be found on CodePlex:
Project Page: http://sys2dmvs.codeplex.com/
Source Code Download: http://sys2dmvs.codeplex.com/SourceControl/changeset/view/57732
The three new scripts are the following sys2.database_backup_info.sql sys2.query_memory_grants.sql ...
|
|
|
|