How to increase application performance with Centralised SQL Server?
Let’s learn how to increase application performance with Centralised SQL Server. The most accurate or helpful solution is served by Database Administrators.
There are ten answers to this question.
Best solution
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...
Answer:
You should evaluate your indexing strategy on the table being accessed. This can greatly affect the...
user1403070 at Database Administrators Mark as irrelevant Undo
Other solutions
I have a mvc3.0 application that is using a database on SQL Server 2008 R2 on a server machine that has Windows SQL Server 2008 OS. It seems that the performance is not as good as I expected to be at least when compared to MYSQL. Do you have any recommendations...
Answer:
Become familiar first with SQL Server Profiler - a tool that can help you isolate slow performing queries...
Joel Askey at Quora Mark as irrelevant Undo
My experience today is on GlassFish Application Server but it should be applicable to other application servers. I had a webapp serving REST APIs. It had large amounts of logging using log4j logging to stdout. I checked the CPU usage on a per thread...
Answer:
Some possible reasons: Logging may flush the output and syncs to the filesystem per log line. This...
Miguel Paraz at Quora Mark as irrelevant Undo
Hi everyone, My name is Michael Solovyov and I'm the co-founder & CTO of a rails-based start-up. We have built a product for other businesses to help their users adopt their products. We've built the application, delivered to a few customers and...
Answer:
The answer from Vladimir Legkunets is basically what I would tell you to do in order to begin diagnosing...
Chris Kottom at Quora Mark as irrelevant Undo
I'm in charge of testing performance of SQL server right now. With large concurrent user, 15-600 , is there anyway to make this happen? You can't make your friends or anyone that help you at the same time.
bluebloo... at Yahoo! Answers Mark as irrelevant Undo
Hi guyz,,,,,i have a windows 2k3 server installed on a highly configured machine with SQL server 2000. Ok so recently we had developed our intra net application on .net and testing on this server. my question is , should i keep SQL server on the same...
Answer:
see this is a case of 2 tier architecture if u r server (database) is expected to have a lot of load...
Ah C at Yahoo! Answers Mark as irrelevant Undo
I am working on a social networking portal. Its almost complete but now the issue is its performance. I am very much worried about its performance. There re loads of things on the side like video & snaps sharing, uploading and playing etc. I heard...
parul_it... at Yahoo! Answers Mark as irrelevant Undo
I have an application whose database will soon grow beyond the 2TB limit of its disk drive. I have additional drives available to me, each with 2TB of space. What I would like to do is split this database across 2 drives, with some of the tables on drive...
Answer:
Here's a discussion on MSDN with appropriate links on how to add files and use DBCC SHRINKFILE to force...
DWRoelands at Ask.Metafilter.Com Mark as irrelevant Undo
I am marketing a website that provides bespoke software in the UK. I think that some original articles are required to add bulk to the website and increase it's usefulness as a resource. The article should be between 300 and 600 words and should contain...
Answer:
Hi bvandyk-ga, I've managed to use all your phrases, but it's somewhat repetitive in places as a result...
bvandyk-ga at Google Answers Mark as irrelevant Undo
Curriculum Vitae Surname Name: Date of birth: Address: Tel(home): Tel(mob): E-mail: Nationality: Sadigov Tural 21 april 1986 Azerbaijan/Baku S.Dadashov st 65/105 +994(012) 510-04-69 +994(055) 473-22-61 tsadigov@hotmail.com Azerbaijani Characteristics...
Sultan at Yahoo! Answers Mark as irrelevant Undo
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.