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 20 at 3:19 AM 		Mark this reply as helpfulMark as helpful
Hi Claire,

But SAP note, 159316, is very clear in explaining that a reorganisation is not recommended on a SQL Server Database.

What other proof are you looking for?

Have you checked the I/O to see if that might be a bottleneck with the database. How many data files do you have and how many CPUs?

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

Posted by chengyaq
on Jul 20 at 3:03 AM Mark as helpful


Hi David,

Yes, you are right.
I just would like to find the prove from SAP.

Best regards,
Claire

---------------Original Message---------------
From: D. Caddick
Sent: Monday, July 19, 2010 10:15 AM
Subject: Reorganizing MSSQL by doing an export-import

> Hi Claire,
>
> If you read the SAP note 159316 again SAP does NOT recommend reorganizing
> the SQL server tables to improve the performance.
>
> Regards

__.____._
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