Welcome Guest
Login Register
 
SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization
 
0 Reply's, Recent Post by Tech on 4/17/2015 4:30:26 PM
   

Previous Thread     Next Thread

Tech
9 Points
51 Posts
Guest Reply      Reply            Report Abuse
SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization
4/17/2015 4:30:26 PM


SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization

Every batch (T-SQL, SP etc) when ran creates execution plan which is stored in system for re-use. Due to this reason large number of query plans are stored in system. However, there are plenty of plans which are only used once and have never re-used again. One time ran batch plans wastes memory and resources.

SQL Server 2008 has feature of optimizing ad hoc workloads. Before we move to it, let us understand the behavior of SQL Server without optimizing ad hoc workload.

................................



http://blog.sqlauthority.com/2009/03/21/sql-server-2008-optimize-for-ad-hoc-workloads-advance-performance-optimization/





Post Your Comment        
   Previous Thread     Next Thread
Guest Reply