Skip to Content

SAT / SE30 Performance Measurement without MsSQL Buffers

Hello friends,

I'm working on performance tunings on some custom ABAP reports and using SAT / SE30 to measure response time before and after ABAP tuning.

But the database in our development system is MsSQL and it has a database buffers,

Once I run a program in development system MsSQL is already saving my queries in it's database buffer
so if I run same report second time than report answers already in a very short time like 1-2 seconds.

I can't see the difference in response time because of this,

Is there any way to bypass MsSQL buffers while testing ?

Thanks in advance,

Bulent

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 20, 2017 at 07:43 PM

    Hi, if you have a way to influence your query, you may add query hint OPTION(RECOMPILE) while in development so the query engine will always build a fresh query plan for you. Caution: remove this query hint before going to production.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 19, 2017 at 04:52 PM

    Hello Bulent,

    Have you tried to clear the buffers and cache?

    DBCC DROPCLEANBUFFERS
    GO
    DBCC FREEPROCCACHE
    GO

    Remarks:
    Use DROPCLEANBUFFERS to test queries with a cold buffer cache without shutting down and restarting the server. (source)
    Use DBCC FREEPROCCACHE to clear the plan cache carefully. Freeing the plan cache causes, for example, a stored procedure to be recompiled instead of reused from the cache. (source)

    Regards.
    Eduardo Rezende

    Add comment
    10|10000 characters needed characters exceeded