Whitepaper : Predictable BI Performance with Unpredictable Queries

  • Understand the inner workings of SQL Server
  • Learn how to improve performance
Presenter: Jeremiah Peschka
Share This:  Facebook Twitter LinkedIn

SQL Server database administration is difficult; queries and indexes require tuning in response to application changes. For many database administrators, change is regular; change happens after a development cycle with testing phases and a careful roll out process.

Business intelligence (BI) applications are different; they can be unpredictable. Schemas are designed to respond to changing user demands. Users may change query habits in response to changed market forces, and complex relationships may be redefined at the drop of a hat. Our best OLTP tuning efforts can’t keep up with the changing demands of BI power users.

The purpose of this white paper is to teach database administrators how to determine if SQL Server is configured correctly for BI workloads. This paper will introduce foundational ideas for sizing SQL Server storage and hardware and then address more complex SQL Server features like SQL Server Resource Governor and Buffer Pool Extensions. In addition, we will examine tempdb configuration, parallelism, and licensing. This should provide a DBA with the core knowledge needed to design a powerful BI SQL Server

Register to read the full whitepaper.


Register for Free Whitepaper

Register For a Free Whitepaper

*
*
*
*
*