Re: Running Analysis Server 2000 on seperate box

On further investigation regarding the lock up problem. I have left
the dimension processing running and although the database rows are
processed in 2 minustes AS Manager appears to hang (not responding in
Task Manager). However leaving it in this state the next phase
(committing transaction in database occurs sometime after, perhaps an
hour) so the dimension build may eventually complete, but why so long?


On Wed, 27 Jul 2005 19:53:35 +0100, Mark <one@xxxxxxx> wrote:

>Thanks for that, changing the service account sorted things.
>
>The reason for the test is on going issue.
>
>I have a client with SQL Server 2000 SP3a on a dual Xeon 2.4Ghz box
>with 2GB ram on Windows Server 2003. This is hosting a Datawarehouse
>solution. The client is increasing their requirement for OLAP cubes
>and reporting. The server has both the database and Analysis Services
>installed. There are currently 7 cubes on the AS server. The Server
>memory is probably operating at the limit with the Page File reaching
>3.5GB. I have experienced an issue when building these
>cubes/dimensions where the query reads the rows, produces a completed
>processing time but then locks up just before the end, and seemingly
>the only solution is to stop the olap service. Restarting results in
>the following error:
>
>Error 1053: The service did not respond to the start or control
>request in a timely fashion.
>
>The service however continues to start, consuming memory, and will
>eventually show a started status.
>
>I have set up a test with Analysis Services on it's own server to see
>if this is a better solution. I have a copy of the database feeding
>the olap cubes to see if the system behaves in the same way. The
>server I have is a PIII 733Mhz with 512MB ram and 2x20GB drives.
>So far AS has locked up in the same way as above when processing the
>last of 12 dimensions. Stopping the olap service and restarting
>produces the same error as above. When the service has restarted it
>is consuming 65mb of physical ram and 1.1GB of virtual memory, when it
>locks it has 117mb of ram and 1.29GB of virtual memory.
>
>Is the lock up issue due to reaching a resource limit?
>
>The cubes are not huge the biggest being 43mb and the smallest 11mb.
>I can set up queries to build cub files through msquery with the same
>data without a problem.
>
>Any suggestions appreciated, am I experiencing an error condition that
>can be rectified or is it a case of building a server with a
>particular configuration to cope.
>
>
>On Wed, 27 Jul 2005 09:03:34 -0700, "Dave Wickert [MSFT]"
><dwickert@xxxxxxxxxxxxxxxxxxxx> wrote:
>
>>The service account that the MSSQLServerOLAPService (msmdsrv.exe) is running
>>under must be domain account with access to the data source. The default is
>>to use Local System which is fine for local databases, but the Local System
>>account does not have any network access. Use the Services applet to change
>>the service account to a domain account that has netowrk access to the data
>>soruce.
>>--
>>Dave Wickert [MSFT]
>>dwickert@xxxxxxxxxxxxxxxxxxxx
>>Program Manager
>>BI SystemsTeam
>>SQL BI Product Unit (Analysis Services)

.

Relevant Pages

  • Re: VBA Project Explorer window
    ... Your the first one that I hear speaking of Access 2000 as "rock solid". ... importing all of your object into a new database. ... Your MDF file is located on a Windows 2000 server: if it is opened by more ... has been locked with a pessimistic lock instead of an optimistic lock. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Running Analysis Server 2000 on seperate box
    ... In all probability there was an outstanding read lock ... What does the virtual memory look like using either Perfmon or Task Manager ... changing the service account sorted things. ... The server has both the database and Analysis Services ...
    (microsoft.public.sqlserver.olap)
  • Re: newbie question
    ... you can still lock rows on the server if that's what you really ... Hitchhiker's Guide to Visual Studio and SQL Server ... I did some database programming in the past and I always used database ... One facility that offered by these controls and I like it most ...
    (microsoft.public.dotnet.framework.adonet)
  • Need help with Restoring Standby server after sa change
    ... 1- Restore the msdb database on backup server ... 2- After applying the service account, ... >failure on the Standby Server. ... >I have gone to the master database on the Standby server ...
    (microsoft.public.sqlserver.server)
  • Re: newbie question
    ... you can still lock rows on the server if that's what you really need to do. ... as I describe in my book this can be problematic as it might lock out other users for an indefinite period of time. ... I did some database programming in the past and I always used database controls which were offered by VB to connect to a database. ...
    (microsoft.public.dotnet.framework.adonet)
Quantcast