on 04-19-2007 5:05 PM
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.
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)"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.