Databases Reference
In-Depth Information
agement environment for several services (including SQL Server itself, Ana-
lysis Services, Reporting Services, Integration Services and SQL Server
Mobile) released in SQL Server 2005. The SSMS was built to provide ease of
use and manageability for all the database administrators in one single envir-
onment. The client tools available to analyze or retrieve data from Analysis
Services 2005 are integrated within BIDS as well as SMSS. You can browse
data from both of these environments as well. In SSMS you are provided with
a query builder to retrieve data from Analysis Services. The query builder re-
places the MDX Sample application that came with Analysis Services 2000.
In addition the query builder provides intellisense support providing an array
of options for you to access MDX language reference including auto comple-
tion of key words.
If you have used Microsoft SQL Server 2000 you might also be familiar with
SQL Profiler. In the SQL Server 2005 release the capability of tracing, or pro-
filing, queries run against Analysis Services has been integrated into SQL
Profiler. Analysis Services Profiler information can be utilized to analyze and
improve performance. You learn more about the Profiler in
Chapter 12
.
Analysis Services Version Differences
Analysis Services 2000 provided a rich feature set that helped in building sol-
id data warehouses. The features combined with the MDX query language
provided rich analytics for the customers. As with any software package,
though, Analysis Services 2000 had limitations. Some of the limitations of
Analysis Services 2000:
▪ Even though Analysis Services 2000 had a rich feature set, modeling
certain scenarios either resulted in significant performance degrada-
tion or simply could not be accomplished.
▪ There were size limitations on various objects such as dimensions,
levels and measures within a specific database.
▪ Analysis Services 2000 loaded all the databases at startup. If there
were a large number of databases and/or a very large database, this
resulted in long server startup time.
Search WWH ::
Custom Search