Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Good Day
Whose responsibility is the DB? Who gets fired if the DB fails and can't be recovered? If the answer is: 'the SQL DBA', then I think you have to let him do what he feels he needs to. If the answer includes him & you, then you should discuss the pros/cons/worst-case-SAP-scenarios with him over a coffee before deciding.
Regards,
| | | ---------------Original Message---------------
From: Answat
Sent: Thursday, March 03, 2011 1:51 PM
Subject: MS-SQL Reorg
Hi people,
This week the DBA guy was asking me when it was time to do a database reorg again.
He told me that reorganizing the database, defragmenting and cleaning up indexes etc was something that needs to be done an on regular basis or else performance might be in danger.
I found a note on this (we are on MS-SQL 2005) : 159316 which clearly states:
Note that we are talking about a SQL Server database. On other database
platforms, a reorganization might be more helpful. However, on SQL Server
this is in most cases neither necessary nor helpful.
Reorganizations often lead to disadvantages like unnecessary downtimes,
lock situations, terminations or other kinds of problems.
SAP generally advises against performing regular and time-consuming
reorganizations of your SQL Server database.
The SQL DBA however insists on this on the SAP ECC6 database.
Because of this note, I'm reluctant.
Am I missing something here? Should we or should we not?
Txs
Answat |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Waelz, Dean
SAP Basis Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Most Popular White Papers
In the Spotlight  _.____.__ |
