Application Design issues

There are application design considerations resulting from the Waits and Queues methodology. The following table describes some of the application design implications.

Observation	Application issue	Possible remedies
High IO waits	Database design Memory pressure	Bad query plans resulting from inappropriate indexing. Add correct indexes to minimize IO. Add more memory
High CPU use	Memory pressure Plan reuse Parameterization	Check for correct plan reuse, parameterization, recompilation, see http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx
High blocking / locking	Transaction management	Redo transaction management Use correct transaction isolation levels

...Happy SQLing
Thanks for Visiting and Sharing your Views