Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    Naples (Italy)
    Posts
    1

    Unhappy Unanswered: performance problems with SQL 2K SP3

    I am having big performance problems afters applying SP3 for SQL Server 2000 Enterprise Edition.
    We have a large query generated by Crystal Reports involving about 20 tables and views with joins and outer joins.
    The largest table have 100000 rows and is 20 Mb large.
    If I run this query on SQL server without service pack, it takes less than 1 second, with SP3 it takes more than 2 minutes!
    I found a workaround, copying all data selectes by the larger view into a table and using the table instead of the view in the query.
    I looked at execution plans and it seems an optimizer bug of SP3.
    Someone could help me, please?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Have you checked SP3a readme for any fix.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100
    Have you verified you applied SP3a NOT SP3?

    SP3 had an Slow ODBC bug in the client part of it.

    Tim S

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •