DB02 running very slowly after SQL 2005 Upgrade!

[Former Member]

Hi All

I have reciently upgraded our DEV ECC6 system to SQL 2005 and everything seemed ok - no problems really! However when we run DB02, to retrieve DB information it is taking about 4 to 5 mins to appear. This is obviously not good!

Has anyone else had this problem, and if so is there something that needs to be done?

Thanks

Phil

[Former Member · Accepted solution]

Hi Phil,

Have you ensure that all the standard background job as per note 16083?

Thanks and Regards

• Point reward is much appreciated

[Former Member · Accepted solution]

Yeah they all seem ok!

Should any of those jobs help the DB02 details?

[Former Member]

Phil,

Have you refer to Note 333458 - Deleting obsolete stored procedures in SQL Server

as well? I believe this might help you.

Let me knows the outcome.

Thanks