Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Maybe things changed on 2005 but in 2000 it was a necessary every-week
activity int not performance of database go downhill fast!
The problem as SAP states is that it is a time consuming activity and the
system availability suffer a lot.
So time tell... Agree with your dba 2-3 months following sap recommendations
and if things go awry then do as your dba say.
J.
| | | ---------------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
| | Most Popular White Papers
In the Spotlight  _.____.__ |
