Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
MicrosoftArticlesForumsFAQs
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml / Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

WebArticlesForumsFAQs
JavaScript
ASP
ASP.NET
WCF

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

Non-MicrosoftArticlesForumsFAQs
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

Operating SysArticlesForumsFAQs
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsFAQs
BizTalk
Site Server
Exhange Server
IIS

Graphic DesignArticlesForumsFAQs
Macromedia Flash
Adobe PhotoShop
Expression Blend
Expression Design
Expression Web

OtherArticlesForumsFAQs
Lounge
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Product Reviews
Search Engines
Resumes

 

  View Other Other Issues Posts   Ask New Question  Ask New Question With Power Editor

project server published database
Joseph Cook posted at Thursday, October 29, 2009 10:29 AM

Hello,

We are currently using Project Server 2007.  I am responsible for the server and database maintenance.  I've been watching the published database, and it is growing pretty quickly.  When I look at the 'Disk Usage by Top Tables' report, the MSP_ASSIGNMENT_TRANSACTIONS table is by far the largest - 18.5GB w/ 22,064 rows.  The next largest table is the MSP_PROJECTS table - 99.5MB w/ 631 rows.  The MSP_ASSIGNMENTS table is 29MB w/ 11,543 rows.  My question/concern is about the assignments_transaction table - should it be that large?  When I query the table using SSMS, it takes several minutes to return all of the rows.  I haven't been logging how fast it is growing on a daily basis, but over the last month it has grown from 9 or 10gb to the present 18.5GB.
Thanks
Joseph
Reply    Reply Using Power Editor
  Rank Winnings Points
November 0 $0.00 0
October 0 $0.00 0