Browse by Tags

• administrator
• Analysis Services
• business intelligence
• data warehouse
• diagnose
• management
• process
• profiler
• readonly
• reporting
• security
• sql server
• sysmon

SQL Server BI - Managing Large Datawarehouse environment, guidelines
17 September 08 01:24 AM | SQL Master | 2 Comments   

What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with Read More...

Filed under: sql server, performance, databases, reporting, management, business intelligence, data warehouse, readonly

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance
18 February 08 02:57 AM | SQL Master | 3 Comments   

Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services (BI) Read More...

Filed under: sql server, performance, databases, Analysis Services, process, security, administrator, sysmon, profiler, diagnose