Optimize SAP SQL Server database using DTA

Posted by Danilo Brambilla on Server Fault See other posts from Server Fault or by Danilo Brambilla
Published on 2012-10-10T09:20:35Z Indexed on 2012/10/10 9:40 UTC
Read the original article Hit count: 240

Filed under:

sql-server

|

sap

Is it safe to optimize a SQL Server 2005 SAP R/3 database using Database Tuning Advisor raccomandatations? We are experiencing very low performance on a dedicated SAP database because of intense read operations ad the db and DTA suggest to create about 25 indexes and 100 stats. I am not an expert of SAP and I am quite surprised to see that this database has about 56.000 tables and 6500 views (120 GB of data).

Thank you all for help

© Server Fault or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about sap

SAP : « 2011 sera exceptionnelle pour les annonces produits » avec Nicolas Sekkaki, Directeur général de SAP France

as seen on Developper.com - Search for 'Developper.com'
SAP : « 2011 sera exceptionnelle pour les annonces produits » Avec Nicolas Sekkaki, Directeur général de SAP France SAP va bien, très bien même. Mais SAP veut aller encore mieux. Si l'année 2010 a été globalement satisfaisante, c'est surtout le 4ème trimestre de l'éditeur allemand qui a… >>> More
Oracle lance « Financial Analytics for SAP », une application de Business Intelligence destinée aux clients de SAP

as seen on Developper.com - Search for 'Developper.com'
Oracle lance « Financial Analytics for SAP » Une application de Business Intelligence destinée aux clients de SAP Est-ce la volonté de pousser le bras de fer qui l'oppose à SAP à son paroxysme qui a poussé Oracle à lancer une nouvelle application de Business Intelligence capable d'obtenir… >>> More
Usage of Biztalk SAP Adapter without Biztalk Server to connect .NET and SAP

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to use the Biztalk adapter pack whithout a Biztalk installation (Biztalk license is available)? I want to use the Biztalk Adapter for SAP RFC calls within a .NET Application (as a replacement of the SAP Connector for .NET, which is unfortunately no longer maintened by SAP and I don't… >>> More
Crazy idea: Connect .NET and SAP with SAP JCo using IKVM.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
Because the SAP Connector for .NET is no longer maintained by SAP, I am now looking for an alternative to connect the Microsoft world with the SAP world. I know there a third party products like ERPConnect, but I want to do this with tools from SAP. Therefore there arised the crazy idea to use the… >>> More
Sun Fire X4270 M3 SAP Enhancement Package 4 for SAP ERP 6.0 (Unicode) Two-Tier Standard Sales and Distribution (SD) Benchmark

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle's Sun Fire X4270 M3 server achieved 8,320 SAP SD Benchmark users running SAP enhancement package 4 for SAP ERP 6.0 with unicode software using Oracle Database 11g and Oracle Solaris 10. The Sun Fire X4270 M3 server using Oracle Database 11g and Oracle Solaris 10… >>> More