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

Return to list Return to list
Predictable BI Performance with Unpredictable Queries
written by Jeremiah Peschka
Whitepaper: SQL Server
Introduction

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.

Read the full white paper >>

Here is your download link


for SQL BI Manager!

Please choose the file that meets your system requirements:

> SQL BI Manager SQLBI_x86_Trial.zip
> SQL BI Manager SQLBI_x64_Trial.zip

You will also receive a confirmation email with a download link for your product. 

To ensure email delivery, please whitelist sales@idera.com. If you do not receive your email, please be sure to check both your inbox and filters for a message from sales@idera.com.

Click here to join our User Community!

Get more out of your Idera products and experience

Download a FREE Trial

Jeremiah Peschka

Jeremiah Peschka is a database administrator & developer with a history of delivering results and mitigating risks. He loves building software, helping developers, DBAs, and engineers build fast, robust, scalable solutions. Jeremiah is a Microsoft MVP; MCITP for SQL Server development and administration; and a Cloudera Certified Developer for Apache Hadoop. He’s also a big fan of coffee.
http://www.brentozar.com/team/jeremiah-peschka/.