application user and sql login

tanvir Ahmed

10y957.NET

I have develop a web application in MVC4 it is a application about credit and financing. Application is used by 40 to 50 users at a time. Application reporting is very heavy takes 2 to 3 minutes in generating.
I am using single db user 'sa'
Now I am thinking to create all application users in server 2008 also.
Each application user will connect with own db user not with 'sa' user
my question is that is It right decision?
It will increase my application performance? If it is not right then how i can increase its performance? as 40 users taking reports with single 'sa' user may be take more time instead off each user taking with its own database user .

Please urgent help is required

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
I am not sure it help you to improve performance.
Before implementing steps, first try to find out the root cause then only you can take better decision. Secondly you are dealing 40-50 users so should work fine. Check whether it is a network problem, memory issue, Query take more time to execute..
Nitin Sontakke9y ago
I don't believe that it will help. Do you have a data in hand which indicates that the performance downgrades as more and more users are connected to the db?

In my opinion, it is to do with the way queries are written, tables are designed, pk and fk applied, stored procedures used are not, how many round trips are being made to db, etc.

These things will be my first line of attack.

Have you already ruled these out?
Prakash Kumar9y ago
Hi Tanvir,
Yes by splitting the user role we can increase the performance, Please refer the below link
https://azure.microsoft.com/en-in/documentation/articles/sql-database-manage-logins/
Pradeep Sahoo10y ago
Yes , you can try that
Please do a load testing with visual studio to check the performance on loading around 10 to 20 users to check how it works.
Bikesh Srivastava10y ago
as per my experience you are doing good.