Interessante Link List


Hier ist eine Liste von Links zu verschieden Themen des SQL Servers, die sicherlich sehr hilfreich sein können bei der Planung und Optimierung eine SQL Server Installation:


Microsoft I/O Best Practices and Tuning


·        Storage Top 10 Best Practices


·        SQL IO download page


·        SQLIOSim tool KB article


·        SQL Server Storage Engine Team Blog


·        SQL Server I/O Basics


·        Predeployment I/O Best Practices


·        Disk Subsystem Performance Analysis for Windows


·        Disk Partition Alignment Best Practices for SQL Server


 


Analysis Services Best Practices and Tuning


·        Analysis Services Query Performance Top 10 Best Practices


·        Analysis Services 2008 Performance Guide


·        Analysis Services 2005 Performance Guide


·        MDX Query Troubleshooting


·        OLAP Design Best Practices for Analysis Services 2005


·        Analysis Services 2005 Aggregation Design Strategy


·        Analysis Services Processing Best Practises


·        Analysis Services Distinct Count Optimization


·        Analysis Services 2005 Processing Architecture


·        Scale out Querying with Analysis Services Using SAN Snapshots


·        Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques


·        Precision Considerations for Analysis Services Users


·        Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios


 


Relational Warehouses Best Practices and Tuning


·        Top 10 Best Practises for Building a Large Scale Relational Data Warehouse


·        Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Reporting Applications


·        Implementing a SQL Server Fast Track Data Warehouse


·        High Performance Data Warehouse with SQL Server 2005


·        Improving Performance with SQL Server 2005 Indexed Views


·        How many files should a database have? – OLAP Workloads


·        SQL Server 2005 Waits and Queues


·        Troubleshooting Performance Problems in SQL Server 2008


 


Integration Services Best Practices and Tuning


·        Top 10 SQL Server Integration Services Best Practices


·        Managing and Deploying SQL Server Integration Services


·        SQL Server 2005 Integration Services: A Strategy for Performance


·        Integration Services: Performance Tuning Techniques


·        The Data Loading Performance Guide


·        High Impact Data Warehousing with SQL Server Integration Services (PDF)


Ralph Kemperdick


Comments (0)