Browse by Tags

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Published 18 February 8 3:57 AM | SSQA.net

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 Read...

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

Automation of Analysis Services database backup

Published 26 September 7 5:19 AM | SSQA.net

You may be well versed with scheduling the database backups using SQL Serve Agent --> Jobs with Enterprise Manager or Management Studio. So how about creating a automation job for SQL Server 2005 analysis services database backup every night. Simple...

Filed under: sql server, databases, backup, security, reporting, sqlagent, Analysis Services, xmla