on 05-19-2015 7:39 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.