THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » 2008 R2 » 2008 » DMV   (RSS)
  • SSAS DMVs: useful links

    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 ...
    Posted to Davide Mauri (Weblog) by manowar on May 18, 2012
  • SYS2 scripts updated (December 2012)

    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 ...
    Posted to Davide Mauri (Weblog) by manowar on December 12, 2011
  • SYS2 Scripts Updated – Scripts to monitor database backup, database space usage and memory grants now available

    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 ...
    Posted to Davide Mauri (Weblog) by manowar on February 13, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement