Browse by Tags
All Tags »
Administration (RSS)
We finally made it to the finish line with the new Whitepaper describing SAP applications running on SQL Server 2008 and SQL Server 2005. Part of the reason why I was so silent on the blog over the last months certainly can be attributed to the effort
Read More...
As promised, we are publishing the stored procedure used to compress Microsoft’s SAP ERP system in this location. This procedure is not the only way getting SQL Server 2008 database compression applied. The easiest one to use is the tool SAP provides
Read More...
Attachment(s): sp_use_db_compression_20.zip
Analyzing a SQL Query trace with SAP’s ST05 SQL Trace, a pattern could be observed which looks like several inserts into a specific table taking place as expected in the milliseconds range but suddenly one inserting query takes hundreds of milliseconds
Read More...
Well, let’s go to the last part of our series about SAP DBACockpit and associated SQL Server scripts. Actual Running Requests Another area which usually is investigated is to detect long running queries against the database. What can be from interests
Read More...
Out of actual reasons of having gotten 3 such questions over the last two weeks and one customer escalation, let’s go through this discussion briefly again of what the SAP Service Pack policy for SQL Server is. It also coincides with SAP overhauling the
Read More...
Last week SAP released a set of new Support Packages for their 7.00 Basis. This is usually not worth reporting from a database point of view. However this time you’ll see some surprising changes after Basis Support Package 12 was applied - if you managed
Read More...
