Skip to main content

Posts

Showing posts from April, 2015

MS Project Apps cannot load

I recently developed our first MS Project app and expirenced a problem where the app could not load. APP ERROR This app could not be started. Close this dialog to ignore the problem or click "Restart" to try again. Solution The solution is to enable Protective Mode in you version of Internet Explorer. After this, the app should load fine. According to Microsoft  it is a requirement that Protective Mode is enabled in Internet Explorer for Office Apps to work. The app shown is a MS Project App and is named Project Blog News. Download it here:  https://store.office.com/.../project-blog

MS SQL Server Query Performance

Our company have a rather complex add-in to Project Server. For some time we have been struggling with performance issues and no matter how much we tuned the SQL procedures, after some time they would always become slow in a production environment.  Today I came across a tool in SQL Server Management Studio which very easily can pinpoint which queries are running slow. In our case we discovered that one query was very slow and slowed all other queries. This tool is called Activity Monitor and is build into most versions of Management Studio. Note: Activity Monitor requires SysAdmin permissions to be used. The tool is very simple to use. Simply open SQL Server Management Studio and connect to your database.   Click on the Activity Monitor icon. Here you will see a number of sections showing different information about the server.  Overview shows IO, wait time, etc. Processes shows information about which processes/connections is using the server. Resources Waits