November 29, 2008 at 12:07 am
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
November 29, 2008 at 4:20 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply