How to increase application performance with Centralised SQL Server
-
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 VB.net 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?
-
Answer:
You should evaluate your indexing strategy on the table being accessed. This can greatly affect the efficiency of the queries that are looking up information in your database. http://technet.microsoft.com/en-us/library/jj835095.aspx
user1403070 at Database Administrators Visit the source
Related Q & A:
- How to control the excessive use of ram by SQL Server?Best solution by Database Administrators
- How to connect Sql Server Database from android app?Best solution by Stack Overflow
- How to upgrade sql server express 2005 to 2008R2?Best solution by Server Fault
- How Do I Configure SQL Server 2005 Backend?Best solution by Server Fault
- How to present large dataset from a SQL Server query?Best solution by stackoverflow.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.