Iniciar sesión
 
InicioBibliotecaAprendizajeDescargaSoporteComunidadForos
Recursos para Profesionales de TI >
> 
> 
Point of sale runs fast with 2005 wrkgrp but slow with 2008 r2 wrkgrp

Answered Point of sale runs fast with 2005 wrkgrp but slow with 2008 r2 wrkgrp

  • viernes, 01 de junio de 2012 16:52
     
     
    Inicie sesión para votar
    0

    Point of sale programs uses sql database and runs well with 2005 wrkgrp but lags with 2008 r2.  scanning a barcode into an invoice can take up to 10 or 15 seconds w/ 2008 r2 but is almost instantaneous with 2005.

    Server has an asus p7f-x with a built in intel 5 series/3400 sata controller, intel core i7-870 processor, 8 gigs of mem, 4 wd 500 gig drives, running win server 2008 r2 std

    server runs great except for the pos application (positive retail manager)

    have changed out all hardware and reinstalled os several times, tried raid 10, 1, 0 and ahci and performance is always the same.

    is any one aware of a chip set conflict with sql 2008r2 wrkgrp and intel controller?

    pos application is not very processor intensive speed is more a function of disk access.

    Thanks Tony

     

Todas las respuestas

  • viernes, 01 de junio de 2012 19:24
     
     Respondida
    Inicie sesión para votar
    1
    • Are you sure that all indices in 2005 are there in 2008 R2 ?
    • Did you update statistics ?\
    • Can you compare the execution plan ?
    • What are the resources (memory/processor) available for both instances ?

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    • Marcado como respuesta Tony POS lunes, 04 de junio de 2012 17:15
    •  
     
  • lunes, 04 de junio de 2012 15:58
     
     
    Inicie sesión para votar
    0

    Thanks for the reply.

    I don't know if the indices in 2005 are in 2008.  The point of sale app. has a utility that creates indices and I have run that in both cases, but don't know how that compares.

    I have not updated statistics... don't know how, but I will look into that.

    The execution plan I believe is comparable.  I built this server for a liquor store and the performance has been poor from the beginning.  To trouble shoot I used my (I own a liquor store also) database and pos app (our pos apps are the same version) on the server and it ran poorly with sql 2008 r2.

    The server in question has an asus P7f-x mainboard, 8 gigs of samsung mem., an intel i7 - 870 , with 4 500 gig west. dig. hard drives... i've normally run the drives for a system like this using raid 10 (striping and mirroring)... but have tried every other combo avail with this board and the results are always the same.

    I run my small store on a msi g41m mainboard, intel e5200 2.5 dual core, 2 gig mem and a wd 320 gig hd using sql 2005 wkgrp.

    That config out performs my same pos app and database on this new server if I use sql 2008 r2 on the new server.

    I know I didn't answer all your questions but does this info help any.

    Thanks Tony

     
  • lunes, 04 de junio de 2012 17:35
     
     
    Inicie sesión para votar
    1

    Can you execute the query in below link against both databases to list all indices

    http://stackoverflow.com/questions/765867/list-of-all-index-index-columns-in-sql-server-db

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.