Symptom
You experience bad general system performance and suspect the database as root cause.
Environment
ABAP-, Java- or dual-stack based SAP systems based on Microsoft SQL Server
Cause
In the majority of cases left out maintenance and housekeeping
activities on database level are the root cause for database performance
related issues.
Without proper and up-to-date system operation procedures in place, the overall performance of the database (and the BW system if in use) in turn can degrade significantly over time.
1744217 - MSSQL: Improving the database performance
Without proper and up-to-date system operation procedures in place, the overall performance of the database (and the BW system if in use) in turn can degrade significantly over time.
1744217 - MSSQL: Improving the database performance
沒有留言:
張貼留言