Search This Blog

Thursday, January 10, 2013

SQL Server Performance Killers

1)   Poor indexing
2)   Inaccurate statistics
3)   Excessive blocking and deadlocks
4)   Non-set-based operations, usually T-SQL cursors
5)   Poor query design
6)   Poor database design
7)   Excessive fragmentation
8)   Non-reusable execution plans
9)   Poor execution plans, usually caused by parameter sniffing
10)Frequent recompilation of execution plans
11)Improper use of cursors
12)Improper configuration of the database log
13)Excessive use or improper configuration of tempdb
 

2 comments:

Zahid Rahman said...



If you are experiencing a major hardware failure that requires a physical presence,
our Emergency Exchange Support Consultants and Network Support Engineers can also provide an on-site presence in many
US locations.

aparna john said...

Hi, In web design a great way to achieve this is by repeating elements in the header and footer, however it can be equally effective for Web Design Cochin. Repeating design elements helps create a consistent look and improves branding.Thanks.....