"More than 400 users access this database, so query traffic can get quite heavy during the day. When there’s a problem with even one query, it can dramatically impact performance system-wide, which results in a backlog of complaints and help-desk calls.

 

Since using iSight, I’ve been able to identify the source of performance bottlenecks resulting from common user errors, such as Cartesian joins. With a single iGuard policy, I can prevent those same mistakes from happening again. As a result, overall system performance has improved significantly and I can manage the user errors."

 

 

 

 

 

Preventing Problem Queries

Kevin Larsen

Database Administrator

 

>>

 

home