Explore all the products and find the right solution for your business
Proactively manage server performance on-prem or in the cloud with timely alerts and analytics
Fast configuration of regulatory and audit compliance settings with proactive monitoring, alerts, and reporting
Automated database security, monitoring and management for MS SQL, Azure and Amazon RDS for SQL Server
Backup and instant recovery for SQL Server, Azure Blob Storage and Amazon S3
Discover, track and manage database inventory across the entire environment
24 Essential tools to simplify daily server administration
Get the right solution to keep your database running at peak performance.
All of the support you need at your convenience.
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 changing market forces, and complex relationships may be redefined at the drop of a hat. Our best online transaction processing tuning efforts cannot keep up with the changing demands of business intelligence (BI) power users.
The purpose of this white paper is to teach database administrators on how to determine if SQL Server is configured correctly for BI workloads. This whitepaper introduces foundational ideas for sizing SQL Server storage and hardware. It then addresses more complex SQL Server features like SQL Server Resource Governor and Buffer Pool Extensions. Besides, we will examine tempdb configuration, parallelism, and licensing. That should provide a database administrator with the core knowledge needed to design a powerful business intelligence SQL Server.
Jeremiah Peschka is a database administrator & developer with a history of delivering results and mitigating risks. He loves building software, helping developers, database administrators, and engineers build fast, robust, scalable solutions. Jeremiah is a Microsoft Most Valued Professional, Microsoft Certified IT Professional for SQL Server development and administration, and a Cloudera Certified Developer for Apache Hadoop. He is also a big fan of coffee.
Register to read the full whitepaper.
Topics: Database Monitoring, Database Performance, Database Diagnostics Products: SQL Diagnostic Manager for SQL Server