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
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in MSBI, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on in MSBI. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/
ReplyDeleteThanks for sharing Good Information
Sql server DBA Online Course Bangalore
Fantastic article post.Really thank you! Awesome.
ReplyDeleteSAP ABAP training
SSAP PP online training
data science training
teradata training
oracle bpm training