E’ stato rilasciato il Cumulative Update 2 per le RML Utilities
RML Utilities for Microsoft SQL Server CU2
Le RML Utilities sono una serie di tool utilissimi per analizzare le performance di SQL Server. Sono supportate tutte le versioni di SQL Server
questi sono i tool inclusi:
Microsoft ha pubblicato un whitepaper sull’ottimizzazione dei modelle tabulari di Analysis Services 2012
Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services http://msdn.microsoft.com/en-us/library/dn393915.aspx
Se state usando questa tecnologia, non dimenticate di darci un’occhiata!
Sul canale SQLPASS TV, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione “Query Tuning Mastery: Zen and the Art of Workspace Memory” tenuta da Adam Machanic.
Abstract
As SQL Server professionals, we often think of memory in vague, instance-level terms: buffer pool, procedure cache, Virtual Address Space, and so on. But certain tasks require a more in-depth focus, and query tuning is one of them. Large, complex queries need memory in which to work –workspace memory– and understanding the how’s, when’s, and why’s of this memory can help you create queries that run in seconds rather than minutes. This session will teach you how to guide the query processor to grant enough memory for top performance, while also keeping things balanced for the sake of concurrency. You will learn advanced monitoring techniques, expert-level application of specialized query hints, and the memory internals needed to put it all together. If you work with large queries and are serious about achieving scalability and consistently great performance, you owe it to yourself to attend this session.
Sul canale SQLPASS TV, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione SQL Server Execution Plans (From Compilation to Caching to Reuse) tenuta da Maciej Pilecki (SQL Server MVP, MCM).
Abstract
Execution plan reuse is one of the most important aspects of building well-performing and scalable SQL Server solutions. But it’s also the one that is often overlooked during the design phase and becomes very difficult to troubleshoot later. In this session we will discuss in details the following aspects of SQL Server execution plans: compilation, re-compilation, parameterization, caching, reuse and aging. You will leave this session with full understanding of how to improve your server’s performance by increasing execution plan reuse (and how to avoid reuse in case this is necessary).
Raccolti in un unico corposo E-Book due interessantissimi whitepaper dedicati ad Analysis Services Multidimensional, per un total di ben 200 pagine utili dalla versione 2005 di Analysis Services alla 2012:
Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide
Download this book to learn about Analysis Services Multidimensional performance tuning from an operational and development perspective. This book consolidates the previously published SQL Server 2008 R2 Analysis Services Operations Guide and SQL Server 2008 R2 Analysis Services Performance Guide into a single publication that you can view on portable devices.
Su MS Press Blog è stata annunciata la pubblicazione del nuovo libro Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions; l’autore non ha bisogno di presentazioni, è il grande Itzik Ben-Gan.
Il testo è dedicato alle funzioni di windowing che si applicano tipicamente al sotto-insieme di dati (finestra) determinato dalla clausola OVER, introdotta con SQL Server 2005 e ampiamente estesa in SQL Server 2012. Il linguaggio T-SQL non è solo SELECT, INSERT, UPDATE, DELETE e MERGE; chi ha la possibilità di studiarlo si accorge ben presto di quanto sia ricco di statement set-based e di quanto sia importante avere un linguaggio dichiarativo per scrivere query!
Dal portale Red-Gate è possibile scaricare gratuitamente il PDF dell’eBook SQL Server Statistics dell’autore Holger Schmeling:
http://www.red-gate.com/products/dba/sql-monitor/entrypage/statistics-ebook
Questi gli argomenti trattati:
Explains what “statistics” are, and how to inspect and maintain them
Lists the problems related to these statistics objects, and how to solve them
Geared to the practitioner rather than the theoretician, and careful to stick with the things you need to know
