September 25, 2003 at 7:50 am
Do you run SAP Applications (R3, CRM, BW etc) on SQL Server? If your are,
1) How large is your SAP Database?
2) How frequently do you perform database optimization?
3) Any tools to use to help you monitoring SQL Server SAP database performance?
September 26, 2003 at 8:10 am
Anyone? Or other ERP applications?
Edited by - allen_cui on 09/26/2003 08:10:09 AM
October 2, 2003 at 7:18 am
Yes we run SAP R/3 on Win2k server with SQL2000 enterprise. The database is currently 80Gb and increasing by 1Gb per month. We run WM, SD, MM, and FI, FI to a limited scale though. IMHO I think that SQL is fine but Oracle would be better for the obvious reasons but also that SAP has been running on this DB for much longer and has more experience with this. Generally though SQL is quite happy and is easier to administer.
October 2, 2003 at 4:28 pm
We used to run pieces of the JD Edwards suite on SQL, others on DB2 (on AS/400).
SAP has a large presence in Redmond and test engineers there. I'll make a few queries at PASS, but my understanding is they have run some pretty big databases on Windows and SS2K.
I have a client that runs an older ERP package on SQL, db size is around 14GB (in use).
How big is yours?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 2, 2003 at 8:03 pm
I guess my database can be considered as medium/large. It is 550GB in allocated spaces and over 500GB in use currently. It is SAP R3 OLTP database and increase at 15GB to 20GB per month. I am going to increase the allocation spaces soon.
It is also quite challenge to maintain such database. We are manufacture running 7x24 and difficult to find downtime to perform dbcc dbreindex even though dbcc inexdefrag is alternative option. In R3 system, Profiler is not sufficient to trace the database activities because it is hard to link stored procedures (Lot of them are temporary SPs or one time SPs) generated from ABAP applications back to the ABAP programs. When users complains transaction slowness, you really can't do much from the database side to help them. You need very good ABAP programmer instead. You also have to be a good BASIS guy.
SAP provides some basic tools/transactions in their application to monitor database performance, but it is not sufficient enough. That is why I posted this question to ask anyone's opinions and experience who works on ERP applications.
October 3, 2003 at 3:42 am
That's quite a DB you have there Allen, I went to SAP teched in Vegas this year as we are going to implement BW. Do you plan on going to Netweaver and the J2EE engine anytime soon? I'm not sure it is even released yet but they sure are marketing it. You might get more answers on SAP from the developer network at https://www.sdn.sap.com/
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
October 3, 2003 at 4:36 am
We have an SAP over here.
A lot of modules, over 1000 users, the DB size of the productive DB is 250 GB after 1,5 years and the size grow is 10-20 GB/Month. The biggest grow is on the controlling tables (COEJ, COEP, GLPCA, COSS...) where each table is over 30-40 GB.
We also have HR and we are planning to implement IS-U and BW.
I've alredy discussed a lot of maintenance issue in this columns here.
We have monthly maintenance windows where we are doing the reindex, update usage, update statistics.
In a month the main tables are getting approximatly 50% fragmented.
So now we hane implemented a nightly indexdefrag which runs on the whole DB subset by subset. so by the end of the month the indexdefrag is over for the whole DB (over 27.000 tables).
The only problem I've seen is the maintenance on the system tables. There is no way to defrag. There is a workaround with some undocumented SPs and DBCC but nothing works on sysobjects and sysindexes.
Never the less our AVG response time is between 300 and 500 ms. Whis is quite nice.
If you want we can discuss more deeply how you and we are working
Bye
Gabor
Bye
Gabor
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply