Keep in mind that when I say, ???SQL Server supports clustering,??? it??™s a bit of a loaded
statement. What do I mean by ???SQL Server,??? exactly? A lot of services could be installed??”
which ones am I talking about? Table 7-2 lists which services are cluster-able and which
are cluster-aware.
Table 7-2. Cluster-able and Cluster-aware Services in SQL Server
Service Cluster-able Cluster-aware
Database engine Yes Yes
Analysis Services Yes (new) Yes (new)
SQL Agent Yes Yes
Full-text search Yes (new) Yes (new)
SQL Mail No No
Database Mail No Yes
Reporting Services No Yes*
SSIS No Yes*
Notification Services No Yes
SQL Server Browser No Yes
*Relies on exterior resources, which may not respond well in a failover situation
Another extremely nice improvement is that you may now install Analysis Services
as a clustered instance. This is a critical step given that business intelligence receives
such a high level of marketing with the release of SQL Server 2005. The idea is that
business intelligence (not the technology, per se) should be a business-critical activity;
I agree.
Pages:
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354