buri8128
asked on
How to run MS Projectserver 2003 run VWNotify service on another dedicated server.
The VWnotify service takes the xml files that are in ViewDrop folder and to the tasks that are described in xml could be things like publishing projects or building cubes.
Our VWnotify are getting to slow now. Some days when reports are due: In two hours it can fill up with 300 xml files. Then it takes to long to process them. They ar not process until 8 hours later. Our MS Projectserver installation is farily large. We have 1500 users 800 projects. We have the databaseserver (sqlserver 2005) on a separate server. We are planning to move the Analysis cubes on a separate server as well. The servers have each two proc and 4 Gigabyte ram.
I have read that the VWnotify service could be installed on another server. Once VWnotify is on a separate server its priority could also be raised.
I have read that for example here:
http://office.microsoft.com/en-us/projservadmin/HA011652671033.aspx
So what are the steps and configuration to install and run MS Project servers 2003 VWNotify on a separate windows 2003 server? Has anyone tryed it?
Our VWnotify are getting to slow now. Some days when reports are due: In two hours it can fill up with 300 xml files. Then it takes to long to process them. They ar not process until 8 hours later. Our MS Projectserver installation is farily large. We have 1500 users 800 projects. We have the databaseserver (sqlserver 2005) on a separate server. We are planning to move the Analysis cubes on a separate server as well. The servers have each two proc and 4 Gigabyte ram.
I have read that the VWnotify service could be installed on another server. Once VWnotify is on a separate server its priority could also be raised.
I have read that for example here:
http://office.microsoft.com/en-us/projservadmin/HA011652671033.aspx
So what are the steps and configuration to install and run MS Project servers 2003 VWNotify on a separate windows 2003 server? Has anyone tryed it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, we noticed a massive improvement. The queue in 2003 is not smart enough to remove duplicate jobs.
Yes, the queue processes a batch at a time. (It actually only processes one job at a time, but then remove the batch all at once.) Even if a project is included twice in a single batch, it will be published twice. Watch the WPROJ_Last_Pub field in the MSP_WEB_PROJECTS table to verify and see what's happening.
Select top 15 * from MSP_WEB_PROJECTS order by WPROJ_LAST_PUB desc
will give you the last 15 projects that the views notification service worked on.
James Fraser
Yes, the queue processes a batch at a time. (It actually only processes one job at a time, but then remove the batch all at once.) Even if a project is included twice in a single batch, it will be published twice. Watch the WPROJ_Last_Pub field in the MSP_WEB_PROJECTS table to verify and see what's happening.
Select top 15 * from MSP_WEB_PROJECTS order by WPROJ_LAST_PUB desc
will give you the last 15 projects that the views notification service worked on.
James Fraser
Would anyone have such VBScript ? I'm having a similar issue but I'm not a pro at VBScript. did some research on google without good result.
Thanks
Thanks
ASKER
Did you notice any performance improvement. I have thought that the notifier would be smart by itself
and notice that it has two jobs in the queu for the same project. It seems that it works with several xml files in a batch. All of a sudden 30 files can disseapar after a long wait.
I have thought about such a solution to scan trough and delete obsolete xml files.
We have no plans to upgrade to 2007.
But thanks for your advice. I will try it.