Browse by Tags

• 2005
• 2008
• 2008 R2
• 2012
• Analysis Services
• Caching
• Object Dependencies
• Partitioning
• Scripts
• SQL Server
• sys2
• T-SQL

• 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 Read More... Posted Friday, May 18, 2012 5:47 PM by Davide Mauri | 0 Comments Filed under: 2008, DMV, 2008 R2, Analysis Services, 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 Read More... Posted Tuesday, December 13, 2011 12:26 AM by Davide Mauri | 0 Comments Filed under: 2008, DMV, 2005, sys2, 2008 R2

• 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 Read More... Posted Sunday, February 13, 2011 7:30 PM by Davide Mauri | 2 Comments Filed under: T-SQL, 2008, DMV, Scripts, 2005, sys2, 2008 R2

• Viewing how much memory is used by not reused query plan

  One interesting observation that may help developers get convinced that they should parametrize query and that they must check that the ORM they use does it correctly is show how much memory can be wasted by plans that cannot be effectively reused. The Read More... Posted Friday, July 23, 2010 11:48 AM by Davide Mauri | 9 Comments Filed under: DMV, Scripts, sys2, Caching

• SYS2 DMVs on CodePlex

  I’ve just created a new project on CodePlex anmed SYS2DMVS , where I’ll put all my sys2 scripts so that they can be found and accessed more easily. Also it will more easy for me to maintain them, just a Check-In with SVN and that’s it :-). http://sys2dmvs.codeplex.com/ Read More... Posted Monday, January 18, 2010 8:09 PM by Davide Mauri | 0 Comments Filed under: T-SQL, 2008, DMV, Scripts, 2005, sys2

• sys2 scripts updated

  I’ve updated my “sys2” scripts with three 3 new scripts: sys2.objects_dependencies A wrapper around sys.sql_expression_dependencies that shows also related informations taken from sys.object table, like object name, object type and schema name of the Read More... Posted Thursday, January 07, 2010 10:54 PM by Davide Mauri | 0 Comments Filed under: T-SQL, 2008, SQL Server, DMV, Scripts, Partitioning, 2005, Object Dependencies, sys2