Profiling Your Vision Database

Before we start the article, I just want to point out that profiling or tracing your database server can impact performance.....


If you have ever let your SQL Profiler run on your Vision Database Server, you've seen thousands of Events recorded in just a few seconds. Depending on what problem you are trying to solve, you may want to weed out some of the events recorded.

One simple way is to filter your profile by ApplicationName. Depending on your configuration, Deltek appears to have four types of ApplicationNames using the database.

1) Deltek Vision (ProcessServer)
2) Deltek Vision (default)
3) .Net SqlClient Data Provider
4) Deltek Vision (Reporting)

When starting up a new profiler session, simply filter on the Column ApplicationName and list one of the above entries. This will help get you started in narrowing what kind of database activity you want to see.

Enjoy.....