We’ve been having some major performance issues with one of the applications that I support. The database is on SQL Server 2005 and is about 150GB in size. We’ve identified a couple of issues already on the database side. The first issue is that some query (or maybe several queries) is getting a bad execution plan at some point in time during the day. When it occurs, database performance comes to a grinding halt. We know it’s a bad execution plan as running DBCC FREEPROCCACHE immediately resolves the problem system-wide. As we have not yet identified the problematic...