MSSQL Index Fragmentation

Identificarea indecsilor cu fragmentare mai mare de 80% (TOP 10 – primele 10 inregistrari):

Rebuild indexes:

Reorganize/defragment indexes (ALL = all indexes associated with the table):

Alte informatii:
https://msdn.microsoft.com/en-us/library/ms189858.aspx
https://support.microsoft.com/en-us/kb/2755960

Top 10 Best Practices for SQL Server Maintenance for SAP:
https://technet.microsoft.com/en-us/library/cc966447.aspx

ALTER INDEX:
https://msdn.microsoft.com/en-us/library/ms188388.aspx

DBCC:
https://msdn.microsoft.com/en-us/library/ms188796.aspx

Nivelul de incarcare al fisierelor LOG:
DBCC SQLPERF (LOGSPACE);

Manage the Size of the Transaction Log File:
https://msdn.microsoft.com/en-us/library/ms365418.aspx

Troubleshoot a Full Transaction Log (SQL Server Error 9002):
https://msdn.microsoft.com/en-us/library/ms175495.aspx

Back Up a Transaction Log (SQL Server):
https://msdn.microsoft.com/en-us/library/ms179478.aspx

How to shrink the size of a transaction log (.LDF) in SQL:
https://support.software.dell.com/kb/63465

 

Leave a Reply

Your email address will not be published. Required fields are marked *