Key Factors to Look when number of users grow

  • Hello All,

    MY SQL server supports some internet facing applications and is running fine at the moment. However after a month the number of users using the appication is expected to grow by the factor of 10.

    So, as a DBA what could I do to make sure that the SQL server perfoms as smoothly as It is right now. What would be some key factors or counters that I should be looking at, like processor etc..

    Thanks In advance

  • That's a pretty open question.

    On the hardware side, make sure that you have planned for the new users and have capacity. eg if your CPUs are currently running on average 80%, then you have a problems, etc. Look what resources the system is currently using (for all hardware resources - memory, CPU, betwork, disks) and see if you think it can stand 10x more utilisation.

    On the database side, make sure that the queries are as optimal as possible and the indexes are appropriate for the queries. If they're not you will get massive blocking and perhaps deadlock problems as the number of users increase.

    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