My question is: I might have implementation for over 350 concurrent users, using the application at the same time. How can I verify that SQL Server will not face any performance issues? Any particular specifications for the Server that SQL server will be installed upon? should I use multiple File Groups, or seperate Log File on a Hard disk and Data file on another Hard disk?
Please if you have any documentation that provide real time performance testing of SQL Server with more that 350 users, it would be a great help.
P.S: My database is small (about 130 tables), most of them are only listings (users, permissions...) and mainly I have about 5 tables which will contain data incrementally.
Thanks all,
Regards,
Kamel BalquisThere is no stock answer that can be applied to your situation. There are too many factors that can affect your system.|||This is exactly what I want to know, what are these factors? Server performance? RAM Size, Hard disk speed? Multiple file groups?....?
No comments:
Post a Comment