production server slower than development server

  • Hi,

    I have a select query from a table which has a column with huge data. The select query takes 14 secs in the development server but the same query takes 70 secs in the production server.

    To simulate the issue, I created the following script and tested in both the environments

    create table Testperf

    (col1 varchar(5000) )

    declare @i int

    select @i = 1

    while @i <= 1000

    begin

    insert into Testperf

    select replicate('Bravo',600)

    set @i = @i + 1

    end

    select * from Testperf

    Normally any company will have production server highly configured than the development server. So in that case how this could happen?

    "Production server slower than development server".

  • Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspx

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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