SAP DB02 unusual screen observered

[Former Member]

Dear All

My Database is MISSAL 2005 CC , in T.code DB02 i have seen unusual screen to the normal one, (missing table index) button is not seen please tell how restore to normal view.

Thanks in Advance

[Former Member]

is the "Missing Tables and Indexes" option is disabled ? If it is disabled then you are having limited permissions.

for example check this pic link: [http://twitpic.com/2iq18b] (Here "SQL Command Editor" option is disabled due to limited permissions).

Thanks

Mushtaq

[Former Member]

Dear Mustaq,

Thanks for valued efforts, I presently

Please note

1. SQL server 2005 -DB02 displays missing index under tab diagnostics, it shows 352 not created? please advise on the same, creating secondary index will improve performance.

2.under Rz20 -SQL server monitor- open alerts -( PRDDATA- Auto growth,PRDDATA stat in MB, PRDDATA Free disk space ,PRDdata1 0% free space) first 3 show green color , last one shows red color.

Regards

HJS

[former_member184473]

Hello HJS,

Are the missing indexes BW indexes? If yes, you can use report SAP_INFOCUBE_INDEXES_REPAIR.

Which is your SQL Server release (version with SP)?

Regards,

Eduardo Rezende

[Former Member]

Dear Eduardo Rezende

Thanks for your reply , please note - ECC 6 -SQL server SP1

Regards

HJS

[former_member184473]

Hello HJS,

Are you using SQL Server 2005 SP1? If yes, this combination is no longer supported by SAP as per note [62988|http://service.sap.com/sap/support/notes/62988|Support Packages for Microsoft SQL Server]:

9.00.1399 SQL Server 2005 RTM

9.00.2047 SQL Server 2005 Support Package 1

9.00.3042 SQL Server 2005 Support Package 2 (see 1)

9.00.3228 SQL Server 2005 service pack 2 CU6 (see 2)

9.00.4035 SQL Server 2005 Support Package 3

(1) : Microsoft's SQL Server client library SNAC contains errors in Release SQL Server 2005, Support Package 2. To avoid data inconsistencies, you must import the latest SAP kernel. For more detailed information, see Note 1067103.

(2): For JAVA systems, SAP recommends that you install at least Cumulative Update 6 for SQL Server 2005 service pack 2. For more detailed information, see Note 1155989.

Regards,

Eduardo

[Former Member]

Dear Edurodo

Thanks for your reply please note I have gone thru note and set the same, but till now my data file reads as

1. SQL server 2005 -DB02 displays missing index under tab diagnostics, it shows 352 not created? please advise on the same, creating secondary index will improve performance.

2.under Rz20 -SQL server monitor- open alerts -( PRDDATA- Auto growth,PRDDATA stat in MB, PRDDATA Free disk space ,PRDdata1 0% free space) first 3 show green color , last one shows red color.

Please suggest.

regards

HJS

[former_member184473]

Hello HJS,

Have you updated your database?

Are this BW indexes? If yes, you can use report SAP_INFOCUBE_INDEXES_REPAIR to recreate those indexes.

To eliminate the red color you can increase the size of the particular data file. Check note [363018|http://service.sap.com/sap/support/notes/363018|File management for SQL Server] for further information.

Regards,

Eduardo

[Former Member]

Dear Eduardo,

1.Thanks for your reply, as suggested SAP NOTE 36301, my server space in Drive 😧 displays 70% free space, moving tempdb file to new location vill it solve the issue. plz advise further to improve the performance

2. In my previous message I have mentioned 352 index to b created, (**plz note this ERP ABAP server)this is now BW/ BI server. Shall ve further check the info cube repairs? please suggest further to improve the performance

regards

HJS

[Former Member]

please note the small change this should read as not BI/BW server

Regards

HJS

[former_member184473]

Hello HJS,

You can use transaction SE14 to recreate the missing indexes.

If after you have recreated the indexes you still face some performance issue, check transaction ST04 -> I/O Performance, if you observe high read and write values (bigger than 15) your performance issue could be caused by your I/O system.

Check note [987961|http://service.sap.com/sap/support/notes/987961|FAQ: SQL Server 2005 - SQL Server 2008 I/O performance] for further information.

Regards,

Eduardo Rezende

[Former Member]

Dear Eduardo Rezende

Thanks for your reply, Please note I have recieved one more message from SAP Expert please justify,

1. My physical HDD space 😧 Drive has sufficient space available

but as per SAP suggestion they are asking to move Tempdb file to new location.

2.under Rz20 -SQL server monitor- open alerts

PRDDATA- Auto growth,

PRDDATA stat in MB,

PRDDATA Free disk space

PRDDATA 0% free space -

first 3 displays green color , last one displays red color.

PLZ tell if we move to new location will this solve my problem and improve performance. is advisable if my Disk space shows sufficient space.

Regards

HJS

Edited by: apspaul on Oct 30, 2010 2:14 PM

[Former Member]

This message was moderated.

[Former Member]

Hi,

"PRDDATA 0% free space " is not related to disk space. It indicates that you have 0% free space inside that data file.

Increase the data file ([link|http://msdn.microsoft.com/en-us/library/ms175890.aspx])and maintain certain amount free space in all data files, and also enable auto growth just in case, but don't depend on autogrowth.

Thanks

Mushtaq