Ms Project too slow

B

bidzis

Hi,

performing single update using Ms Project takes almost an hour in our
organization. Server machine has 4 processors (which are boring most of
time), 1 GB RAM and SQL Server 2k database. Also 100 Mb NIC is used not more
than 1%.

Does anybody know how to speed up the server ? Or this is normal (1 hour
necessary for update ?)

bidzis
 
R

Rod Gill

I assume you are talking about updates to Project Server? Which version? If
it's 2003, what SP level? How many Tasks? Is this for all projects or just a
specific project? Does this also happen if you update a project on the
server box itself?

Please provide some information to help us help you, I'm afraid our crystal
balls aren't that useful!!

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx
 
B

bidzis

Hi Rod,

thanks a lot for your reply. Server config: Win 2003 Stand, Proj Server 2003
(+ SP2a) + SQL Server 2k Enterprise (8.00.760 - SP3) + Sharepoint Servies
2.0 (+ SP2). Will let you know more info in next email tommorow.. We are
going to increase RAM to 2GB (it uses about 1.2 GB a week after reboot)

Thanks again for willingness to help, we are really desperate with that,
users (using M$ Project Prof on their local machines) are really unhappy
with the server performance... And I'm still beginner in administering M$
Project :(

best regards

bidzis
 
I

irish_archer68

Hi Rod,

thanks a lot for your reply. Server config: Win 2003 Stand, Proj Server 2003
(+ SP2a) + SQL Server 2k Enterprise (8.00.760 - SP3) + Sharepoint Servies
2.0 (+ SP2). Will let you know more info in next email tommorow.. We are
going to increase RAM to 2GB (it uses about 1.2 GB a week after reboot)

Thanks again for willingness to help, we are really desperate with that,
users (using M$ Project Prof on their local machines) are really unhappy
with the server performance... And I'm still beginner in administering M$
Project :(

best regards

bidzis

U¿ytkownik "Rod Gill" <rod AT project-systems DOT co DOT nz> napisa³ w
wiadomo¶ci






- Show quoted text -
Click to expand...

Bidzis,

How many tasks does the schedule you are updating have? Also, are you
connecting to the server through VPN or are you on the network inside
the firewall?

Please advise.

Sean
 
B

bidzis

Hi Sean,

Approximately number of tasks in one project is from to 200 to 350 tasks
(summary tasks excluded) with 3 to 4 outline levels. The specific of our
projects is number of used customized enterprise fields (about 30).
The problem seems not to be dependent on project. We are working in the
Intranet.

bidzis

Uzytkownik "irish_archer68" <[email protected]> napisal w
wiadomosci
Hi Rod,

thanks a lot for your reply. Server config: Win 2003 Stand, Proj Server
2003
(+ SP2a) + SQL Server 2k Enterprise (8.00.760 - SP3) + Sharepoint Servies
2.0 (+ SP2). Will let you know more info in next email tommorow.. We are
going to increase RAM to 2GB (it uses about 1.2 GB a week after reboot)

Thanks again for willingness to help, we are really desperate with that,
users (using M$ Project Prof on their local machines) are really unhappy
with the server performance... And I'm still beginner in administering M$
Project :(

best regards

bidzis

U¿ytkownik "Rod Gill" <rod AT project-systems DOT co DOT nz> napisa³ w
wiadomo¶ci






- Show quoted text -
Click to expand...

Bidzis,

How many tasks does the schedule you are updating have? Also, are you
connecting to the server through VPN or are you on the network inside
the firewall?

Please advise.

Sean
 
B

bidzis

Hi Rod,

we don't have Ms Project Prof installed on the server, so no idea how it
works there, but will probably try that - good way to eliminate network
problems during investigation.

See the thread further for more answers for your questions.

thanks,

bidzis
 
B

bidzis

Rod,

see some log entries below (C:\Office... are most frequent, which is
strange, because there is no C:\Office directory on the server...):

Applic log:

Component: AD Connector
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[An error occured within AD Connector for
ProjectServer]]></Description>

Component: PjsvcADC
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[Automation error
The server threw an exception. ]]></Description>


Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2391
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 752
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. . The error code was
also included.]]></Description>

Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\emailformatter.cpp
Line: 348
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\PjNPEUtil.cpp
Line: 50
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: Microsoft Cursor Engine
Description: <Description><![CDATA[Data provider or other service returned
an E_FAIL status.]]></Description>

Component: PjQuery
File: C:\Office\devsp\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

omponent: PDS
Line: 0
Error Number: 0x238e
Description:
<Description><![CDATA[CSecurity.PopulateProjectViewTables3; -2147467259 :
Method '~' of object '~' failed]]></Description>

Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 241
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\c

omponent: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 48
Error Number: 0x80010105
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


File: C:\Office\devsp\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x80070057
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\cifiles.

Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.

Master merge has completed on c:\inetpub\catalog.wci.

One or more documents stored in image columns with extension '' did not get
full-text indexed because loading the filter failed with error '0x1'.

Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.

Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.

Component: PjSvrSecurity
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrsecurity\CPjSvrSecurity.cpp
Line: 2291
Error Number: 0x8c04003a
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

System log:

The Project Server Scheduled Process Service service terminated
unexpectedly. It has done this 1 time(s). The following corrective action
will be taken in 60000 milliseconds: Restart the service.

The application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{0C0A3666-30C9-11D0-8F20-00805F2CD064}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative tool.

What do you think about it ? We have really problem with the performance of
this machine (some days is better, but updates usually take from 20 mins to
an hour, which make users nervous).

Sorry for long response time.

best regards,

bidzis
 
B

bidzis

... the problem is related to all PCs and projects. Today, for example, I got
screenshot from a user stating ODBC connection Error ("ODBC string was cut"
or something like that...) - but it's occasional (NOT frequent and common) -
it happened when update took even over an hour.

Actual SQL Server Log size is about 64MB, I usually cut it (and shring
database) once a month. It used to grow even until 8 GB, however last two
months is constant (what's also strange to me).

I wonder if Win XP firewall or Mcafee (on users' workstations of course) may
cause such slow performance .. I'm going to check it experimentally
tomorrow.

I also wonder if Ms Project Prof. enables different methods of connection to
database and if it's possible to change it. From my experience with Ms
Access few years ago, the best method was ADO (ODBC was v. weak - caused
many connection issues, and DAO worked only fine with one user :)). I saw
in some Project doc, it uses XML, but maybe XML is good for small projects
only ?

Just my few considerations, maybe you could at least eliminate some of them
and help to find the best path to solution. I'm aware that there could be
probably many reasons in such big environment where different applications
cooperate.

Anyway, thanks a lot for the interest and trying to help.

best regards,

bidzis
 

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

Ms Project Server 2 slow 7
My Tasks page really slow 2
Project Server 2007 Performance 2
Slow connection between prof and server and other issues 1
Project Server 2007 running slow 1
Slow opening of Access table in Project 1
Collaborate | Publish All Information is greyed out 3
Slow project opening from Oracle DB via ODBC 1

Top