Wednesday, November 12, 2008

SQL: Excessive SQL Compilations/Sec

Problem: SQL Compilations/Sec greater than 50 sec in a mid-end backend.
Cause: Store procedures not being fully parameterized. If they were, their plans could have been cached and reused for same runs with different parameters.

Some related links:

http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx
http://www.sql-server-performance.com/tips/sql_server_performance_monitor_coutners_p1.aspx
http://support.microsoft.com/kb/243588
http://msdn.microsoft.com/en-us/library/aa212698(SQL.80).aspx

No comments: