cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrading SQL2005 problem

Former Member
0 Kudos

Last month I upgraded our SQL Server 2000 to SQL Server 2005.

There are some programs to upload big tables onto the DB. The execution of these programs is now 8 times slower than one month ago, and the only change made is the DB upgrading.

Any help? I'm trying to see any problem on DB, but all seems to work fine.

Thanks.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Albetro,

You need to check for INDEXes. if there are any indexes involved please rebuild them with "ALTER INDEX ALL ON <table> REBUILD WITH (ONLINE, MAXDOP = degree of parallelism desired)"

Former Member
0 Kudos

Thanks!

I suppose the problem is to rebuild the indexes. I had a job but I have create a new maintenance plan that is going to be executed tonight. I'll tell you tomorrow if the problem is solved.

Former Member
0 Kudos

I planified a maintenance plan which rebuilt and reorg. all indexes, but these plan failed I domn't know why:

Date 4/28/2007 9:00:00 AM

Log Job History (Reorgindices)

Step ID 1

Server AINSA

Job Name Reorgindices

Step Name Reorgindices_Subplan_Job_Step

Duration 13:24:42

Sql Severity 0

Sql Message ID 0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted 0

Message

Executed as user: admin . The package execution failed. The step failed.

any help? system is going still slow.

Former Member
0 Kudos

Hi

Can you post the SQL Error log for a few minutes before and after 4/28/2007 9:00:00 AM

Also post the output of select @@version and sp_configure

SAP on Win/SQL systems do not greatly benefit from Reorganization.

I recommend you read 159316 Reorganizing tables on SQL Server SQL 2000/2005

Thanks

N.P.C

Former Member
0 Kudos

Hello again.

These days I have reinstalled SQL 2005 with SP1.

I attached to my Database DEV but SAP doesn't start.

Now the problem is the database login. User dev has no Login Name in the DataBase.

I have to delete it and create again???

Former Member
0 Kudos

Hi

Can you advise if your program that is now "8 times slower" is a customer written ABAP program or a SAP standard program?

You might need to do a trace on the program - check the access plans. The optimizer logic does change between DB versions (and indeed service packs).

Problems such as you describe are very rare - I would be very interested to hear more about your problem.

Thanks

N.P,C

Former Member
0 Kudos

Can you give us a clue on the table sizes?

Unicode none unicode?

Software version?

32 or 64bit and version?

OS software and version?

Have you dropped all the SPs?

Have you run the stats update?

Have you done a DB reorg?

Former Member
0 Kudos

OS: Windows 2003 SP1

32 bit

I did all that SAP notes tell about this upgrading.

I remember dropping all th SPs and run stats update, but nothing about DB reorg

I had some weekly jobs for SQL2000 programmed by a consultant, between them one that runs a DB reorg, but I'm not sure this job works fine for SQl2005

Please, could you tell me how to do it?

FYI, the programs I run are Z-programs.