cancel
Showing results for 
Search instead for 
Did you mean: 

Wrong(negative) values displayed by SQL Server Performance Analysis (ST04)

Former Member
0 Kudos

Hi experts,

We upgraded from SQL Server2000 to 2005 and 4.7 to ECC6.0.

In upgraded system, SQL Server performance analysis (ST04--> performance overview --> current activity) showing wrong(negative) values like:

Physical Reads KB/sec :613,482,094.600-

Lazy Writes/sec :2,008.850-

CPU Busy/sec :6,707,473.359

IO Busy/sec :6,710,287.843

Full Tab/Idx Scans/sec :214,582,648.200

Index Range Scans/sec :213,887,218.450

What i have tried till now:

1) sp_updatestats after database upgrade.

3) Regenerated the programs running behind ST04_MSS.

2) at SQL server, DBCC UPDATEUSAGE (0)

3) Unload and Reload SQL server performance counters using latest "SQLCTR.INI".

4) Restarted the operating system, SAP Application and SQL Server.

But unable to resolve the issue.

We have ECC6.0 with MSSQLSERVER2005 SP3

SAP_BASIS 701 level 0007 with SAPKB70107 highest support package.

Please guide.

Thanks in advance.....

Regards

Surjit

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184473
Active Contributor
0 Kudos

Hello Surjit,

Which is the kernel and DBSL are you using (SM51 -> Release notes)?

Have you restarted your database server?

Regards,

Eduardo Rezende

Former Member
0 Kudos

hello Eduardo Rezende,

We have SAP Kernel: 701_REL with patch number:111 and DBSL patch number:105

And Yes, I restarted database server but it introduced no change at all.

Regards

Surjit