Sap stat file grows

It is in Basis I analyzed several Dialog tasks that did signficant DB work e. There has been an extension in the kernel more than 4GB memory , and therefore we had to switch to KB instead of bytes. This relieves that callers from having to do that and from having to know the version-specific calculations. I am using a special logon that has minimal role authorizations, just enough to execute the FMs I am calling.

I notice that I am getting '--? I suspect I need an additional authorization to get SAP to return the user name. Do you know what authorization I need? And that's true for the RFMs also. This give you the data from all application servers.

For 4. Otherwise the RFM you mentioned are the right ones. I am getting statistics records and summing up the CPU time in the main records. My results do not agree with STAD for the same time period. I believe the difference is because there lots of batch steps in the period. For a main record that has batch step subrecords, does the CPU time in the main records include the CPU time of all the batch subrecords?

Or do I need to include the batch subrecords in my total? Does it depend on the RFM I use to get the stat records?

I've found the struct definitions for the records but documentation is minimal. I'm looking for a white paper or SAP Note. But SAP note might be interesting. Check out the attachement of this note. Does ST03 report response time the same way? I am seeing records where the response time is much smaller than difference between the stop and start times.

What does it mean when the response time is not equal to the difference between the stop and start times? You have to add the 'rolled out' time to the response time and then subtract the queue time.

Then you should get the time between start and stop. There is one important detail for Release 6. With release 7. The roll wait time is always part of the response time, even for an RFC server process. Thanks for going to the trouble of putting together all of this great information.

I wish I had the mental capacity to understand it a little better, though. We're using this function module in an ABAP program to extract information on tcode activity by userid.

The program runs early in the morning for the previous day's activity, putting the extracted data into a unix file.

The job always completes successfully, but sometimes there is no data extracted, even for a normal business day when we know there was activity. Should we be using a different function module, or is there possibly some Basis parameter that may need to be changed? If you could point us in the right direction, that would be greatly appreciated.

This file is purged when its size exceeds a limit of MB. This is the reason why you don't get any data for the previous day.

Then the kernel creates a new file every hour, and the reogranization process can delete the oldest files only. Please ignore my last comment With 4. Just to make sure I fully understand your responses to some other readers: 1.

This function is not RFC enabled. Howeve, if an application server has been shut down you will not be able to retrieve data from this server. Thanks for your very useful blog. I need to report the number of times each user executes each transaction. Is there a way? The problem is detecting the end of the transaction.

If a user aborts a transaction we can't detect this, therefore the counting of LUW will be just an approximation. Please remember: this is statistics, not tracing. This might be the reason why you can display statistical records for approx.

I would appreciate your advice on getting performance information about BSP applications. I would like to, if possible, see the sequence of calls starting from the URL. I think that answering the following 2 questions will probably cover what I am trying to find out:. Sorry, I'm not an expert here.

Regards, Andreas Like 0 Share Right click and copy the link to share this comment Former Member March 24, at am Hi Andreas, This is a very useful blog and for the first time i have seen lot of replies on a blog. Couls you please tell me if there is anyway.. Select a server, a period, and check the user profile. Thanks alot. Do you know what could be happening? Thanks very much and great job Like 0 Share Right click and copy the link to share this comment Andreas Vogel Blog Post Author March 30, at am Hi Lucas, the stat files are managed by the kernel only.

I've never tried to move the files to a different branch in the filesystem. Have you tried to restart the affected instances? Maybe ii will work fine if the path is visible when the instance is starting. Kind Regards, Andreas Like 0 Share Right click and copy the link to share this comment Former Member April 8, at am It worked fine restarting the affected instance. In ST03N, I can get the list of users on the system in the last month or 2 or 3 and then drill down to see the transactions for each user.

Is it possible to get a report of all users and the transactions they've run? The linkage is there for individual users, but you have to drill down to see it. Best regards ST03 doesn't provide such a report, sorry. But we have the data available in BI, where you can easily get this information. SAP offers the possibility to store the aggregated statistical records in BI.

What I expect to see is the names of the reports as I can see it live on SM Thanks for the response. If I can't get the report name in the stat file, Is there a way to see function module execution live like I see the reports name in sm50?

