on 08-23-2011 5:36 AM
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
Hello Surjit,
Which is the kernel and DBSL are you using (SM51 -> Release notes)?
Have you restarted your database server?
Regards,
Eduardo Rezende
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.