Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Queries for a project on Project 2003 Server very slow

Status
Not open for further replies.
2tired2care

2tired2care

MIS
Apr 13, 2004
26
US
Running a Microsoft Project 2003 Server.
Projects are stored in an SQL 2000 SP3A database on the Project 2003 Server.
Clients are using Microsoft Project 2003 Professional.

Queries on a specific published project are running very slow.

Short of:
* Moving everything to bigger faster hardware, adding memory, replacing disk drives, etc. (we have no budget)
* Delete all the other projects in the SQL database for the Project Server
* Rewritting all the queries for this project

Do you have any suggestions to speed up queries?
 
Status
Not open for further replies.

Similar threads

Phil.Pearce
  • Locked
  • Question
MS Project - Resource Analysis
Replies
0
Views
158
Phil.Pearce
Phil.Pearce
Jackson920
  • Locked
  • Question
how to fix a corrupted schedule in Project 2013 (Standard)
Replies
0
Views
159
Jackson920
Jackson920
18121999
  • Locked
  • Question
IIF command in MS Project
Replies
6
Views
249
18121999
18121999
sylvled
  • Locked
  • Question
Rampup on MSProject
Replies
0
Views
146
sylvled
sylvled
mycon73
  • Locked
  • Question
Finding or Verifying MS Project Subproject Directory Path
Replies
0
Views
131
mycon73
mycon73

Part and Inventory Search

Sponsor

Back
Top