Increase performance while publishing the project

Question

1.00/5 (4 votes)

See more:

I am using linq to SQL concept.My performance in the local is working fine.When I publish the project and install the application in server it is getting too slow.Can anyone provide the solution for it

Posted 18-Jan-16 17:40pm

fakeer muhammed

Add a Solution

Comments

dan!sh 18-Jan-16 23:58pm

Not really. We cannot access your server to tell exactly what is going on. I can provide some pointers though. Enable tracing and profiler to see what is taking time. Check resource utilization on the server to see if you need more hardware. Check the network if travel time is making things slower.

Sergey Alexandrovich Kryukov 19-Jan-16 1:54am

When you deployed the application, improving its performance is a bit too late. :-)
—SA

fakeer muhammed 22-Jan-16 5:28am

what should i do now?

Sergey Alexandrovich Kryukov 22-Jan-16 10:39am

:-)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

koolprasad2003 · Answer 1 · 2016-01-18T20:10:00

Solution 1

Observe which page loading/which page operation is slow ? or entire site is slow. There are multiple factors behind site gone slow.
some of them are
1. Slow SQL connection (this is most common reason) try connecting sql with comptername rather than IP address or vice varsa
2. Net work traffic
3. Antrivirus checking
4. RAM capacity
5. Memory assign to SQL

Posted 18-Jan-16 20:10pm

koolprasad2003

Comments

fakeer muhammed 22-Jan-16 5:27am

how to solve the Memory assign to SQL

koolprasad2003 22-Jan-16 6:29am

To set a fixed amount of memory

1.In Object Explorer, right-click a server and select Properties.

2.Click the Memory node.

3.Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory.

Use the default settings to allow SQL Server to change its memory requirements dynamically based on available system resources. The default setting for min server memory is 0, and the default setting for max server memory is 2147483647 megabytes (MB). The minimum amount of memory you can specify for max server memory is 16 MB.