Following the article yesterday (Know Where Your Query Spends Its Time), here is the code to send the wait stats information to a synchronous bucketizer; the obvious pros are that the structure is in memory, and you don’t need to stop the session to process the data; the cons are that you cannot reset the data read (unless you re-create the session); the other big con is that you cannot sum values in the columns (in the case of the wait_stats time is important). (more…)
WHAT CAN SOLIDQ DO FOR YOU?
Whether you need to enhance an existing platform or design an entirely new solution, SolidQ offers a suite of services to help you architect, integrate and optimize your Microsoft information platform.
- Virtual SANs and the trend towards SDS
- How to bulk copy Azure ML Experiments from a Workspace to another one or do a Backup of them in Physical Files
- Creating an installer for your SSIS-assemblies
- Creating and using memory optimized tables in an application
- The SQL Server Browser service and multiple instances
2014 Administración SQL Server Analysis Services Arquitectura Business Intelligence Curso de Power BI Curso MS Business Intelligence Data Modeling DAX Denali Descargas Diseño relacional ETL Excel Hadoop HDFS HDInsight Hive Integration Services Mantenimiento Migración OLAP Optimización Performance Powerpivot Powershell Reporting Services Seguridad SharePoint sharepoint 2010 sharepoint 2010 Sharepoint 2013 Silverlight SolidQ Summit SQL Server SQL Server 2005 SQL Server 2005 SQL Server 2008 SQL Server 2012 SQL Server 2014 T-SQL Troubleshooting Tuning SQL Server Visual Studio WPF