Post reply

slow sql server

  • July 25, 2005 at 8:30 am

    #110788

    Hi, I would like to ask you about big problem in our organization. I tryed to shrink the database, and reindex all indexes of database. Then I ran complicated skript for selecting some data from databse. Befor shrinking it takes 11 minutes, after that and after reindex only 20 seconds !

    That's quite nice, but. . .

    When the server searches throught many indexes - this performance was improved. But the searching throught one or more table not. In some cases the overall performance was improved, but there is still some functions, which take a long time.

    Database is running SQL server 2000, and the server has the best hardware configuration with RAID 5 and 10. And when I try another server only with RAID 0 in other organisation, the overall process ist lookable faster.

    Could it be cluster server ? We are using microsoft cluster sql server.

    I don't know . . .

    How can I improve performance:

    defrag and reindex database, defrag disks, shrink databse and what else ?

    Server has enought space for databases, temp files, enought system RAM, expensive RAID array.

    But the cheap server for few dollars is lookable faster than the expensive one.

  • July 25, 2005 at 8:43 am

    #576820

    Is it just slow all over? Or slow on retreival of data, altering and entering data?

    Try running SQL Profiler, filtering on duration. I would start with a Duration > 10000 (that means 10 seconds).

    Any single statement in SQL should run in less than that. Once you narrow down where the problem lies, it will be easier to fix.

    Good luck,

     

    Sara

     

  • July 26, 2005 at 1:39 am

    #577077

    HI,

    also you should do a sp_createstats and sp_updatestats, perhaps every night, or weekly if the amount of Data does'nt grow so much.

    karl

    Best regards
    karl

  • July 26, 2005 at 7:36 am

    #577155

    Hi,

    I am not sure your system is slow in which area.

    Have you checked your execution plan for all statements that you are running?

    Hm .... did you check whether your indexes are needed? or, your table statistic is up to date?

    did you do sizing on your database? do you have any idea on how many transaction per second in your system?

    is your data organised in multiple data files/file groups?

    hm .... i can't imagine how slow is your system.

    anyway, if you can put your system in a test environment and create a profiler to identify which area is slow, that should be helpful.

    hopefully this will help.

    Leo

  • July 28, 2005 at 3:57 am

    #577804

    Well, are the two servers containing the same data and the same data structure? Could it not just be a result of poor database design?

    //Hans

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

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