SQL Server Articles

Introduction and Scope We briefly mentioned partitions in the first article of this series, Optimization Tools: The Storage Design Wizard, within which we introduced the Storage Design Wizard. The Storage Design Wizard, as we discovered, enables us to manage aggregations on a partition-by-partition basis when working with a multi-partitioned cube. We noted that, if a [...]

Introduction and Scope In this article, we will continue our examination of MDX optimization techniques, begun in the article prior to the last, MDX Optimization Techniques: Introduction and the Role of Processing, and continued in the last article, MDX Optimization Techniques: Further Control of Processing Location and Expression Arrangement. In both articles, we focused upon control [...]

Introduction and Scope In this article, we will continue our examination of an area of considerable interest to MSAS developers and practitioners, and an area where optimization skills are vital to the efficient operation of both client and server. In our last article, MDX Optimization Techniques: Introduction and the Role of Processing, we began an exploration [...]

This is the second article of the series, Optimizing Microsoft SQL Server Analysis Services. The primary focus of this series is the introduction of optimization tools and concepts for Microsoft SQL Server Analysis Services (“MSAS”). The series is designed to provide hands-on application of the fundamentals of MSAS optimization from multiple perspectives. As we progress [...]

Introduction and Scope In this article, we will introduce an area of considerable interest among MSAS developers and practitioners, and an area where optimization skills are vital to the efficient operation of both client and server. In a subset of upcoming articles that I will publish on a recurring basis, intermingled with other MSAS optimization [...]

Return to Previous Article in the Series Performance Audit Checklist  Counter Name Average Minimum Maximum  Memory: Pages/sec  Memory: Available Bytes  Physical Disk: % Disk time  Physical Disk: Avg. Disk Queue Length  Processor: % Processor Time  System: Processor Queue Length  SQL Server Buffer: Buffer Cache Hit Ratio  SQL Server General: User Connections Enter your results in [...]

Introduction and Scope Having processed cubes in preceding articles, we are aware that processing calculates the aggregations that have been designed for the cube, and then loads the cube with the data, and the calculated aggregations of the data. While we have looked only at Full Processing at this early stage of the series, we [...]

About the Series This is the third article of the series, Optimizing MSSQL Server Analysis Services. The primary focus of this series is the introduction of optimization tools and concepts for MSSQL Server Analysis Services (“MSAS”). The series is designed to provide hands-on application of the fundamentals of MSAS optimization from multiple perspectives. As we progress [...]

This is the first article of the series, Optimizing MSSQL Server Analysis Services. The primary focus of this series will be the introduction of optimization tools and concepts for MSSQL Server Analysis Services (“MSAS”). The series is designed to provide hands-on application of the fundamentals of MSAS optimization from multiple perspectives. As we progress through [...]

In this article, I want to tell you what should you know about some undocumented SQL Server 2000 trace flags, and how you can use them for administration and monitoring of SQL Server 2000.Trace flags are used to temporarily set specific server characteristics, or to switch on or off a particular behavior. You can set [...]