cancel
Showing results for 
Search instead for 
Did you mean: 

In transaction SM50 - what do the hash-signs mean?

Former Member
0 Kudos

Hi everyone,

I am working on a 4.6C system running on SQL Server 2005 and they are having some significant performance problems that I am having trouble with. Intermittently their nine application servers will start filling with processes performing SEQUENTIAL READ's. The select statements are finishing but are taking a long time. And then, all of a sudden, everything will be fine and processes will start working again.

  The screenshot below is representative of what we are seeing. I am grateful for any advice you might have but I am very interested in the hash-signs (number-signs) that are next to the tablenames. I don't think I've ever seen them before. Does anyone know what they indicate?

  By the way, when there are slow-downs like this there are no accompanying shortdumps. The system log does not reference them. The developer traces don't say anything about them. I can't see any errors nor warnings to followup on.

  Thanks for any help you can offer.

PS: the client is already planning to upgrade to ECC 6 this summer.

Accepted Solutions (0)

Answers (2)

Answers (2)

alwina_enns
Employee
Employee
0 Kudos

Hello Robert,

the note "1523684 - tables ########## in SM50 or SM66" describes a similar issue, but for releases higher than 4.6C, it could be related to dbmssslib.dll.

Regards, Alwina

Former Member
0 Kudos

Hi Robert,

Database operation for current step like snapshot of # of row direct read, sequential read etc.

Even its also mean Access to SAP pool table.

Regards

Santosh Dwivedi

Message was edited by: Santosh Dwivedi