For Databases
SQL Server Oracle Sybase DB2
For Cloud Services
AWS Azure
For Applications
SAP Applications PeopleSoft

Return to list Return to list

Whitepaper: Predictable BI Performance with Unpredictable Queries

  • Understand the inner workings of SQL Server
  • Learn how to improve performance
Author: Jeremiah Peschka
Published: July 15, 2014
Tags:  Performance Monitoring Administration SQL SQL Server Diagnostic Manager

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 For a Free Whitepaper