Databases Reference
In-Depth Information
ers window. You can right-click the specific Analysis Services instance and
choose the appropriate operation. In addition to that you can connect to the
server in the object explorer or launch the MDX query editor from this window.
Once you are connected to an Analysis Services instance in the Object Ex-
plorer window you can accomplish various administrative tasks on the server,
such as creating new databases, providing permissions, creating new data-
bases, processing objects, and moving databases from test servers to pro-
duction servers. First and foremost for the Analysis Server admin is to provide
access permissions to the users who will be administering the server. The fol-
lowing steps show how you can add a user as an administrator of an Analysis
Services instance by making them part of the object called Server Role:
1. In the Object Explorer window right-click on the Analysis Services in-
stance and select Properties.
2. You will now see the Analysis Services properties dialog.
3. Click Security in the page as shown in
Figure 12-3
. Click the Add
button to add a user to Analysis Services administrators group. You
can only add domain users or groups as part of the administrator
group for Analysis Services. If your user is a local user you can spe-
cify machinename\username to add the user to this server adminis-
trator group.
Another important management task is to set appropriate properties for Ana-
lysis Services for enabling features or configuring certain properties so that
Analysis Services performs optimally. You can change the properties using
the Analysis Services properties dialog shown in
Figure 12-4
.
Analysis Ser-
vices needs to be restarted for certain properties to take effect. This is indic-
ated by a "yes" in the Restart column in the Analysis Server Properties dialog.
Some of the most important properties involve control of parallelism for pro-
cessing and querying; changing the read buffer size for reading data from
disk for faster query response time. Equally important are maximum amount
of memory to be used by the Analysis Services processes, controlling the
maximum number of connections to the server, and the ability to turn server
features on and off. You learn some of these properties in this chapter and
others in
Chapter 13
.
Search WWH ::
Custom Search