Top 10 Best Practices for SQL Server Maintenance for SAP
By Takayuki Hoshino
SQL Server provides an excellent database platform for SAP applications. The following recommendations provide an outline of best practices for maintaining SQL Server database for an SAP implementation.
1) Perform a full database backup daily
2) Perform transaction log backup Every 10 to 30 minutes
3) Back up system partition in case of configuration changes
4) Back up system databases in case of configuration changes
5) Run DBCC CHECKDB periodically (ideally before the full database backup)
6) Evaluate security patches monthly (and install them if they are necessary)
7) Evaluate update modules of hardware drivers and firmwares and install if necessary
8) Update statistics on the largest tables weekly or monthly
9) Rebuild or defrag the most important indexes
10) Use a health check monitoring tool for performance, availability, and so forth
Reference : Pinal Dave (https://blog.sqlauthority.com), TechNet
11 Comments. Leave new
Helpful hints. Thanks. That said, do you have any recommendations on backup/health monitoring tools? I have been asked to re-evaluate what’s available on the market and wanted to get some opinions on what a good shortlist would be, if not outright recommendations.
Thanks in advance.
Do you have any info for supporting SQL 2005 Clustered Active/Passive in a Sharepoint 2007 environment?
I am looking for Best Practices for maintenance, most of the above apply, but there are some nuances to Sharepoint that I need to understand, and have yet to grasp.
Thanks
p.s. if you don’t know, other than Microsoft’s website, where could you recommend I find help?
Lisa Hale
Hi Pinal,
In our project, SAP team wants to send data to sql server 2000/2005. How can they do that?
In older days we used to receive data in txt files from SAP and then we used to read id and insert it in db using bcp. What are the new/advanced methods to do the same?
Waiting for your reply.
Regards,
Ashwin
Cool !
Hi Pinal,
really very helpfull best practices…
To
Ashwin Shende,
I suggest you to use SSIS to import/export data from SAP to MSSQL database..
There are great features in SSIS..
Regards,
Pravin Patel.
Please tell me you’re not taking credit for MS.
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/cc966447(v=technet.10)
Totally agreed with Steve, at least put reference in your articles!!!
Dave,
Please explain why or why not to execute update statistics full scan after an alter index reorganization.