Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hey Answat,
Reorganization depends on a few things. "IF" you are archiving and removing a lot of items from the database, "IF" you are creating and deleting data, then reorganizing the database from time to time can make sense. SQL Server has built into it, the ability to reclaim space inside from deleted objects. So, unless you really notice substantial server lag times, or performance issues, you may create more of a headache than it's worth. People like to "shrink" the database when they think it has gotten too large, only having the CPU spin cycles to re-add that space back into the DB due to growth.
Again, unless you are experiencing substantial performance issues, there is absolutely NO NEED to reorganize anything in SQL Server. Oracle? Yes. DB2? Yes.
SQL Server? NO. There are plenty of articles on the internet to support this stance.
Just my two cents.
Jerry
| | | ---------------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  _.____.__ |
