SQL Server Performance is the main
problem after writing the queries. The main performance
Killers in SQL Server are as follows
Ø Poor
indexing
Ø Inaccurate
statistics
Ø Poor query
design
Ø Poor
execution plans, usually caused by bad parameter sniffing
Ø Excessive
blocking and deadlocks
Ø Non-set-based
operations, usually T-SQL cursors
Ø Poor
database design
Ø Excessive
fragmentation
Ø
No reusable execution plans
Ø Frequent
recompilation of queries
Ø Improper
use of cursors
Ø Improper
configuration of the database log
Ø
Excessive use or improper configuration of
TempDB
