Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from bharatram on May 12 at 10:06 AM Andy ,
Have you referred the below sap note ::
SAP Note 27099 - Update statistics in transaction DB02
Regards
Ram
| | | ---------------Original Message---------------
From: Andy Murzyn
Sent: Thursday, February 20, 2014 12:15 PM
Subject: How to Update Performance Stats in DB02 Alert Monitor?
Hello,
I have a number of ECC 6 EHP6 systems running NW 7.31 SP8, SQL 2008 R2 SP2/ WIN2003 R2 / WIN2008 R2.
The Performance Statistics, and only the Performance Statistics, do not update in my DEV and PROD ECC systems. However, they do update in my QA system, as well as in a new Sandbox system I created as a homogenous copy of my Production system using sapinst. Both the message server and database are on the same server for the DEV environment, while the PROD system has a separate database server.
I have other various ECC6 systems as well and the stats update fine. SOLMAN also had updated performance stats in DB02.
I have installed monthly Windows Updates on the DEV box last week and after bouncing the server (effectively stopping and starting the SQL service) and restarting the SAP instance, I did observe current stats, however they have not updated since that time. Other development/test systems that have had the same updates installed do display continuously updated stats, so I don't believe it is due in any way to Windows updates.
Looking in RZ20 the same information regarding performance is displayed. I have deleted all standard SAP jobs in my Dev system, and recreated them via SM36 in 000. The SAP_COLLECTOR_FOR PERFMONITOR (RSCOLL00) executes successfully every hour at 00:00.
The functionality/connectivity must exist otherwise the information would not display after the SQL/SAP restart. There doesn't appear to be any noticeable differences in the SQL instances either.
Does anyone know of any specific logs I can look at or any configuration I can review that might shed some light on this? I appreciate it, thank you. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
