none
SQL Server 2000 std Report Performance Issue

    Question

  • Dear All,

    I have a VB based desktop application with back end MS SQL server 2000 database with server machine ibmx5650 with specs intel xeon 2.7GHz (24 CPU's) & 24GB RAM.

    There are two things i need help:

    1. Recently we have upgrade the SQL server from 2000 personal edition to the 2000 standard edition. There comes a problem with one of the Report in the application. The report took almost 30 mins previously in SQL 2000 personal edition.But after the upgrade  to Standard edition we are unable to view report before 3 hours even sometimes it doesn't appear after several hours.
    2. Secondly for brief testing i have installed the personal edition on a simple PC rather then a server PC specs are corei5 & 4 GB of RAM. The same report is generated in only 15 mins from the application with this desktop machine as DB server.

    Please help me out i have gone through all SQL Server & system performance log of my server machine everything is normal but the report is taking too long & i can only generate that report from personal edition.

    Is there the difference due the higher corei5 processor in desktop machine or there is any other issue behind this.

    Your prompt response is highly appreciated.

    Regards,

    Rashid Ali

    Friday, May 16, 2014 8:41 AM

All replies

  • Hello,

    SQL Server 2000 is not support since 2013. Please upgrade to SQL Server 2012 to get better performance and support.

    Thanks for your understanding and support.

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Thursday, May 22, 2014 9:51 AM
    Moderator