Solved

How to run MS Projectserver 2003 run VWNotify service on another dedicated server.

Posted on 2009-05-04
4
566 Views
Last Modified: 2013-11-15
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?
0
Comment
Question by:buri8128
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
jbfraser earned 500 total points
ID: 24427167
I have not moved the views notification service to another file, but I have written a Windows VBScript that cleans out duplicate project publishes from the ViewDrop folder. This will often remove half the pending .xml files. I don't have the code handy, but essentially, look through the files and compare them to the other files. If there is a later .xml file for the same ProjectID, delete the earliest.

We've moved most of our clients to Project Server 2007, which makes massive improvements in this area.


Hope this helps...
James Fraser
0
 
LVL 1

Author Comment

by:buri8128
ID: 24473295
To jbfraser:
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.
0
 
LVL 13

Expert Comment

by:jbfraser
ID: 24473659
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
0
 

Expert Comment

by:GJasmin
ID: 24908002
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
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question