ghost sql query ??

O

OPSITI

hello !

I have a microsoft project server instaled in a server.
Analysing a SQL server from this MPS I find the next query
running for more than 378 minutes.


Somebody have any idea about this or who execute this ?

a query access MSP_CUBE_TIME_BY_DAY, MSP_CUBE_PROJECTS,
MSP_CUBE_PROJ_VERSIONS

always from CUBE tables !

A Microsoft Project server have a service that constantly update this table
automaticly ?
 
R

Rod Gill

Hi,

The Project Server Administrator sets up Analysis Server to regularly
rebuild the cubes. If you have a lot of projects running for a long time,
your admin may need to cut down the period the cube covers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Olap Cube SQL AS 2008 2
SSRS and Cube Installation Project 0
Ghost tasks with no project or logic 4
Get status messages from Oracle sql queries 0
Ghost tasks in budget report 3
problems migrating project2k3server data to project2k7server 0
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0

Top