Running SAP Applications on SQL Server

Sporadic but periodic slow Inserts into a table - Why you should apply SQL Server 2005 SP2

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...

Posted Tuesday, February 05, 2008 1:06 AM by Juergen Thomas - MSFT | 1 Comments

SAP DBACockpit and some related SQL Scripts (Part 3)

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...

Posted Tuesday, July 31, 2007 3:48 AM by Juergen Thomas - MSFT | 1 Comments

SAP Application leveraging SQL Server Automatic Update Statistics

Hi folks, new Blog, new author. The Blog itself should give information about running SAP applications on SQL Server. It will not only be me, Juergen, alone contributing to the Blog. We also will have colleagues of mine contributing who either work in Read More...

Posted Tuesday, May 22, 2007 6:24 PM by Juergen Thomas - MSFT | 0 Comments