G
GSHAWW18
I'm a SQL 2000 DBA trying to help the project office folks monitor the state
of the system especially on Mondays as that is when they accept the time for
about 300 projects and 700 resources. As you can imagine, the View Drop
folder for project publishes can get quite backed up.
I'm wondering if there is a relation between the View Drop folder for the
Notification Services and the MSP_VIEW_SERVICE_NEW_DROPS,
MSP_VIEW_SERVICE_FILE_DELETE_PENDING tables?
I've been able to determine through the use of Profiler that the
MSP_VIEW_SERVICE_PUBLISH_STATUS.DBO.Status field is set to 1 for a given
project id when the Views Notification Service is working on the entry in the
View Drop Queue.
How are the other two tables related to this process and why is the
MSP_VIEW_SERVICE_FILE_DELETE_PENDING table slowly growing ( now over 6000
rows)? Is there a purge process for this table?
of the system especially on Mondays as that is when they accept the time for
about 300 projects and 700 resources. As you can imagine, the View Drop
folder for project publishes can get quite backed up.
I'm wondering if there is a relation between the View Drop folder for the
Notification Services and the MSP_VIEW_SERVICE_NEW_DROPS,
MSP_VIEW_SERVICE_FILE_DELETE_PENDING tables?
I've been able to determine through the use of Profiler that the
MSP_VIEW_SERVICE_PUBLISH_STATUS.DBO.Status field is set to 1 for a given
project id when the Views Notification Service is working on the entry in the
View Drop Queue.
How are the other two tables related to this process and why is the
MSP_VIEW_SERVICE_FILE_DELETE_PENDING table slowly growing ( now over 6000
rows)? Is there a purge process for this table?