VWNotify processing

[jambraun]

Hi all,

I have a 2.8ghz dual-core system w/ 4GB ram that continually has back
ups of XML files in the Viewdrop folder that never clear until the
weekend.

The VWnotify service will cotinualy run at 50% cpu (that's 1 full
processor) but the views never complete processing until they are
allowed to sit for 2 days over the weekend. By Monday all views are
generally processed.

Do you have any suggestions as to why this is happening and what can be
done to process these views in a days time? Or less? We've already
replaced all the illegal characters in the gantt names with legal ones
and that seemed to speed things up a little but on such a beefy machine
this processing should not take a weeks time.

A little more background info, the SQL server (2000) is on the same
machine as the Project Server 2003, PWA, and Sharepoint. My initial
thought was that there was too much contention with the SQL database
among all the other services that didn't calm down until the weekend
when no one was around but at the processing speed of 2.8Ghz I expected
at least 1 of the views to have processed within a weeks time.

 

[Mike Glen]

Hi jambraun ,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP

 

[Wilt Thomas Rovira Britton]

Hi.
How many concurrent users do you have? And how many projects?

It's possible that you need to separate services (it depends on the number
of users and type of projects you have)
SQL Server and Analysis Services
Project Server and Sharepoint Services

Regards,
Wilt