Post reply

Conversion from SqlServer2000 to 2005

  • April 15, 2009 at 3:48 am

    #131278

    I have a compatibility issue with the SQL-Server 200 to 2005 and put together a strange looking script using DMV's,

    want to know if what i am doing is correct and if i am on the right track.

    There are two attachments and a SQL-Server execution plan,

    1) process_1.sql is having two statements one is sqlserver2000 and one SQL-Server 2005 version.

    2) locks_1.sql is having the same one 2000 and one 2005 version statements.

    3) i have a execution plan for the locks strangle i have a huge amount of data being shown and the arrows are very big in size. even though if we execute each one of them it doesn't yeld more than 30 records.

    sql 2000 performs much better than 2005.

    Q1: Am i on the correct path, is there any sugessions to improve it.

    Q2: Why is the performance so bad with dmv's

    Q3: Please advice if i need to change my view on dmv's on how i am using it.

    Many thanks.

    Regards
    Vinay

  • April 15, 2009 at 11:09 am

    #978264

    No Reply ?

    Regards
    Vinay

  • April 15, 2009 at 1:59 pm

    #978377

    Did you update statistics after the upgrade?

    There's no need to bump your post after just a few hours. This is not a chat room, also some people are away due to easter. Be patient.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 15, 2009 at 2:16 pm

    #978391

    Sorry for bumping in to it again,

    I belive the dba is going to do this work. this is one of the proc which we used to get the process information on the sqlserver 2000 but we want to take the same information from sqlserver2005 box and dont change the app,

    so i wanted to make sure that i am not writing some thing wrong.

    Regards

    Vinay

    Regards
    Vinay

  • April 15, 2009 at 2:31 pm

    #978402

    Updating statistics and potentially rebuilding indexes that might be fragmented are two things you'd need to do to see what else might be wrong. Most things run better in 2005, but there's always the possibility this won't. I would be surprised, however, if that were the case.

    Is hardware the same?

  • April 15, 2009 at 2:37 pm

    #978408

    could you plese look at the sql scripts i belive the sql script will tell whats my issue. The issue is not with performence the issue is realy with the conversion code and a code review for the two files.

    Thanks in advance.

    Regards

    Vinay

    Regards
    Vinay

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply