Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I’m trying to get my head around to make better way to increase the performance of my application System based on single SQL Server with 50 clients tablets pc(its connected to local wireless). my application is winform and its used 4.5 framework. Client’s tablets are rapidly accessing to centralise SQL server for transactions. currently System is working without any interruption but sometimes users are complaining about its slowness

I think problem is its concurrently accessing the same tables. To reduce load i tried Two ways but both are failed

1) I created CSV file based on SQL table then tried to accesses that- Fail because it’s not updated.

2) Tried to replicate the tables in to locally installed SQL Server(Tablet)-Fail Tablet is not strong enough to run SQL Express

Any ideas?


migration rejected from Apr 15 '14 at 23:09

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Mark Storey-Smith, Paul White, RolandoMySQLDBA, Kin, Max Vernon Apr 15 '14 at 23:09

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Tip of the iceberg - the question or comments reveal an underlying issue that would need extensive investigation by a consultant or database vendor support team: issues like this do not fit the SE Q&A model well. For more information see this meta post." – Paul White, Kin, Max Vernon
If this question can be reworded to fit the rules in the help center, please edit the question.

This site is for programming questions. DB optimization/design is offtopic. Try the DBA SE site. – Marc B Apr 1 '14 at 14:45
What is your DAL Look like? Are you using Entity Framework? – Anon Apr 1 '14 at 14:46
You are going to have to start pulling instrumentation from the DMVs as to what is running slowly - and then with that information + schema you will be in a position to ask a more direct question. – Andrew Apr 1 '14 at 14:47
Like all performance issues - first find out what is slow - are you waiting for slow SQL queries (where indexes, etc. may help), is it network latency, or is your application taking a long time to process data client side. Once you understand this, the performance issue should be able to be attacked – Rowland Shaw Apr 1 '14 at 14:48
Consider Indexing, Stored Procedures, Caching on app side. There is some ammo to Google. – Anon Apr 1 '14 at 14:49