Is that possible? Regards, Satyajit Like 0 Share Right click and copy the link to share this comment Andreas Vogel Blog Post Author January 19, at pm Sorry, there isn't any official way to access the shared buffer. And I don't know any undocumented way how neither.

You could read directly from the file, however the data is stored in a simple compressed format. Regards, Andreas Like 0 Share Right click and copy the link to share this comment Former Member January 20, at am Andreas, thanks for the explanation. Can you give me some more details about this compression technique that's used? If I access the directory how can I decompress the files to read them?

And the format changes from release to release, so I strongly recommend to use the ABAP functions to read the data. There isn't any C API for reading directly from the file. You let me know the details. Thank you. Like 0 Share Right click and copy the link to share this comment Former Member June 1, at am Hello Andreas, I found a lot of useful things in your article, but I can't find an answer for one question: how we can get "transaction id" of current transaction? I need it to get an stad statistic of current user, which can use "sm59 remote logon" from other system.

Like 0 Share Right click and copy the link to share this comment Former Member June 2, at pm I solved problem myself. I would like to understand the selection and filter criteria.

Dataset Name,Seq. Dataset Name. Your earliest response is greatly appreciated. With "Tasktype" you can select records of a particular tasktype, eg. With "dataset name" you can specify a file name which is then used to read the statistical records from.

Could you please give me inputs for Task Type, since it is one character length? I want to see only T Codes.. But when it comes to display mode 'C', which is Business Transaction Totals, the report is showing all.

Is this a bug or this is how it will work. Please advise. I've been experimenting with that function module and I've managed to extract some values from the statistics but I've been struggling to match up the values with those in ST In one particular example, I've extracted time profile information for the following reports:.

Another problem I'm having, and which bought me to this particular forum, is how to extract the average workload response times. Your help would be much appreciated CPU, repsone time etc. What about "average workload response times"? Where in ST03N can you see this data? This function returns statistical records for single dialog steps, not aggregated data like ST03N. Many thanks for your reply, it is much appreciated.

You are right about having to divide by the number of steps 'count' ; it was just a coincident that I had a number of transactions that happened to have 6 steps each. The stat files and theirs names are controlled by the SAP kernel, and it just offers an API to read data from the files. It will not work to rename these files, sorry, and I don't know any way to recover orphan files. You may delete them manually, there is no maintenance for this.

A simple restart of a system will not discard or invalidate the stat files - the kernel will continue to write the records to the files.

If the system is down for a longer time then in fact the existing files are invalidated, and new files are created. We are able to do it throught Sel. Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account?

Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account.

We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Tags: SAP Basis. David Caddick Posted August 24, 0 Comments. Reagan Benjamin Posted August 24, 0 Comments. To delete the stat file manually, please proceed as follows:. Go to ST03 transaction , call the delete function on the relevant instance by choosing :.

Note: How to delete job logs at operating system level will be covered in a separate article later. Normal value for trace is 1. Please cross check this SAP parameter and reset to 1 if the value is maintained as 2 or higher. If this value is set to high, much more detailed trace will be collected and trace file sizes are likely to increase. Therefore recommending to decrease or set the trace level to 1. I am sure, if you duly follow the steps mentioned above, file system full issues can be addressed.

However, if after carrying out all the above steps there is no improvement, then please consider to increase the file system size by requesting space to the relevant team. Skip to Content. Ranjith Jacob. December 17, 6 minute read. Leave the cofiles alone. How to avoid file system full in SAP? How to delete un necessary files in file systems of SAP? How to delete core files in SAP?

How to delete trace files in SAP? How to delete stat files manually in SAP? What is the transaction code used to delete stat files manually in SAP?

What are various reports to be run to cleanup when file system is full? How to prune the file systems in SAP? How to delete old archive files in SAP? Main statistical information such as response time, user and report are also displayed in this section. Statistical Record Database Usage - This section shows details about the database related operations during the exection of the step which generated the statistical record. It includes read, inserts, updates, deletes and other relevant database operations details.

The time taken for each of the different operation types is also specified. Statistical Record Memory Usage - This section shows memory usage details of the statistical record. It shows the total memory used, the heap memory used, roll and paging memory details.

This section is used for memory management related analysis.