G
gregorybfell
I am the network engineer for a medium size company, which is running
MS-Project. The user who admins Project, has been having performance
issues and is requesting me to buy/build him a new server. The current
server its on is a Compaq Proliant DL-380, GEN III, 2 3.2 GHz
processors, and 3 gb of DDR Ram. It also runs 2 72.8 gb drives in a
RAID 1. This machine is solely dedicated to MS-Project.
I know there are lots of variables, but how long do other projects take
to build cubes? I feel his pain, as 24 hours of cpu-crunching feels
excessive. Also, there are 25k errors in the event log, most are like
the 2 examples shown at the bottom.
The database is ~ 18 gb in size.
What can we do to speed up the performance of the cube building, short
of buying a new 30k server?
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 8/25/2005
Time: 6:59:43 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PRJDBPR01
Description:
Component: PjSvrUtl
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrutl\PjENAgent.cpp
Line: 525
Error Number: 0x8004020d
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 8/25/2005
Time: 6:59:43 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PRJDBPR01
Description:
File: C:\Office\devsp\project\WebClient\source\utility\pjsmtpemail.cpp
Line: 400
Error Number: 0x8004020d
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>
___________________________________
Component: CDO.Message.1
Description: <Description><![CDATA[At least one of the From or Sender
fields is required, and neither was found.
]]></Description>
MS-Project. The user who admins Project, has been having performance
issues and is requesting me to buy/build him a new server. The current
server its on is a Compaq Proliant DL-380, GEN III, 2 3.2 GHz
processors, and 3 gb of DDR Ram. It also runs 2 72.8 gb drives in a
RAID 1. This machine is solely dedicated to MS-Project.
I know there are lots of variables, but how long do other projects take
to build cubes? I feel his pain, as 24 hours of cpu-crunching feels
excessive. Also, there are 25k errors in the event log, most are like
the 2 examples shown at the bottom.
The database is ~ 18 gb in size.
What can we do to speed up the performance of the cube building, short
of buying a new 30k server?
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 8/25/2005
Time: 6:59:43 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PRJDBPR01
Description:
Component: PjSvrUtl
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrutl\PjENAgent.cpp
Line: 525
Error Number: 0x8004020d
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 8/25/2005
Time: 6:59:43 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: PRJDBPR01
Description:
File: C:\Office\devsp\project\WebClient\source\utility\pjsmtpemail.cpp
Line: 400
Error Number: 0x8004020d
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>
___________________________________
Component: CDO.Message.1
Description: <Description><![CDATA[At least one of the From or Sender
fields is required, and neither was found.
]]></Description>