Quite often when you are performing customizations or when you want to troubleshoot your Project Server deployment it's useful to go "deep" and see what's happening under the SQL hood.
The best way to achieve that is to run a SQL Server Profiler trace on the SQL Server instance you want to analyze. Since Project Server 2007's architecture is based on a queuing system you will find a lot of "noise" if you run a standard trace.
I have attached at the end of this post a template I have created that eliminates a lot of the extra SQL queries due to the queuing system.
Please note that this trace only looks at databases with the suffix Published and ignores commands with prefix MSP_TimesheetQ.Happy tracing!
PingBack from http://www.biosensorab.org/2008/02/29/running-sql-server-profiler-with-project-server/
Lately I’ve heard a few requests to improve the Project Server queue performance. For instance some of