We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE: [sap-basis] Reorganizing MSSQL by doing an export-import

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by D. Caddick (SAP NetWeaver/BASIS Consultant)
on Jul 12 at 3:28 AM 		Mark this reply as helpfulMark as helpful
Hello Mischa,

Have you used Tx ST02 to check the buffer status. Also check the instance parameters as per SAP note 88416.

Regards

From: Mischa van Dinter via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 12 July 2010 08:05
To: D. Caddick
Subject: RE:[sap-basis] Reorganizing MSSQL by doing an export-import

Posted by Mischa van Dinter
on Jul 12 at 3:05 AM Mark as helpful


Hi David and Jack,

Thank you for your replies. I remember reading about the reorg not being neccesary, I am happy to see it confirmed. It would save me a lot of time and effort to not do it. Actually the size of the database is not even an issue, it is really just about the performance.

I will take it up again with our customer. Perhaps a closer look at the indexes is required.

Best regards,
Mischa van Dinter

---------------Original Message---------------
From: Mischa van Dinter
Sent: Friday, July 09, 2010 7:35 AM
Subject: Reorganizing MSSQL by doing an export-import

> Hi,
>
> We are cleaning up a customer's MSSQL 2005 database (deleting old clients etc) and it has been suggested to me (by an Oracle specialist) to reorganize the MSSQL database by exporting and importing it using the SAP installation tools. This would allegedly defragment the database, free up space and increase performance. However I have always thought MSSQL does not need this kind of reorganization.
>
> My question: would a procedure like this do my MSSQL database any good or is it a waste of time? Would there be a better way to reorganize this database that would not mean essentially reinstalling SAP?
>
> Thanks,
> Mischa van Dinter

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
D. Caddick
SAP Basis Top Contributor

Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language