Post reply

Database Performance Issue

  • December 17, 2005 at 8:23 pm

    #110501

    Hi,

    I am facing the Database performance issue, it is very slow. The size of my data is about 1 GB. but the data retrieval and accessing performance is very slow, most of the times it gives timeout expired to the users. and we have 50-60 users accessing data at a time.

    Please help me what areas i have to focus on in order to improve the performance and execution time.

    I shall be very thankfull if you provide me a solution.

    With Regards,

    Noman

  • December 18, 2005 at 7:59 am

    #610230

    Please post this in the performance forum, rather than here. This forum is just for discussions of the question of the day.

    There could be a thousand reasons for slow performance - poor queries, insufficient hardware, clogged network, bad indexing, etc, etc

    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 2 (of 2 total)

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