Benutzer:MovGP0/SQL/SQL Server Performance Tuning
SQL Server Performance Tuning
SQL Server Performance Killers
- Insufficient Indexing
- Inaccurate Statistics
- Improper Query Design
- Poorly Generated Execution Plans
- Excessive Blocking and Deadlocks
- Non-set-based operations (T-SQL Cursors)
- Inappropriate Database Design
- Excessive Fragmentation
- Nonreuseable excecution plans
- Frequent recompilation of queries
- Improper Use of Cursors
- Improper configuration of the database transaction log
- Excessive use or improper configuration of
tempdb
Performance Counters
- Dynamic Management Objects
SELECT dmo_pc.counter_name, dmo_pc.cntr_value, dmo_pc.cntr_type
from sys.dm_os_performance_counters as dmo_pc
where dmo_pc.object_name = 'SQLServer:General Statistics'
Referenzen
- Paul Randal: Survey results: Common causes of performance problems. 6. März 2011, abgerufen am 8. März 2015 (englisch).
- SQLIO Disk Subsystem Benchmark Tool. Microsoft, abgerufen am 8. März 2015 (englisch).
- How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem. Microsoft, abgerufen am 8. März 2015 (englisch).
Content Disclaimer
Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.
- The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
- There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
- It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
- Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
- Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.